Eclipse Community Forums: BIRT » Report Parameter Sorting

Help

Home

Home » Eclipse Projects » BIRT » Report Parameter Sorting

Show: Today's Messages :: Show Polls :: Message Navigator

Report Parameter Sorting [message #201100]

Wed, 15 November 2006 17:06

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.

Report message to a moderator

Re: Report Parameter Sorting [message #201386 is a reply to message #201100]

Thu, 16 November 2006 16:00

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.
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	i've problem with preview
Next Topic:	Debugging Null pointer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 05:05:50 EDT 2013