Report Builder - Help

Yahoo Archive
1
Thank you, Rick. I never have had the need for a Left Outer Join. It
worked. My reports now reconcile.

Thank you, again. I will remember that for future reports.

Jim Dodd
la Calhène, Inc.
320-358-0554


-----Original Message-----
From: Rick Lane [mailto:rickl@...]
Sent: Monday, June 03, 2002 11:03 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder - Help

My guess would be that you may have some Customers without a Customer Group
assigned to them in the customer master table. This can be solved by making
the join between the Customer and CustGrup table a Left Outer Join.

However, you could just modify the initial report as well, and add the
CustGrup table linked to the Customer table with a Left Outer Join and
change the groupings of that report.

This would seem like the most obvious potential problem, but you never know.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 03, 2002 11:53 AM
To: Vantage (E-mail)
Subject: [Vantage] Report Builder - Help


I am looking for someone to point me in the right direction with my report I
have written.

I am trying to write a report that I will call "Bookings by Market". I am
using the customer group field as my market designator.

I already have a Bookings report that works. It summarizes the order
bookings by Product Group. When I run both reports, my Market report does
not total to the same value as the Product Bookings report. I think the
problem is in the joins.

The Product Group Bookings report has the BookDtl table as the master table.
It is joined to the BookOrd table and the OrderDtl table. The BookOrd table
is joined to the Customer table. This report has been confirmed to report
the correct Bookings total by a manual log kept in conjunction with the
report.

Now, the Market Bookings report has the Customer table as the master table.
It is joined to the CustGrup table and the BookOrd table. The BookOrd table
is joined to the BookDtl table.

I hope this is enough information for someone to help identify my error.
Please contact off list if wish.

Thank you,


Jim Dodd
la Calhène, Inc.
320-358-0554
jimd@...
2
I am looking for someone to point me in the right direction with my report I
have written.

I am trying to write a report that I will call "Bookings by Market". I am
using the customer group field as my market designator.

I already have a Bookings report that works. It summarizes the order
bookings by Product Group. When I run both reports, my Market report does
not total to the same value as the Product Bookings report. I think the
problem is in the joins.

The Product Group Bookings report has the BookDtl table as the master table.
It is joined to the BookOrd table and the OrderDtl table. The BookOrd table
is joined to the Customer table. This report has been confirmed to report
the correct Bookings total by a manual log kept in conjunction with the
report.

Now, the Market Bookings report has the Customer table as the master table.
It is joined to the CustGrup table and the BookOrd table. The BookOrd table
is joined to the BookDtl table.

I hope this is enough information for someone to help identify my error.
Please contact off list if wish.

Thank you,


Jim Dodd
la Calhène, Inc.
320-358-0554
jimd@...


[Non-text portions of this message have been removed]
3
My guess would be that you may have some Customers without a Customer Group
assigned to them in the customer master table. This can be solved by making
the join between the Customer and CustGrup table a Left Outer Join.

However, you could just modify the initial report as well, and add the
CustGrup table linked to the Customer table with a Left Outer Join and
change the groupings of that report.

This would seem like the most obvious potential problem, but you never know.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 03, 2002 11:53 AM
To: Vantage (E-mail)
Subject: [Vantage] Report Builder - Help


I am looking for someone to point me in the right direction with my report I
have written.

I am trying to write a report that I will call "Bookings by Market". I am
using the customer group field as my market designator.

I already have a Bookings report that works. It summarizes the order
bookings by Product Group. When I run both reports, my Market report does
not total to the same value as the Product Bookings report. I think the
problem is in the joins.

The Product Group Bookings report has the BookDtl table as the master table.
It is joined to the BookOrd table and the OrderDtl table. The BookOrd table
is joined to the Customer table. This report has been confirmed to report
the correct Bookings total by a manual log kept in conjunction with the
report.

Now, the Market Bookings report has the Customer table as the master table.
It is joined to the CustGrup table and the BookOrd table. The BookOrd table
is joined to the BookDtl table.

I hope this is enough information for someone to help identify my error.
Please contact off list if wish.

Thank you,


Jim Dodd
la Calhène, Inc.
320-358-0554
jimd@...


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/