I'm working on some crosstab reports that span multiple pages horizontally. The requirement is for each page header to indicate which columns are on that page e.g on page on it should say "Scenarios 1.1 to 1.6", on page 2 "Scenarios 1.7 to 2.5" etc. The values (1.1., 1.2, 1.3 etc) would be from one of the column groups.
I can't work out how to do this or even if it is possible. The attached png shows a mockup showing what I've been asked to achieve.
I can't work out how to do this or even if it is possible. The attached png shows a mockup showing what I've been asked to achieve.
2 Answers, 1 is accepted
0
Accepted
Hinata
Top achievements
Rank 1
Rank 1
answered on 24 Dec 2014, 08:04 AM
Hi J,
The Reporting engine has a specific behavior when it comes to paging and retrieving data from a page. It is not that easy to get the first and last column header values and display them in the report and there are certain conditions that should be met first in order to get this working:
1. You can only display this information inside the Page Header or the Page Footer section. These are the only sections in the report, which are "aware" of the data on the current page.
2. You need to use the PageExec function: http://www.telerik.com/help/reporting/expressions-data-functions.html
The approach is a little different depending on your data and report layout, so in order to explain better what you need to do, I attached a sample report. Open the report with the latest version of Reporting, switch to Print Preview, and ask if there are any questions on it.
P.S. I guess I cannot attach a ZIP file, so I renamed it manually from PageExecSample.zip to PageExecSample.gif.
You need to download the attached and manually rename it and change the extension from .gif back to .zip.
The Reporting engine has a specific behavior when it comes to paging and retrieving data from a page. It is not that easy to get the first and last column header values and display them in the report and there are certain conditions that should be met first in order to get this working:
1. You can only display this information inside the Page Header or the Page Footer section. These are the only sections in the report, which are "aware" of the data on the current page.
2. You need to use the PageExec function: http://www.telerik.com/help/reporting/expressions-data-functions.html
The approach is a little different depending on your data and report layout, so in order to explain better what you need to do, I attached a sample report. Open the report with the latest version of Reporting, switch to Print Preview, and ask if there are any questions on it.
P.S. I guess I cannot attach a ZIP file, so I renamed it manually from PageExecSample.zip to PageExecSample.gif.
You need to download the attached and manually rename it and change the extension from .gif back to .zip.
0
J
Top achievements
Rank 1
Rank 1
answered on 07 Jan 2015, 10:39 AM
Works perfectly thank you.