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!