>I am duplicating an old report for a client into their VFP application.. They have a column that shows the percentage for each detail line of the total sum of all detail lines. If I use a view to get the data and will be printing it with a starting and ending date parameter, how do I know in the report (or before hand) what the total for each section on the report will be so I can use it in the mathematical formula to figure it out for each detail line in that section (group)?
>
>Example:
>
>Administrative:
> Vacation 25.0 hrs 25%
> Illiness 12.5 hrs 12.5%
> Training 50.0 hrs 50%
> Excused 12.5 hrs 12.5%
> --------- -----
> 100.0 hrs 100.0%
>
>Thanks
Because you can't calculate that percentage until you have the total, the easiest way is to do it in code before you run the report. You can't actually do it in the report because the in VFP, reports are single pass.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer