Crosstab Page Headers

3 posts, 1 answers
  1. J
    J avatar
    8 posts
    Member since:
    Oct 2012

    Posted 19 Dec 2014 Link to this post

    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.
  2. Answer
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 24 Dec 2014 in reply to J Link to this post

    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:

    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 to PageExecSample.gif.
    You need to download the attached and manually rename it and change the extension from .gif back to .zip.

  3. J
    J avatar
    8 posts
    Member since:
    Oct 2012

    Posted 07 Jan 2015 in reply to Hinata Link to this post

    Works perfectly thank you.
Back to Top