OraFAQ Forum: Reports & Discoverer » Multiple User Parameters handling.

Home » Developer & Programmer » Reports & Discoverer » Multiple User Parameters handling.

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

Multiple User Parameters handling. [message #114880]

Wed, 06 April 2005 01:05

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

I have a report with many User Parameters.
I want if user don’t select a User Parameter all records against that parameter will display.
i.e.
Department parameter. (Selected Sales Department)
Date Parameter. (dont want to select. Want all Dates)

Advice Requested.

Wishes
Jawad

Report message to a moderator

Re: Multiple User Parameters handling. [message #114917 is a reply to message #114880]

Wed, 06 April 2005 06:24

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Make the parameters optional and in the query you do a nvl:

SELECT columns
  FROM some_table
 WHERE department = NVL(:parameter_departmenr, department)

This way, the parameter will be replaced by the value of the column itself (hence, all values will be selected) whenever it's NULL.

Is this what you wanted?

MHE

[Updated on: Wed, 06 April 2005 06:24]

Report message to a moderator

Re: Multiple User Parameters handling. [message #114927 is a reply to message #114917]

Wed, 06 April 2005 07:11

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear Maaher

Yes it worked.
Thanks for your help.

I pray GOD will give you more knowledge.
Jawad

Report message to a moderator

Previous Topic:	Drill Down Report
Next Topic:	Serial number for columns with in a repeating frame.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 18:46:35 CST 2024