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
I second everything that Sara said. Additionally, I would guess that the reason your Contact Info value didn't get passed correctly is that the value that was passed by the Tessitura parameter window didn't match the values you had set up for the dropdown in the SSRS parameter setup. As a general rule, if you're handling the parameters in Tessitura, you're much better off setting the parameter in SSRS up to just be a string or an int or whatever data type is appropriate rather than setting it up as a dropdown. Leave the parameter visible while you test, so that you can easily confirm that the correct value was passed into it, and then hide it once you're satisfied that it's working right.
-Galen