Greetings; Here is an example of what I am trying to do.
In the Main Report is the description of a car and a base price. In a subreport is a list of options and the associated costs. The srpt detail is grouped by the Date the Option(s) were added or deleted and a new page is generated for each date. So if a customer comes back several times to add or subtract options, the date is tracked. The srpt is grouped by Tracking Date and is displayed in the srpt Header.
Here is the problem:
At the beginning of the detail for the first date, I want to show the Base Price. At the end of the detail, add the price of the options to the Base price. The next date break shows the Last Ending Balance at the beginning of the detail. And again, at the end, sum the Last Ending Balance plus the current detail, and on and on until the car is sold which could be over several dates.
I have the Running Sum for the detail and the Page Break figured out. I'm stuck on forcing the totaling when the date changes.
Any suggestions are appreciated.
Thanks
In the Main Report is the description of a car and a base price. In a subreport is a list of options and the associated costs. The srpt detail is grouped by the Date the Option(s) were added or deleted and a new page is generated for each date. So if a customer comes back several times to add or subtract options, the date is tracked. The srpt is grouped by Tracking Date and is displayed in the srpt Header.
Here is the problem:
At the beginning of the detail for the first date, I want to show the Base Price. At the end of the detail, add the price of the options to the Base price. The next date break shows the Last Ending Balance at the beginning of the detail. And again, at the end, sum the Last Ending Balance plus the current detail, and on and on until the car is sold which could be over several dates.
I have the Running Sum for the detail and the Page Break figured out. I'm stuck on forcing the totaling when the date changes.
Any suggestions are appreciated.
Thanks
