This post was almost going to be three paragraphs of whining about troubleshooting and error messages, but I figured out what my problem was! Naturally, this raised more questions. :-)
All the time I see reports that use a parameter for filtering only, just from within the client. Like, the stored procedure takes a perf_no, and so the report parameters have a season setting that filters the performance dropdown. I know how to filter parameters by other parameters, but I seem to run into trouble whenever I want to NOT pass this parameter through to my stored procedure. I've tried to figure this out in InfoMaker and SSRS without success.
For SSRS reports, what I thought I could do was to simply not assign the "SSRS Name" value in Report Setup for the one I was using to filter, and that would be it -- all the rest would be sent through to the report and underlying procedure. But, this causes a nasty server error from TessituraWeb. How do you do this? Is there something in SSRS I need to do to define a parameter that is not sent to the stored procedure? I know I could of course add the parameter to my stored procedure, but I'm not convinced that's necessary.
The second question: I was looking at the list of SSRS reports in TOTG, and noticed that on the report selection page, it listed my report with a red exclamation mark after it. I am pretty sure it means something like "problem", but I don't see that in the documentation -- does anyone know what that is supposed to mean?
Answered my first question: all you have to do is create a new parameter in SSRS as a dummy. The parameter won't go anywhere since the stored procedure is linked from a separate dataset object.
Aha, and just answered my second question! The little red exclamation mark has a tooltip -- it's the "updates system data" alert icon equivalent.