Eclipse Community Forums: BIRT » Dynamically sort a crosstable at render time

Home » Archived » BIRT » Dynamically sort a crosstable at render time(Is there a way to apply dynamic sorting on a crosstable without generating a new rptdocument?)

Dynamically sort a crosstable at render time [message #753970]

Mon, 31 October 2011 05:57

Eclipse User

Hi,

I found nice examples of reports that apply dynamic cross-table sorts in the beforeFactory event, based on a report parameter. The drawback of this method is that datasets and sql queries are executed again, although nothing changed except crosstable rows sorting.

So i was wondering if there is a way to add a dynamic sort when using an existing rptdocument. My app can retrieve a cached rptdocument wich match with users' selection choices and update its parameters, but applying a dynamic sort on render event doesn't seem having any effect.

Is there any API such myCrossTable.refresh() or myCrossTable.refactory() that we could run in the onRender events? Smile

Thats could be great, dynamic sorting or filtering performances in a cross table would be dramatically improved

thx
Dom

[Updated on: Mon, 31 October 2011 06:14] by Moderator

Re: Dynamically sort a crosstable at render time [message #754034 is a reply to message #753970]

Mon, 31 October 2011 10:51

Eclipse User

Currently the open source viewer does not have that functionality. This
can be done with Actuate's commercial viewer though.

Jason

On 10/31/2011 5:57 AM, dpardon wrote:
> Hi,
> I found nice examples of reports that apply dynamic cross-table filters
> in the beforeFactory event, based on a report parameter. The drawback of
> this method is that datasets and sql queries are executed again,
> although nothing changed except crosstable rows sorting.
>
> So i was wondering if there was a way to add a dynamic sort when using
> an existing rptdocument. My app can retrieve a cached rptdocument wich
> match with users' selection choices and update its parameters, but
> applying a dynamic sort on render event doesn't seem having any effect.
>
> Is there any API such myCrossTable.refresh() or myCrossTable.refactory()
> that we could run in the onRender events? :) Thats could be great,
> sorting or filtering performances in a cross table would be dramatically
> improved
>
> thx
> Dom

Previous Topic:	Setting a default parameter value from a dataset value
Next Topic:	report parameter not set

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 05:49:36 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter