Home » Developer & Programmer » Reports & Discoverer » Report parameter
Report parameter [message #312003] Mon, 07 April 2008 13:44 Go to next message
shree_z
Messages: 75
Registered: February 2008
Member
Hi All,

I have a question on passing parameter to a report which is registerd as a concurrent program.

I have a parameter "Operating unit".I have used the below part in the query of the report to enable this,

AND hru.organization_id = :P_OPERATING_UNIT


When the concurrent request for the report is submitted I want the parameter to act in such a way that, if the user gives null value, then the report must show all the results for all the operating unit, How can I make this possible? Now in such a situation, the report is not pulling any rows.

Anyone please help,

Thanks in advance.
Re: Report parameter [message #312011 is a reply to message #312003] Mon, 07 April 2008 14:43 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
AND hru.organization_id = NVL(:P_OPERATING_UNIT, hru.organization_id)
Re: Report parameter [message #312017 is a reply to message #312011] Mon, 07 April 2008 16:58 Go to previous message
shree_z
Messages: 75
Registered: February 2008
Member
Thank you so much.. Its working!!!
Previous Topic: Rdf i want to send through mail.
Next Topic: ORA-06502
Goto Forum:
  


Current Time: Sun Dec 11 00:16:02 CST 2016

Total time taken to generate the page: 0.09541 seconds