• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 43 views
  • Users 0 members are here
Related

SSRS Export

Marty Jones
$organization

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

Parents
  • $organization

    Did you have this issue prior to V11? The end user told me that she hasn’t had any issues in the past and this was the first time she has ran it being on V11.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Thursday, March 28, 2013 10:12 AM
    To: Martin Jones
    Subject: Re: [Tessitura Technical Forum] SSRS Export

     

    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.

    From: Marty Jones <bounce-martyjones3217@tessituranetwork.com>
    Sent: 3/27/2013 5:58:26 PM

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    Did you have this issue prior to V11? The end user told me that she hasn’t had any issues in the past and this was the first time she has ran it being on V11.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Thursday, March 28, 2013 10:12 AM
    To: Martin Jones
    Subject: Re: [Tessitura Technical Forum] SSRS Export

     

    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.

    From: Marty Jones <bounce-martyjones3217@tessituranetwork.com>
    Sent: 3/27/2013 5:58:26 PM

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children