I have written and published a report using SSRS (no stored procedures) that includes a multi-select parameter. I set-up the parameters as MS in the Report Set-up tool and it behaves that way at first. However, after clicking OK to run the report, none of the options selected for the parameter are passed through to the SSRS report.
Any idea where I've gone wrong? I've checked all the documentation and the forum posts I saw were old and all related to stored procedures, which this doesn't utilize.
Sara,
If you are interested in learning the essentials of stored procedures for Tessitura and SSRS reporting, there are several TLCC sessions that might be of use, including:
Basics of SQL- Querying and Administration http://www.tessituranetwork.com/tlcc/2015/Pres/08-15_Basics_SQL_P2.pptm
Basics of Stored Procedures: http://www.tessituranetwork.com/tlcc/2015/Pres/03-15_Stored_Procedures.pptm
Creating Reports in SSRS: http://www.tessituranetwork.com/tlcc/2015/Pres/09-20_Reports_SSRS.pptm
These won’t give you everything you need, but they are a good start and deal with these tools specifically in the context of Tessitura.
Finally, one of the sessions (Annie Edlich’s Basics of SQL) references a good free site for SQL training and resources: http://www.w3schools.com/sql/