I have a report with the parameter :qry_mth with the following SQL populating the field:
select distinct to_char(entered,'MON YYYY') as entry_dt
from t_trans
order by to_date(entry_dt,'MM/YY')
The problem is that when the report is selected from a menu the list of values does not appear as a drop down box, instead the entire list appears as text on the parameter form.
Any suggestions as to what I can try?
Thanks ...
select distinct to_char(entered,'MON YYYY') as entry_dt
from t_trans
order by to_date(entry_dt,'MM/YY')
The problem is that when the report is selected from a menu the list of values does not appear as a drop down box, instead the entire list appears as text on the parameter form.
Any suggestions as to what I can try?
Thanks ...