I have one SSRS report that when I try to export the results say to excel, it opens a browser window to the Tessitura Web Reports then prompting for user creditentials. I can't find anything different on this report than any other report that have. Is there any reason why this report would be different?
Thanks,
Marty
I had a long-lived support ticket open re: this exact issue.
The example report had several datasets, and some complex tablix nesting, about which Ryan wrote, "From what we can see, the report processor is not able to parse the report hierarchy correctly when trying to render the report. At this point (in the Microsoft framework, not WebReports) instead of simply throwing an exception, it kills the server state. The only solution that we can see, apart from Microsoft fixing the issue, is to prevent the rendering issue all together by simplifying the layout of the report. [...] I think you should try rebuilding this report using a single table object [...]"
...which led me to re-create the report with a single dataset, and simplified layout, which solved the issue for us.