Inventory Report Help

[LDR]

I am working on a report that will reflect inventory levels in the warehouses we have. I have a problem when a customer has issues a release order for cargo to be shipped out. It doubles my lines and therefore it throws off my subtotals and grand totals. How would I show a release order against cargo in stock with the appropriate numbers?

If you look at the report sample below and look at the line for the Bill of Lading GBULAPA051ITJ13B you will see this cargo has two didrent release for diffrnet amounts but will also see how it doubles up all the other numbers on me.

This report is created from a stored procedure based on tow tables from a MS SQL server.

http://www.mojowares.com/sample_report.pdf

Thanks!

 

[dgillz]

This is a common problem with a many-to-one relationship.

The following solution will work if you are on crytal 8 or newer.

Create a group by Bill Of Lading #, and insert Maximum()summaries instead of sums to avoid duplication. Hide the details section. This will make you only see one record, but your other group totals and grand totals will still be inflated.

Take care of this by using running total fields, evaluate on change of group = BOL#, reset on change of group = your other group (for that groups total) or never (for the grand total).

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[LDR]

I see what you are talking about - it is going to take me some time to rework the report as I only have one group (customer, and that is hidden right now). I will add the Bill of Lading as my 2nd group by.