I'm having a very frustrating issue when I export a cross-tab into Excel.
I have 2 groups/rows in my crosstab (niether are specified groupings). When the report is run, there are 3 groups for row #1 (3 boxes in column 1) and 4 groups (including total) in row #2 - one for each of group 1 (12 boxes in column 2)
I am opting to have row totals on top. I enable the check box on the 'Customize Style' tab to do this. In Crystal, the report looks fine. When I export the report to excel, the last row in the last group doesn't appear. However, if I uncheck the box, it does.
I am running Crystal 8.5. I tried to explain this as best possible. I hope someone has seen this issue before, its extremely frustrating.
Thanks for any help!!
I have 2 groups/rows in my crosstab (niether are specified groupings). When the report is run, there are 3 groups for row #1 (3 boxes in column 1) and 4 groups (including total) in row #2 - one for each of group 1 (12 boxes in column 2)
I am opting to have row totals on top. I enable the check box on the 'Customize Style' tab to do this. In Crystal, the report looks fine. When I export the report to excel, the last row in the last group doesn't appear. However, if I uncheck the box, it does.
I am running Crystal 8.5. I tried to explain this as best possible. I hope someone has seen this issue before, its extremely frustrating.
Thanks for any help!!