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
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!