set Default parameter to null

[Enrique]

Hi does enyone know how  to set a default Parameter to null

Right now when i dont click in my prompt Page i recive all the values 

I would like to do that when i dont click in my prom Page  (in wich one my paramter is associate ) set my parameter to null ,

its that posible?

thanks in advance , Enrique

[Ricardo Julio "Ricky" Villa]

Think to do this the query filter will need to be compulsory, which means the prompt will also need to be compulsory.

Which means you will need a default value in the prompt such as "Missing".  Then a conditional statement in the filter like:

if ( ?YourParameterName? = 'Missing' )
then ( [YourDataItemName] is null )
else ( [YourDataItemName] = ?YourParameterName? )

[Enrique]

Hi Ricardo , thanks for answer

I see a problem there,  in my promp page i can not have any other value , If i have good understand your answer,  with your solution the word "Missing" wold be appear  in the prompt page, doesnt it?

And i need that the prompt page keep in the original format  and nothing extra appear.

[Ricardo Julio "Ricky" Villa]

OK... how about this:

Create 2 Queries: Query A and Query B
Create 2 lists (assuming your report is a list report): List A and List B

Query A populates List A
Query B populates List B

Query A has this optional filter: [YourDataItemName] = ?YourParameterName? ( or change "=" to "in" if multiselect prompt)
Query B has this compulsory filter: [YourDataItemName] is null

Create 2 Boolean variables:
Variable A = ParamValue('YourParameterName') is not null
Variable B = ParamValue('YourParameterName') is null

Add Variable A as the Render Variable to List A
Add Variable B as the Render Variable to List B

That should do it...

Ricky

COYS

[Ricardo Julio "Ricky" Villa]

Your prompt must be set to optional too...