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 attempted to "Refresh Fields" on the dataset in Visual Studio? That usually grabs any new parameters for me when I make changes to a stored proc.
I have tried that, but the issue is that parameter exists within the proc, and Visual Studio, and the Tessitura report setup, yet fails to be passed from Tessitura to the proc as is evidenced by the traces I run through SQL Profiler. Good suggestion, though!
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!