Hi...
I have a report that contains multiple crosstabs and lists (each is sectioned on Region/District/Store).
Each crosstab/list is formatted within the same table (each in its own row) and all are based on the same single query.
Currently, the report runs and breaks as it should.
However, I now need to burst the report on Region, District, and Store such that each RM, DM, and Store Manager will receive the set of pages that they are authorized to view.
How do I get this to burst out?
I am getting a message "unable to burst crosstab" (or something similar).
I have found a solution to put a crosstab in a list, but am not sure what to do with so many crosstabs/lists on the page??!!
Any help will be greatly appreciated.
Thanks in advance,
Adam.
Hi Adam,
Did you try embedding crosstab in a list and then using Master-Detail. I hope this should work.
Regards
Raj
I'm not sure how to do this, can you please give me further details.....
Do I put one crosstab in a list (so I would have multiple lists attached to my report page?
Or, do I put the whole table (containing multiple crosstabs) in a single list?