I am using SSRS 2008.
I have a multi-valued, textual, non-empty parameter named personID. The available values of this parameter are set to the data set (let me call this PersonQuery data set), which is bound to the stored procedure. The default values of this parameter are also set in PersonQuery. This worked great when a page / report was selected for all possible values for personID .... then I have to change something (however, I don’t remember anything, to change something ...?), Because now it broken ... Everything is still fine locally, but not on the server.
When I first noticed that it was broken, only one of the available values was selected. Therefore, I decided to try putting ltrim (rtrim (value)) in my stored procedure without changing any names or aliases .... and updated / updated the fields in the dataset to be safe and redeployed the report to the server. Now that the page loads, no default values have been selected for this parameter.
Can anyone suggest anything to try or have any idea of what's going on here?
source
share