I have a report in SSRS, originally from Infomaker, that runs fine except that one of the eight parameters used does not get passed to the stored procedure. The parameter is new to the SSRS version of the report. I can see this parameter in the gooesoft tables (both for the report and the request). I originally copied the SSRS report setup from the Infomaker setup using export and import. I have tried recreating the report setup using different IDs, either with new text appended to the front or the back of the original report ID (in case the ID was being read only to a certain number of characters). I have hand typed all of the report setup information, instead of importing or copying it. I have changed the order of the report parameters and still, nothing. I can, specifically, not see the parameter being passed to the procedure using SQL Profiler. Any information or advice will be most welcome!
Thanks,
Ryan Huber
Hi Ryan,
Have you check the parameters on the report itself? It might be helpful to make the paramters visible. Also it might be helpful to run the report from the SSRS url rather through the Tessitura client.
Jon
Well, that got me on the right track. I ended up having to manually add the parameter to the report dataset. For some reason, it wasn't populating when I hit refresh fields, and this behavior was something new to me (as is the Tessitura system), so I was looking in the wrong place. But, everything is fixed for now! Thanks, All!