Multi Column List with Report Header using a single Data Source

1 Answer 90 Views
Binding DataSource Object DataSources Report Designer (standalone) Table
Matt
Top achievements
Rank 1
Iron
Matt asked on 25 Jun 2024, 05:44 PM

Hello, 
I'm creating a multi-column report that's printing Across Then Down. I used the Multi-Column Example to get started. And it works perfect. Now I need to use the same data source for fields in my Report Header and Footer. When I assign the same Data source from the List to the report the list is duplicated for ever record in the data. When I remove the List Data Source and try to do a binding expression on the List (Property Path=DataSource Expression=ReportItem.DataObject) the List no longer does multi-column, and is just a single column. I also tried using the PageExec() function to try and access the List scope and  Details scope to get the data that way, but was unsuccessful. 

Due to an external integration, I can only use a single data source as the external tooling replaces all the Data sources with something it configures and inserts into the report XML. 

So how can I achieve this? 

Sample data out of the database is attached. 

 

Thanks

 

1 Answer, 1 is accepted

Sort by
0
Matt
Top achievements
Rank 1
Iron
answered on 25 Jun 2024, 08:41 PM
I got a working solution from here: https://www.telerik.com/forums/duplicate-pages-when-generating-a-report
Tags
Binding DataSource Object DataSources Report Designer (standalone) Table
Asked by
Matt
Top achievements
Rank 1
Iron
Answers by
Matt
Top achievements
Rank 1
Iron
Share this question
or