Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Sorting Tables
Sorting Tables [message #63732] Tue, 02 August 2005 16:18 Go to next message
Eclipse UserFriend
Originally posted by: denis.kurilenko.com

Hi all. I heed to solve following problem: How i may sorting table by
different column by passign this column name via Parameters. Thank for
advance. Good luck.
Re: Sorting Tables [message #63892 is a reply to message #63732] Wed, 03 August 2005 06:00 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: denis.kurilenko.com

I try pass sort key as param but BIRT give me BADSortExpression error.
Re: Sorting Tables [message #64150 is a reply to message #63732] Wed, 03 August 2005 16:10 Go to previous messageGo to next message
Eclipse UserFriend
Birt 1.0 only support static sort orders by column. So the Sort Key
Expression must be in the form of
row["col_name"]
or
row[col_index]

Please file a Bugzilla enhancement request and give specifics about what
you'd like to do if you need a dynamic sorting solutions.

As an alternative, have you considered using scripting to provide a SQL
(assuming that you are using JDBC data set) with a dynamically generated
ORDER BY clause? I have attached one such example. This report has a report
parameter named "office_sortkey" which is the name of the column to sort.
Notice how the preOpen method of the data set provides a dynamically
generated SQL. Note however you will hit some known Birt 1.0 issues with
this report design - the data set cannot be previewed in the data set editor
due to its use of report parameters.

regards,
Gary



"/denis Kurilenko" <denis@kurilenko.com> wrote in message
news:1996ddc14d6a1816e40a282dae37750c$1@www.eclipse.org...
> Hi all. I heed to solve following problem: How i may sorting table by
> different column by passign this column name via Parameters. Thank for
> advance. Good luck.
>
Re: Sorting Tables [message #64670 is a reply to message #64150] Thu, 04 August 2005 05:30 Go to previous message
Eclipse UserFriend
Originally posted by: denis.kurilenko.com

BIG BIG THANK YOU.
Previous Topic:custom header when page break within a table
Next Topic:Paging on BIRT Reports
Goto Forum:
  


Current Time: Tue May 13 10:27:34 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly