General information
Category:
Reports & Report designer
If you prefer to do it in the report, then you need to add a report variable and set appropriate "value to store", "initial value", "calculate" and "reset".
>Hi,
>
>I'm creating a report with detailed data and 3 groups.
>At the first group footer I'm calculating two numbers:
>a percentage figure and a number which give my result.
>So far no problem either with "Calculate" in the fields or
>report variables.
>
>Now I want to sum my result of the first group to print a total
>in group footer 2 and 3. And there is the problem - all further
>calculations are based on the detailed data rows but I want to use
>the result of the first group footer. Due to the percentage
>calculation at the end of group footer 1 there seems no
>way to do this. Any suggestions (except calculating the totals
>before the report)?
>
>Data Rows:
>2 100$
>3 500$
>10 50$
>
>Group footer 1:
>15% of 650$ result is 97,5$
>
>Group footer 2 + 3: sum all results of 1 (97,5 + ....)
>Using detail leads to wrong calculations (2% of 100$ + 3% of 500$ +
>10% of 50$ is giving 22$ and not 97,5$). groups.
>
>Is there a possibility with report variables to get information
>about group changes (I know only the reset option): e.g.
>
>total = IIF(groupchange1=.T.,total+result,total)
>
>Thanks.
>
>Andreas
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