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.
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.