How the change the date format for Paramdisplayvalue('date').
I need to display the selected date in Header of the report page.
when i used paramdisplayvalue, it display inthe format Oct 12, 2009.
How to change the format of date to MM/DD/YYYY.
* i change the date format in property but failed.
its urgent.
Create a data item in your query using your prompt parameter like
cast(?date? as date)
Display this data item in the report header and change the format.
As they say there are diff ways to go to Rome, cast(to_char(....) also helps.
Data item idea working but the prompt is converting as required prompt. Basically this date prompt is optional prompt in the report, Any clue how i can make this as optinal date prompt ?