General information
Category:
Reports & Report designer
>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..
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only