Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I subgroup a summary?
Message
From
10/09/2002 09:13:45
 
 
To
09/09/2002 15:26:29
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00698436
Message ID:
00698720
Views:
17
The example you sent certainly meets my requirements except for the part where the number of unique details (or variables) are not known.

>I sent you an example by email. It is quick and not very pretty, but if I understood you correctly, it should work. Basically, you would have to create a report variable for each detail type to total the amounts for each possible detail. Then display those totals (variables) in the summary band. The grand total is the easiest of course, so I did not include that in the report. You could use a print when statement in the properties and only print if the value is greater than zero. If you have a huge number of possibilities for detail items, then this would not work well. You may want to create the variables before you run the report then instead of using report variables only. I tend to use report variables whenever possible though to enable easily releasing them at the end of the report. I'm not sure what type of information your detail records are or I could try to come up with another solution. Maybe someone else will have a better idea!
>
>I'm thinking there's gotta be a better way...
>
>Tracy
>
>>Yes, it could. But how do I display the information in the summary?
>>
>>>Wouldn't setting up report variables for each of the details do this for you?
>>>>Hi all,
>>>>
>>>>Can I do this in VFP reports?
>>>>
>>>>
>>>>Group1
>>>>  1st Day
>>>>    Detail A   10
>>>>    Detail B   20
>>>>Group1
>>>>  2nd Day
>>>>    Detail A   20
>>>>    Detail C   10
>>>>Summary (All days)
>>>>    Detail A   30
>>>>    Detail B   20
>>>>    Detail C   10
>>>>Grand Total   60
>>>>
ramil
~~ learning to stand still
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform