Home » Developer & Programmer » Reports & Discoverer » Parameters in Discoverer
Parameters in Discoverer [message #150039] Tue, 06 December 2005 01:30 Go to next message
saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad
Junior Member
Hello Friends,

I have created two Parameters
1) From Creation Date
2) To Creation Date

I Enter the values in both the Parameters it works fantastic.
But I want to modify the Parameter in such a way that if i do not enter any value in any of the parameter, still the Report should work. For Example:

For Parameter: From Creatation Date - 17-OCT-2005
For Parameter: To Creation Date - I do not Enter any Value or I Enter a Date.

If i do not Enter the Date in To Creation Date Parameter Still the Report should Run.

Can any one Explain how to do this?

Thanks and Regards
Saritha

Report message to a moderator

Re: Parameters in Discoverer [message #150115 is a reply to message #150039] Tue, 06 December 2005 06:42 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
How about providing an initial value to your parameter?
How about using a reports trigger (I don't know the name by hear, but I believe it is "after-paramform")?

MHe

Report message to a moderator

Re: Parameters in Discoverer [message #150177 is a reply to message #150039] Tue, 06 December 2005 12:04 Go to previous messageGo to next message
saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad
Junior Member

Thanks for the reply HMe...

This a Discoverer Report, as far as i know do u have any trigers?

and to be more clear on my Question is.

I have a Parameter.
1st Senario.
If i put some value in the parameter the report will work
2nd Senario.
If i do not place any value in the Parameter still the Report should work.
How to do this?

Thanks and Regards,
Saritha

Report message to a moderator

Re: Parameters in Discoverer [message #150190 is a reply to message #150177] Tue, 06 December 2005 12:52 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Sorry, my bad. I should have my eyes checked Wink I was referring to Reports, of course. You could try using an NVL in your query:
NVL(yourparameter,the_initial_value).

I don't know discoverer so I can't tell you whether it is really possible but it should get you on the way.

MHE

Report message to a moderator

Previous Topic: Page Numbering Problem.
Next Topic: Concating two different group values
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 10:02:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.