DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Null value in parameter form.

522765Jul 12 2006 — edited Jul 12 2006

In parameter form I want to leave blank option in order to print a report for all the values in the parameter form. I am writing the query for the parameter LOV that it fetches the values and making a union with 'select to_char(null) from dual.
I am getting a blank and the required output when the report is run using the report builder but the this blank space or null value disappears when the report is run on application server 10g. It seems to be a small problem but I am not able to get a solution for this. Please, suggest something.