Hi,
I created a custom report in BIDS, but I am having trouble getting the report/SSRS to accept the parameters that get passed from the report window and then run automatically. For example, here is the report window with the parameters selected:
When I click OK, I get the following:
As you can see, “Contact Info” did not accept the “No” parameter and the giving categories I selected did not get passed to the report, as I have to click on the “giving cats” dropdown and reselect the categories I want. Both "giving years" and "list no" did actually accept the given parameter values, but I'm not sure why those did and not the others. Additionally, even after I reselect my parameters, I still have to click “View Report.”
I want the report to select the parameters I initially chose and then run by itself. Can anyone help me with this? I’ve been back and forth between Tessitura, BIDS, and report setup, and I can’t’ seem to figure out the issue. Any help would be greatly appreciated. Thanks!
David
Update: I tried setting the giving categories parameters using the statement that Galen suggested and it didn't seem to have an effect. The other thing I also tried testing was putting a text box in the report that would simply return out the value of the "Giving Categories" parameter, so I could see what Tessitura was actually trying to pass to SSRS. I selected all four giving categories in the report, but the text box was only showing one of the options i selected. So it seems to me that somewhere, the multiple values I select either aren't being rolled up into one string and passed to SSRS, or Tessitura is only accepting and passing on the first option selected and ignoring the rest, and I'm not exactly sure how to fix this.
Again, suggestions are needed and welcome. Thanks all!
The trick that solved the problem was to set the Available Values for the multi-select parameter to None in the parameter properties window in SSRS.