>Hi Kevin,
>
>Aside from creating another details band for the summary cursor, you need to establish a Relation to the two cursors by creating Index and Set Relation.
If I am not mistaken as per concept of multi band frx reports, he needs 3 cursors in total. One dummy (single record) which will be main and at the top of the relation to other two (one with data and other with state totals). Dummy single record cursor should be driving alias.
To Kevin;
Personally I would NOT use multi detail band frx for anything more complex then those simple demo samples that came with VFP9.
If your report requirement get any more complex then this you might need to engage in some very complex techniques to get
some not seemingly complex requirements done;
http://spacefold.com/lisa/post/2011/05/05/Walkthrough-Multi-Detail-bands-the-demon-child-of-the-VFP-Reporting-System.aspx(Peace of cake huh ?)
If you do not mind fighting/disciplining 'demon chilldren of VFP reporting' like LisaSN did in blog above then fine. If you do, there is one
ages old scenario that might fit the bill here;
Your report required tabular set of totals at the end of the report right ?
This can be also achieved by copying cursor with state totals into an ARRAY and then showing it in any band that suits you.
Caveat is that you cannot really have that pseudo 'band' (array) flowing as genuine one but instead it has to be exposed as prefixed set of rows which would be 50 for each state or some projected maximum of states that will appear in report. You need to use 'printwhen' clauses set to prevent non populated array ROWS from showing. It is a bit chunky&clunky but it is sure doable.
This was my 'poor man solution' to multiband reporting problem back in VFP6 days :)
Now if your report get more complex then this like for instance having very strict/specific layout and paging requirements then I suggest you have look at
www.report-sculptor.com Once you integrate RS into your own development environment, then all known FRX limits are off, as you can directly program each page if it is really needed.
See RS Demo samples for more ideas.
HTH
Sergio