Working with my first SSRS report, and still feeling my way forward for the first time with this new tool. I have created a report with no parameters: it runs on the current fiscal year without and input parameters at all. The Sproc runs fine, and the report runs fine in the Preview window of BI Studio. It is set up in the Report Setup System like so:
Seems pretty straightforward, but when I run the report I get:
Anyone have any ideas? Thanks.
For SSRS POST reports to run in the foreground, the Tessitura SSRS Proxy web service must be installed, and the SSRS_Proxy entry set in t_defaults to the URL for the proxy. While I haven't seen this error before, my guess is that it might be caused by a missing SSRS proxy web service.
Thanks for your reply, Steven. I believe we have the TessituraSSRSProxy files installed as necessary, but we've never used them before. It shows up in IIS Manager under the Default Web Site, and the URL"http://actedata/TessituraSSRSProxy" is listed in t_defaults under SSRS_PROXY.
When I try to load that URL in a browser I get a 403, "website declined to show its page".
Something doesn't seem quite right with the proxy installation then; when I browse to mine, I get:
Error
An error occurred during the automatic redirect.
Error:
The passed 'id' value was not a valid integer.