Posted a variation of this questions in the Reports forum and haven't heard anything yet.
I have a report that uses the TStats wearhouse as a Data Source for one dataset and a simple SQL query as a second data set. I've mostly got everything working. What I'm running into is that the TStats based dataset will only take parameter specifications after the report is launched, in the top part of the window. I can't synk up the parameters to the those attached to the SQL procedure.
I've seen a few people talk about having TStats based SSRS reports and mention that linking the parameters and working with them in Report Setup was difficult. I'd go with difficult, as long as I could get it to work.
Thoughts?
This sounds really interesting -- can you provide your RDL file? All of the report's parameters should exist on the report level, and this is where defaults and visibility settings are set up. The parameters for your datasets are specified on the dataset level, and they can be specified directly as a report parameter, or a static value, or even an expression.
One other gotcha I can think of is that after you deploy the report to a server for the first time, parameter-specific settings will not be updated by subsequent deploys. If your report says the parameters are hidden but they are still showing up, you will need to modify the report parameters on the SSRS server.
When I designed the TStats query the parameters for that section of the report automatically populated and created their own hidden datasets that ran queries/expressions specific to pulling data Tstats style. I've been able to change them from a multi-select to a single, which still isn’t a fix. It’s also the only change I’ve been able to do that doesn’t result in a deploy fail. I’ve made the parameters hidden, but then when I try to run the report actually in Tessitura it says that those Tstats parameters are missing their values.
I think I need to convince the hidden datasets to use a manually entered parameter, but it doesn’t like the that the data types are different and I have been having issues getting them to convert.