Crystal Reports

We are running a report based on Sales Analysis, using the SRW90 Transaction table (among others).

We are displaying Item #'s and various stats, based on date & customer ranges.

We now want to add the current Qty On-Hand for each Item in the report. Which table do we add to the report?

I see that there is a table: Quantity by Locations.
My question however, is that it is referencing "ICW65". Are we really still using 6.5 tables in this case?

Hi Samuel,

Are they using mutiple locations or just one location?

Hi Sam

Expanding on Andrew's question, if they are interested in adding the QOH for all locations, then the table to use is the ICW65 Items table and create a formula which sums up the five QOH buckets.

If they want the QOH for selected locations, you would be FAR better off doing the report in GridView. Doing it using Crystal Reports would require creating a sub-report, and this will tremedously slow down the performance of the report.

Steve

Andrew & Steve:
Thanks guys - this is helpful.