This is a migrated thread and some comments may be shown as answers.

Group Page Counter (x of y)

5 Answers 227 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Eric
Top achievements
Rank 1
Eric asked on 27 Sep 2016, 05:42 PM

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

5 Answers, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 29 Sep 2016, 12:08 PM
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
0
Ikbum Kim
Top achievements
Rank 1
answered on 23 Sep 2019, 10:22 AM

Hi,

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

0
Brian
Top achievements
Rank 1
answered on 24 Sep 2019, 07:24 PM

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.

0
Ted
Top achievements
Rank 2
answered on 17 Oct 2019, 02:44 AM

Hello Katia,

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

0
Neli
Telerik team
answered on 21 Oct 2019, 02:53 PM

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
Tags
Report Designer (standalone)
Asked by
Eric
Top achievements
Rank 1
Answers by
Katia
Telerik team
Ikbum Kim
Top achievements
Rank 1
Brian
Top achievements
Rank 1
Ted
Top achievements
Rank 2
Neli
Telerik team
Share this question
or