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
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
Still a little lost (probably due to inexperience, can you clarify further?
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 (http://www-01.ibm.com/support/docview.wss?uid=swg21339528)
Search the forum for pageset. There must be hundreds of topics..
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