SQL 2008 R2 and Report Builder 3
We make heavy use of linked reports, this saves us creating multiple rdl for different teams.
In linked report parameter settings page we make use of 'default values' a lot.
This works fine but when the linked report is run the user is unable to choose from the passed in multiple parameter values, the report just runs with them. They appear in drop down box ok but are not selectable, they just appear as a list.
So if I had a parameter called 'fruit' and set the default values as Apples, Oranges, Bananas, Strawberries then the report runs for these ok but there appears to be no way for the user to actually select within the parameter so that they wish to run it for Apples only.
I could place them in available values to make them selectable but this is done at rdl level only and the range of values may contain values that they should not see (medical application). The only way around it appears to be to create a rdl for each team with the parameter populated by available values which sort of defeats the purpose of linked reports.