Wnats to create a report from report builder

Yahoo Archive
1
Here is the process to follow:
Start with a table say shipdtl list some basic fields then view the report.
Add a join such as SHIPHEAD view the report.
Add a filter for date range part range or whatever, then view the report.
Add another join then view the report.

By reviewing the report after each step and recording the time it takes to
preview you will catch a bad join or a filter that is not on an indexed
field.

In the data dictionary viewer under FILE/VIEW RELATED TABLES use the indexs
to build your table joins along. Such as ShipDtl to ShipHead the indexed
fields displays COMPANY, PACKNUM.

Let me know where you get stuck.

Hope this helps.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a


-----Original Message-----
From: sharma_nalini@... [mailto:sharma_nalini@...]
Sent: Friday, November 09, 2001 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Wnats to create a report from report builder.


Hi everyone,
I want to create a report
for Vendor shipping and customer shipping and would like to have
fields group by customer and vendor and one report by part no.
For customers closed orders and for vendors parts recieved.

What should be my master table for both of them
And what tables i should join and join should be for which fields.

Just to let you know,
I tried to create a report for customer closed orders with
information Sales order num, PO num, Pack slip no. Dtae required and
date shipped, quantity ordered and Quantity shipped. and in summary
calulated teh total shippent and total quantity ordered and it does
not give me right report.

Master tables was shipdtl.
Joins were
Customer
Orderhed,
orderdtl.

Help will be really appreciated.
Can you please also tell me how we know that how we should make the
joins whenever we have to build a report.


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/
2
Hi everyone,
I want to create a report
for Vendor shipping and customer shipping and would like to have
fields group by customer and vendor and one report by part no.
For customers closed orders and for vendors parts recieved.

What should be my master table for both of them
And what tables i should join and join should be for which fields.

Just to let you know,
I tried to create a report for customer closed orders with
information Sales order num, PO num, Pack slip no. Dtae required and
date shipped, quantity ordered and Quantity shipped. and in summary
calulated teh total shippent and total quantity ordered and it does
not give me right report.

Master tables was shipdtl.
Joins were
Customer
Orderhed,
orderdtl.

Help will be really appreciated.
Can you please also tell me how we know that how we should make the
joins whenever we have to build a report.