Exporting a crosstab report into Excel

[Former Member]

Post Author: chenga

CA Forum: Exporting

I need to export a crosstab report created in CR to Excel. When I do that using Excel data only, it places the row label in the last row for that group. How can I either have that display on the first row for that group or display on each of the rows? The point to that is that I would like to be able to use the filter option in Excel.

I've been playing with all of the different options but haven't been able to get the result that I need. Any suggestions would be greatly appreciated.

[Former Member]

Post Author: pabhijit

CA Forum: Exporting

Hi

Need some help on a crosstab scenario while exporting to excel.

I have an existing report in excel which uses pivot feature and display data with filters in excel sheet.Now we migrated to BO environment and I am trying to design something simillar in BO without changing the report output layout.

So far I could successfully replicate the PIVOT features in excel by using crosstab in crystal.Export to excel is also working fine with all desired format (though I had to try lot many iterations in bringing into proper excel formatting).

Now the only thing I am not getting is how to get those dropdown filters in the exported excel.

Please chk if you have any suggestion.?

[Former Member]

Post Author: chenga

CA Forum: Exporting

Actually that will work! It's better than the work around I came up with.

THANKS!!!

[Former Member]

Post Author: qcheng

CA Forum: Exporting

So you have two rows, say row#1 and row#2, in the cross table. If you add row1 into the rows again you will have three rows: row#1, row#2 and row#3 (row#3 has the same row lable as row#1). You supress the subtotal of row#2. When you export this to Excel, there is one more column displaying the row#3 lable (i.e row#1 label) after row#2 label. This is not what you exactly want, but you can apply the filter option in Excel to the extra column.