Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group Calculations not possible?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00738208
Message ID:
00738344
Views:
13
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
Map
View

Click here to load this message in the networking platform