RESOLVED - Group (Section?) Multiple Crosstabs on One Page

[adam_mc]

In a report based on a cube, I have a page that contains a number of crosstabs.
All the crosstabs are based on the same query and all contain the field/column for Store#.

I need to run this for all Stores, but produce a page for each store (rather than just Crosstab A for all Stores etc.) .
How do I group/section the page on Store#?

Any help will be greatly appreciated.
Thanks in advance,
Adam.

Page layout looks similar to below:

Crosstab A:
                         Field1       Field2     Field3
Store#  WTD
             MTD
             QTD
             YTD

Crosstab B:
                         Field4       Field5   Field6
Store#  WTD
             MTD
             QTD
             YTD

Crosstab C:
                                       WTD                                     MTD                                  QTD                                     YTD                     
                          Field7     Field8     Field9     Field7     Field8     Field9    Field7     Field8     Field9     Field7     Field8     Field9
Store#  Grp1
             Grp2
             Grp3
             Grp4

[blom0344]

Check what you can do with a pageset. If the crosstab structure is different then add a report page after the pageset part.  You can reuse the query ofcourse, but you can not have a repeating structure with multiple crosstab definitions

[adam_mc]

Still a little lost (probably due to inexperience, can you clarify further?

[blom0344]

A pageset allows to generate a new page with each new value of a dataitem from a query. So, with 10 different stores you can spawn 10 consecutive pages:
http://www-01.ibm.com/support/docview.wss?uid=swg21339528
Search the forum for pageset. There must be hundreds of topics..

[tel03]

Hi,

I have same kind of layout crosstab report. I have a query with columns store#, Field1, Field2 , Field3.

Can you please let me know how can I create data with ( MTD,YTD) one column in crosstab rows? how can I group with Field 1,2,3?



Crosstab A:
                         Field1       Field2     Field3
Store#  WTD
             MTD
             QTD
             YTD