Group Page Counter (x of y)

6 posts, 0 answers
  1. Eric
    Eric avatar
    1 posts
    Member since:
    Sep 2016

    Posted 27 Sep 2016 Link to this post

    I'm creating an invoice report that sometimes requires a group to continue for multiple pages.

    Is there a way within Report Designer to create a group-based page counter?

    For example:

    A report is 30 pages long but is split and page broken by a group.

    The page counter for each grouping should display the current page, along with the number of pages for that specific group. Something like "Page 2 of 4"

    Thanks! -Eric

  2. Katia
    Admin
    Katia avatar
    733 posts

    Posted 29 Sep 2016 Link to this post

    Hello Eric,

    Group-based page numbering is not supported out-of-the-box.

    If you use Standalone Designer to create TRDX|TRPD reports the designer needs to be extended with additional logic for resetting the page number per group (check the attached example).

    After the Designer is extended to use the external assembly with user function, you can use this function inside the reports to reset the page number per group.

    You can also check How to use external assemblies with custom user functions in the Report Designer KB article providing more detailed information on how to extend the Designer.


    Regards,
    Katia
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Ikbum Kim
    Ikbum Kim avatar
    1 posts
    Member since:
    Nov 2007

    Posted 23 Sep 2019 Link to this post

    Hi,

    Isn't there a way to do it in the report designer?

  4. Brian
    Brian avatar
    36 posts
    Member since:
    Mar 2016

    Posted 24 Sep 2019 Link to this post

    There sure is.

    = "Page: " + PageNumber("group1", Fields.salesorderID) + " of  " + PageCount("group1", Fields.SalesorderID)

    That is the expression that I use in my reports.

    So typically you would drop this in the page footer as a text box.

    Group1 = what ever the name of your group is that you are grouping the invoice on.

    SalesOrderID = this is my transactionID from my database. You will need to change this to suit your database.

     

    Let me know how you make out as it took me a while to figure this one out.

  5. Ted
    Ted avatar
    3 posts
    Member since:
    Mar 2011

    Posted 16 Oct 2019 in reply to Katia Link to this post

    Hello Katia,

      How to Implement Reset PageCount per Report Group, like extended custom user functions "MyPageCount" ?

  6. Neli
    Admin
    Neli avatar
    273 posts

    Posted 21 Oct 2019 Link to this post

    Hello Ted,

    Since R1 2017 (version 11.0.17.118), we introduced advanced built-in PageNumber and PageCount functions allowing to reset the page number and count on any page based on the data. For more information, refer to Page Functions article.

    If you prefer not to upgrade, you can check the sample report provided by Katia which works for the older versions of Telerik Reporting too.

    Regards,
    Neli
    Progress Telerik

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top