Default value in cascading parameter

[Fuigi]

Hi,

I created two drop down list, and the second his a cascading parameter with the first.

I create a default value, but if I change the value in my first drop down list my report is empty I'm force to choose a value in the second drop down list too to have a report not empty.

I want to have default value for all my choice in the first drop down list, is that possible ?

For example if in my first I choose A then in second it's will be B
and if I choose 1 in the first then the second will be 2

etc.. For all value in my first drop down I want a default value in my second.

[gpollock]

Do you want one default value, or a distinct default value per drop-down value.  If you just want one value, you could make your second drop-down optional and use a case condition in your filter to set a default value.  You could also accomplish this with a prompt macro in your filter.

If not, this might get a little complicated, but you could do something similar to the above, and create a query that has default values set up for each value in your first drop-down.  Join that query to your main query and use the "new default" value in the above.

I don't think you can set a value just from the drop-down properties, though.