You can have multiple crosstabs within the same report, but they need to be inserted from within the report. Or, you could add the crosstab from a separate report by inserting it as a subreport into the first report.
Awesome LB - thanks for the timesaver! Now here is another problem I have run into before - Since in both crosstabs I am displaying my columns horizontally (not sure if that has anything to do with it). When I export to excel, it's prints so much of my data going down and then seems to put in some column headings down below which I don't want. Almost like a page header? Please help - thanks!
It sounds like these crosstabs might have the same column, but with different values, e.g., different years or something similar. Are you sure you can't combine the two crosstabs into one?
I think so because I have to sum on 3 different currency amounts. Sum A and B are under column 1 and 2 and Sum C is just in its own separate columnn 3.
I think it has something to do with a virtual header? How do I prevent that from happening?
Why not add the module codes column and the module amount into the first crosstab? I guess this would give you more detail than you want, but I don't think you are going to be able to get a side by side export with two separate crosstabs (although I might be wrong).
I have tried for a couple of days trying to add the module amounts to the first crosstab however, it is including the net and gross amounts in columns in conjunction with the module amount which I don't want.
I think my problem is solved if you can tell me a way to not have any virtual header appear?
It displays the first say 100 records of my data with like 10 columns. Then part way down my excel sheet there is a break in my data with a few empty rows and then it displays my column headings over again.
CR does create virtual pages. It sounds like your version of Excel can't handle the number of columns or that this has something to do with exporting two crosstabs side by side. Try exporting just one of the crosstabs and see if it wraps.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.