Cross-tab Report, Page Grouping

[Justin]

Not sure the best way to explain so I figured I'd give a description and hopefully it'll make sense. :)

I have a cross tab report that uses the 12 months of the year for the rows and 2 consecutive years for the columns, and sum amounts in the details section. (12x2 grid with sum details).

 

My SQL data source has all the details needed, but these details are split up by an account number. So, if I have 100 accounts * 2 years * 12 months = 2400 rows of data in my data source.

(ex: Acct1, Jan, 2012,12units || Acct2, Jan, 2012, 2units || Acct1, Feb, 2012, 8units || etc.)

 

My end goal is to do a grouping by account and do a page break after group​'s footer to get 100 separate data pages (one for each account) each with a cross-tab containing the 12x2 grid ​showing all the details for only that one account. I'm hoping to do it with the single data  source SQL query (as opposed to making 100 separate round trips that may be needed to do each individual account).

 

Ideas? Thanks!

 

[Stef]

Hi Justin,

The Table/List/Crosstab item does not support page breaks. Feel free to support the logged feature request, as features are considered and planned for implementation based on the demand for them.

My suggestion is to bind the data retrieved as a single DataTable to the report and add proper grouping per account. Then display fields for the account information in the GroupHeaderSection. Add also the Table item in the GroupHeaderSection and bind it to the groups data by using the ReportItem.DataObject in a binding to the Table.DataSource.

The Detail section can be hidden by setting its Visible property to false.


I hope this information is helpful.

Regards,
Stef
Telerik

[Justin]

Thank you for the reply! :)

I have figured this out for a table type report as you have described above. However, I need to display the results in a cross tab manner where I have two years for columns and 12 months for the rows. Any suggestions on how to do this and have each page show only the results for that account and only need to pull the data one time?

 

Thanks!

~Justin

[Stef]

Hello Justin,

Please, check the attached demo project which illustrates the settings suggested in my previous post. The data per group can be visualized via Table/List/Crosstab item placed in a group section. All data items use one data source component.

The demo project uses Telerik Reporting Q3 2015 v9.2.15.930.

Regards,
Stef
Telerik