Hi Tracy,

Your solution would not work. Remember the question, I asked quite recently and Gregory Adam replied? It's the same story here. In other words, Ramil have to create cursor with all info included...

>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
>>>>