>>>>>>
>>>>>>State Rows Amount Gross Net Buff
>>>>>>CA 10 15,000 25,000 18,000 10,000
>>>>>>AZ 5 22,000 13,000 9,000 4,000
>>>>>>MA 185 66,000 22,000 10,000 14,000
>>>>>>
>>>>>>
>>>>>>
>>>>>>What I don't know is how to produce rows like this in the report footer
>>>>>
>>>>>Looks like you may need to use multi-band report for that. I only have a few reports like that...
>>>>
>>>>Will the bands be auto-generated, meaning one band for each state?
>>>
>>>No, I thought you can have the main cursor and another cursor with totals only which will be your second band.
>>
>>
>>I need more help...
>>
>>I created a summary cursor, but I don't see how to create a Report Footer band. I do see a Summary band. Is this the Report Footer?
>>
>>I added fields to the Summary band from the summaries cursor, but none of them show up. The whole band doesn't show.
>
>You don't want Page Footer (there's no such thing as Report Footer) or Summary. You want a second detail band. Right-click in the report and choose Optional Bands. On the right-hand side of the page that opens, click Add, then click OK.
>
>You'll see that the report now has two detail bands. Double-click each one in turn and fill in the Target Alias Expression with the name of the cursor for that band in quotes. (VFP is looking for an expression there, not an alias.) In the same dialog, you can specify that the detail band has its own header and footer, if you need them.
>
>Tamar
Ok, so I did what you said, and the second detail band does not show up. The space for the band is there, but nothing shows.
Updated ZIP file:
http://sdrv.ms/1aIuAnyOne thing I don't understand though - won't a second detail band show data below each line of data from the first detail band? What the client wants is a summary page with the summary data in tabular format. All on a separate page.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people