|Report Parameter Sorting [message #201100]
||Wed, 15 November 2006 22:06
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
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
Thanks in advance.
Powered by FUDForum
. Page generated in 0.04423 seconds