Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » PageCount with bookmark(PageCount with bookmark)
PageCount with bookmark [message #748331] Mon, 24 October 2011 16:34 Go to next message
harip kaligo is currently offline harip kaligoFriend
Messages: 74
Registered: July 2011
Member
HI,



We created a report with two tables in such a way , that the date from first table is displayed in HTML and from the second is displayed in Excel, to have this differentiation we introduced a bookmark between these two tables.

IN rptdocumnet we display total page count and that counts the number of pages for both the tables, is there any way we can count only the pages from first table till bookmark and exclude second table as it goes to excel .

Can we get sample code for this to be included in our rptdesign files.

Thanks,
KKP
Re: PageCount with bookmark [message #748366 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748370 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748374 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748377 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748382 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748386 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748390 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748393 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748398 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748403 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748407 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748411 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748414 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748419 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748422 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #748426 is a reply to message #748331] Mon, 24 October 2011 17:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You could try to use a page script and page variables for this. Look at
the attached example that puts a custom page n of m in the header. The
script looks for instances of the first table header in the output
before incrementing current page and page total.

Jason

On 10/24/2011 12:34 PM, kkp wrote:
> HI,
>
>
>
> We created a report with two tables in such a way , that the date from
> first table is displayed in HTML and from the second is displayed in
> Excel, to have this differentiation we introduced a bookmark between
> these two tables.
>
> IN rptdocumnet we display total page count and that counts the number of
> pages for both the tables, is there any way we can count only the pages
> from first table till bookmark and exclude second table as it goes to
> excel .
>
> Can we get sample code for this to be included in our rptdesign files.
>
> Thanks,
> KKP
Re: PageCount with bookmark [message #749610 is a reply to message #748426] Tue, 25 October 2011 10:22 Go to previous messageGo to next message
harip kaligo is currently offline harip kaligoFriend
Messages: 74
Registered: July 2011
Member
Hi Jason

This works fine but We want to include this as a library.
In library we cannot include Report variables and Page variables.

Please suggest some alternate way of acheiving this without variables(Report or Page variables, as they cannot be included in the library).

We tried to set a global variable and retrieve its value in the master page in on render method. But it doesn't work.
Please find attached the rptdesign.
Re: PageCount with bookmark [message #749976 is a reply to message #749610] Tue, 25 October 2011 14:54 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

On your master page use a label instead of a data item and put this in
the onRender:

this.text = reportContext.getPersistentGlobalVariable("pagtot");

Jason

On 10/25/2011 6:22 AM, kkp wrote:
> Hi Jason
>
> This works fine but We want to include this as a library.
> In library we cannot include Report variables and Page variables.
>
> Please suggest some alternate way of acheiving this without variables(Report or Page variables, as they cannot be included in the library).
>
> We tried to set a global variable and retrieve its value in the master page in on render method. But it doesn't work.
> Please find attached the rptdesign.
Previous Topic:Simplified Analytic Dashboard Setup in Yellowfin 5.2
Next Topic:View hyperlinks in weblogic server
Goto Forum:
  


Current Time: Thu Apr 18 22:12:05 GMT 2024

Powered by FUDForum. Page generated in 0.03169 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top