>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

Best way is to calculate totals and percentages before only and then show it in your report...

There is a kb article on ms sites which explains this..