How to get rows repeated in a cross-tab report

[lucas1239]

Hello,

I've created a Cross-tab report with multiple grouping on the rows.

this report is used to export to Excel and do further reporting on there with links to other excel sheets.

for this they need to have all grouping names repeated on all rows.

here an example:

how can I get Income Account, 500 and net Turnover to be repeated on all rows?

thanks,

Lucas

[DellSC]

There is no easy way to do this in a cross-tab. Creating a tabular report can be a challenge as well, depending on the number of groups in the columns. If you showed a little more of your crosstab, with information about your summary fields, I might be able to walk you through it.

Having said that, what I usually do in situations like this is write a command that will pivot the data into the format that I need. If you'll post information about how you're summarizing the data along with the SQL that Crystal has generated and what type of database you're using, I might be able to help you out with the SQL for that.

-Dell