>I am having trouble with the design of a particular report. This report is used as a job time sheet and is sent to customers with a copy of the bill. This report contains the following information Employee, Rate Type, Work Type, Day of the week, total rate and cost. The report is sorted by Date + Employee + Rate Type + Work Type. The report detail is lists as follows: Name (Employee Name), Rate Type (Type of Rate assigned such as In Shop, Off Site, Torch and Bid), Work Type (REG or OT), Thur, Fri, Sat, Sun, Mon, Tue, Wed, Total, Rate and cost. I have been able to create this report with one exception. The customer would like a total of each Rate Type + Work Type combination at the end of the report. I could do this by hard coding the value for the Rate Type field but I would rather not. These values can be defined by the users via master files and my change over time. I would like to come up with a solution that would allow them the flexibility of defining their own Rate Types without
>breaking the report. I am looking to display the totals similar to the following example:
>
>InShop OT 999,999.99
>InShop REG 999,999.99
>Torch REG 999,999.99
>Offsite OT 999,999.99
>Offsite REG 999,999.99
>BID REG 999,999.99
>
>They don’t necessarily need to be in this order, just a total of all printed combinations at the end of the report. Any help would be greatly appreciated.
How about selecting the summary information (SELECT ... GROUP BY) into a separate summary cursor, and showing this at the end. I understand VFP 9 allows you to manage separate detail bands. Perhaps you can make good use of this, but I don't know the details.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)