In my report one of the promt values are ipdated by the Finace Department regularly (see the last box).
When they run i report the updated values are not auto-selected
(http://s10.postimg.org/a4xtm0vyh/image.png)
even though if i define in the report properties that all the values should be selected, the newly entered values are unselcted when the report is run, hence the image above.
Is there way to do the following:
- Always select all the values in the all the promps, even if the the new values are entered
- Choose the current year and the current month (dropdown boxes: Dette år and Denne periode)
Hello aftabp,
I do not have the exact solution that you are after i.e. select all the values all the time, regardless of values changing in the source. The only way I could think of is using javascript to select everything when a user runs the report.
If you do not want to use javascript, a workaround could be......
"Select all" is equivalent to select nothing at all in the prompt. So, why make it a required prompt in the first place. Make the filter optional, and do not select anything. That way, when the report is run without selecting anything for that prompt, it returns all the data.
If you "have to" keep the prompt as required, then add a static choice in the prompt UI as "All". Then make the default selection for the prompt as "All". Finally, change the filter expression to have an OR in it...something like... [Column to be filtered] in (?p_MultipleSelectPrompt?) OR ?p_MultipleSelectPrompt? = 'All'
Hope it helps!
-Cognos810