Summary Details

[Dale_Pearmain_(Guest)]

I am in the process of writing a report using two tables (Customers and Orders). The report is to show all Orders outstanding at a specific point - that^s the easy bit. What I need help on is the Summary which displays the customers and their total orders. I have tried conditional totals but because the Customers are in their own table (new ones being created/old ones deleted etc.) this will not work. Also the customers displayed should only be those who have orders outstanding as calculated in the first part of the report.____Anyone have any ideas on this?

[kfleming]

Is this what you want the report to look like?__CustA__ Order1__ Order2__CustB__ Order1__ Order2__CustC__ Order1____Summary__CustA $200__CustB $300__CustC $200____Kathleen__R&R Support

[DalePearmain]

Thanks for the response Kathleen but its not quite as required, whats needed is more like:____Order1 CustA $250__Order2 CustC $200__Order3 CustA $450__Order4 CustH $500______Summary__ CustA $700__ CustC $200__ CustH $500______Out of interest how would you write the report as you suggest so that only the selected Customers are displayed in the summary?______Thanks

[DalePearmain]

I assume by the lack of responses that this cannot be done.______Thanks anyway.

[Ted_(Guest)]

Hi Dale,____I tried to working on your problem, but I can^t find the solution in R&R itself. I just have one question, what database are you using? Thanks.____Ted

[kfleming]

To get there you would create a unique conditional grand total for each customer and place those totals in a summary band.__Kathleen__R&R Support

[DalePearmain]

Hi Kathleen,____I maybe missing something but how would R&R know when a new Customer had been added to the table? If total fields were created for each customer then every time a new customer is added a new total field would have to be created - is that correct? If this is the case then, as the person who uses the report prints directly from a desktop icon, they would have to get the report amended whenever a new customer is added, if at all possible we would like to avoid this.____The only other downside to this solution is that initially about 30,000 total fields would have to be created. I have written a similar report for outstanding orders for a month (with conditional total for each day) but this obviously only involved 31 totals.______Thanks__Dale

[kfleming]

The alternative is to create a second report that sorts/groups by __customer and then add a customer group footer for the totals.__You could print this summary report immediately after the detail report.____Kathleen__R&R Support