The Page Number by groups

Hello, Birt Designer Experts. 
 
Could anybody please show me how to display the page number by grouping at the Master Page? 
 
I would like to display the page number with the format of ?m of n? at grouping level, where n is the page number of the grouping and m is the total number of page in the grouping at the master page of the footer. 
 
For example, I have three input parameters, the ID=001, ID=002, and ID=003, and there are 1, 2, and 3 pages each grouping respectively. In this way, I want 1 of 1 ID=001, 1 of 2, 2 of 2 for ID=002, and 1 of 3,,,,,,, 3 of 3 for ID=003 at every master page in footer. 
 
If I use the AutoText from the Pallet and attach it in Master Page, it ignores the grouping function, and simply shows the page number and the total page of the whole form. This is not what I want. 
 
So far, I can display the total page for each grouping, meaning that I can populate the value of ?n? out of ?m of n? by using the page variable, but not the value of ?m?. 
 
My application version is: 
Actuate BIRT Designer Professional 
Version: 11.0.0 
 
Your tip or example will be very helpful. 
Thank you

Find more posts tagged with

Comments

mwilliams

In your real application, the group page numbers are dynamic though? Not corresponding to the group ID?

Kenichi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72521" data-time="1295664851" data-date="21 January 2011 - 07:54 PM">
In your real application, the group page numbers are dynamic though? Not corresponding to the group ID? </blockquote>
 
Mr. mwilliams 
 
Thanks for your comments. I am sorry, but I don't understand your question. Could you describe it with an example? 
 
What I want is the independent page number and total page for each group at the master page. 
 
Please let me know if you need more information from me. 
 
Thanks.

mwilliams

In your example above, the group with ID 001 had 1 page, the group with ID 002 had 2 pages, and the group with ID 003 had 3 pages. I was just asking if your groups will tell you how many pages you have in the group or does this just happen to be how your example layed out?

If your group ID doesn't represent the page number in the group, which I'm assuming it doesn't but had to ask, you'll have to set up an interval group inside your current group to limit the number of lines per page so that you can calculate a group page total value. Then, you can pass a variable you increment based on your group changing and on the internal interval grouping through a "page variable" you create in your data explorer to an autotext element for the report/page variables in your master page footer. It'd be very similar to the linked example from the devShare only you'd use the report/page variable to be able to pass the value to the masterpage.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/491-page-numbers-in-report-layout-/

Hope this helps.

thuston

Here is a solution that we wrote for another customer.
It did not work for all formats, and this appears to not work for runandrendertask. If using the API, you can separate into runtask and rendertask.

It tracks and resets the page number and total for each Table and populates the controls from a HashMap during OnRender.
You should be able to modify it to have the Group Header, instead of the Table OnCreate, reset the counter.

Kenichi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72611" data-time="1296048642" data-date="26 January 2011 - 06:30 AM">
In your example above, the group with ID 001 had 1 page, the group with ID 002 had 2 pages, and the group with ID 003 had 3 pages. I was just asking if your groups will tell you how many pages you have in the group or does this just happen to be how your example layed out? 
 
If your group ID doesn't represent the page number in the group, which I'm assuming it doesn't but had to ask, you'll have to set up an interval group inside your current group to limit the number of lines per page so that you can calculate a group page total value. Then, you can pass a variable you increment based on your group changing and on the internal interval grouping through a "page variable" you create in your data explorer to an autotext element for the report/page variables in your master page footer. It'd be very similar to the linked example from the devShare only you'd use the report/page variable to be able to pass the value to the masterpage. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/491-page-numbers-in-report-layout-/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/491-page-numbers-in-report-layout-/</a> 
 
Hope this helps. </blockquote>
 
Mr. mwilliams 
 
Thanks for your comments. I am trying your logic now, and get back to you as soon as I make a progress. 
 
By the way, the link to the example source of devShare is dead. It shows me the error message, "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed.." 
 
Are you able to re-submit this original source? 
 
Thanks again.

mwilliams

Kenichi,

I noticed the same thing after I sent the link. I have already sent the issue to site support. I will see what they can do. It may have been mixed up in the site transfer a while back and they can recover it. If not, I will have to see if I still have the file. I have lost some during OS upgrades over time. If we can't get it back easily, I'll make another example.

Kenichi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72634" data-time="1296063031" data-date="26 January 2011 - 10:30 AM">
Kenichi, 
 
I noticed the same thing after I sent the link. I have already sent the issue to site support. I will see what they can do. It may have been mixed up in the site transfer a while back and they can recover it. If not, I will have to see if I still have the file. I have lost some during OS upgrades over time. If we can't get it back easily, I'll make another example. </blockquote>
 
Mr. mwilliams 
I have made a progress, and I just wanted to share it with you. I understood the logic that you did on the report. 
 
Technically, you had the another group just for the page counting function, and did some page number calculation based on the number of detail. 
 
On top of that, I took these results, "page: m of n" as the string, and mapped into page variable, 'totalpage'. Now, the page variable appears on the master page by using AutoText Pallet. Just in case, I am attaching the modified report to this thread. 
 
Now I am applying this logic into my own report. 
 
Do you think this is kind of practical way to populate the pages per group? Is there anyway to integrate this 'page and page total' per group by Java code? 
 
Anyway, Mr. mwilliams, thank you very much for your help.

mwilliams

Unfortunately, I don't think there's a better way to determine pages per group without limiting the rows per group to a known value. You could display this value on the master page by using report/page variables to store the values in and using the autotext variable element on the master page to display the values.

bdowning

I am trying to do exactly the same thing here but am forced to use BIRT v. 2.3.2 on Eclipse 3.4.2. As such, I cannot see the sample report shown here. Any chance to get a back-ported version?

mwilliams

Try changing the version info in the XML Source to match the version info from one of your other reports. If it doesn't work, let me know.