Showing detail rows in a crosstab report?

[Eric]

Hi all.  I am trying to create a crosstab report that groups categories and titles, while showing details of purchases within those titles by clients.  I am looking to building something similar to what is shown in the "What I Need" image.  What I have come up with so far is shown in the "What I have" image.  

There are more detail records than what is showing and that is the problem.  How do I go about showing the detail records as rows going down under the title groupings and not across the top as the original crosstab wizard created for me (as shown in the "Not what I need image")?  Is this even possible?

I'm okay if the report is a straight forward tabular report.  I have tons of those in the project, and I have a couple of cross tab reports, but this one is escaping me for some reason.

Thanks in advance for any help you can offer!!

[Stef]

Hi Eric,

Please test adding groups in the Crosstab item based on the Product Sales video. The report is available locally with the rest demos installed under C:\Program Files (x86)\Telerik\Reporting <VERSION>\Examples\CSharp|VB\ReportLibrary\Crosstab.

More details about the Crosstab item and its structure are available in the following articles:

• Basic concepts
• Understanding CrossTab areas
• Understanding table cells, rows and columns

Let us know if you need any further help.

Regards,
Stef
Telerik