Got an question on how SSRS Integrates with Tessitura.
I'm testing out an SSRS report, where the available values for my parameter is based on a query on a second dataset, which I setup within the SSRS Report. However, is it possible for that dataset of available values for the parameter to present itself inside Tessitura, as a list of values? From what I see inside the Tessitura documentation, the only possibility is for parameter value passing inside Tessitura is to pass a singular value over, which gets processed accordingly. It doesn't mention anything about parameters that is depending on a query on a different dataset.
What are your thoughts on this? I hope for the best, but I fear the worst.
I believe you are looking for a dropdown parameter dependent on the value of another parameter for filtering? If so, this can be done in either the Tessitura Report parameter window, OR in the SSRS report parameter section, but NOT in combination. In the Tessitura Report Setup, take a look at any ticketing report setup to see how, for instance, the value a user chooses in "Season" is used to filter the corresponding list in the Performances parameter dropdown.
Hope that answers your question.
-Ryan
Okay, I understand that you can't have the SSRS-query based parameters be shown inside the Tessitura application. So, I re-deployed the report with the parameters set as visible (so that It can be chosen inside SSRS at execution, and deleted the Tessitura parameter that's tied to it (so Tess won't pass that parameter). I am running into a problem where, when the report is rendered via Tessitura, it asked me to choose the parameter from a dropdown list, but it does not allow me to choose the parameter. This issue does not occur when running the report directly from SSRS.
I've done additional troubleshooting, and here's what I found.
This issue occurs when I run Tessitura on my desktop machine, running Win7/IE8. The issue DOES NOT occur when I run Tessitura in our Terminal Server setup, running Win2003/IE6. Anyone seen similar issues?
The "unable to select a value" is a known Microsoft bug that can be solved with the following registry fix in this knowledgebase article.
http://www.tessituranetwork.com/network/Learning/Tessitura%20Knowledgebase/Reports/Other/19336.aspx
Got it, and got it to work! thanks for the help!