OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Report parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report parameter [message #312003]

Mon, 07 April 2008 13:44

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.

Report message to a moderator

Re: Report parameter [message #312011 is a reply to message #312003]

Mon, 07 April 2008 14:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

AND hru.organization_id = NVL(:P_OPERATING_UNIT, hru.organization_id)

Report message to a moderator

Re: Report parameter [message #312017 is a reply to message #312011]

Mon, 07 April 2008 16:58

shree_z
Messages: 75
Registered: February 2008

Member

Thank you so much.. Its working!!!

Report message to a moderator

Previous Topic:	Rdf i want to send through mail.
Next Topic:	ORA-06502

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 22:56:47 CST 2024