Conditional Prompt in Impromptu 1

[swen17]

Hi,

I have a report with two prompts, if the user inputs something in the first prompt I don't want the second prompt to be used in the fitler (this second prompt has default values). If there's no input in the first prompt I want the default values in the second prompt to be used in the filter. FYI..I'm using Impromptu Series 7 version 2, with an Oracle database. Thanks in advance for any and all advice.

Swen...

 

[DoubleD]

See this faq401-2137 written by Dave Griffin.

I am what I am based on the decisions I have made.

DoubleD

 

[swen17]

Double D,

Thanks for the response, I appreciate it, I should have found that FAQ in the first place. I don't quite understand how to implement this.
For example with this filter:

Event Date between ?\Prompts\Starting Date? and
?\Prompts\Ending Date? and Fleet starts with
?Prompts\Fleet? and 1 = decode[?\Prompts\Fleet?,'NULL',1,0] and PARTNUM starts with ?\Prompts\Part Number?

If Fleet is 'NULL' then 1 = 1 and the rest of the filter (PARTNUM) would be executed. Whereas if it's not null then 1 = 0 and rest of the filter would be executed???? Is that how it's supposed to work??? I'm missing something....

Thanks!
Swen

 

[DoubleD]

I would probably write it as follows:

Event Date between ?\Prompts\Starting Date? and
?\Prompts\Ending Date? and
(1 = Decode(IfNull-String(?\Prompts\Fleet?,'NULL'),'NULL',0,1) AND (Fleet starts with ?Prompts\Fleet?)) OR
(0 = Decode(IfNull-String(?\Prompts\Fleet?,'NULL'),'NULL',0,1) AND (PARTNUM starts with ?\Prompts\Part Number?))


I am what I am based on the decisions I have made.

DoubleD

 

[swen17]

Thanks DoubleD...that worked perfectly. It's great to be able to do that with prompts...will be using this alot. Thank you so much!!!!

Swen