Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Report Parameter Sorting
Report Parameter Sorting [message #201100] Wed, 15 November 2006 22:06 Go to next message
Eclipse User
Originally posted by: smurfieu.gmail.com

I am having an issue with making the "Enter Parameters" window display the
choices in the order returned by the query.

I am using a dynamic combo box and "Sort alphabetically when prompting" is
UN-checked.

I want the parameters to return in a descending order (which I verified in
both TOAD and the preview results pane in the data set window).

I am doing a simple query:

select distinct to_char(tara.CYCLE_DATE,'YYYY-MM-DD') as CYCLE_DATE
from AS_REPORT_AGG tara
order by to_char(tara.CYCLE_DATE,'YYYY-MM-DD') DESC

Does anyone have any insight on this? I have been searching for quite
awhile, but everything I have found seems to be well beyond the scope of
this problem.

Thanks in advance.
Re: Report Parameter Sorting [message #201386 is a reply to message #201100] Thu, 16 November 2006 21:00 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

This looks like it may be a bug. Can you log a bugzilla entry for this?

Jason

"Matthew" <smurfieu@gmail.com> wrote in message
news:6429762ec95c6a54761b1e28aefe7210$1@www.eclipse.org...
>I am having an issue with making the "Enter Parameters" window display the
>choices in the order returned by the query.
> I am using a dynamic combo box and "Sort alphabetically when prompting" is
> UN-checked.
>
> I want the parameters to return in a descending order (which I verified in
> both TOAD and the preview results pane in the data set window).
>
> I am doing a simple query:
>
> select distinct to_char(tara.CYCLE_DATE,'YYYY-MM-DD') as CYCLE_DATE
> from AS_REPORT_AGG tara
> order by to_char(tara.CYCLE_DATE,'YYYY-MM-DD') DESC
>
> Does anyone have any insight on this? I have been searching for quite
> awhile, but everything I have found seems to be well beyond the scope of
> this problem.
>
> Thanks in advance.
>
Previous Topic:i've problem with preview
Next Topic:Debugging Null pointer
Goto Forum:
  


Current Time: Tue Sep 23 04:22:32 GMT 2014

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

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