• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 50 views
  • Users 0 members are here
Related

No data in SSRS report in client

Frances O'Connell
$organization

Hi everyone,

Happy Friday!

...or it was, until I hit this problem in SSRS.  I have just hooked up an SSRS URL report to our Test Client in Test Report Set-Up, given myself permissions in Test Security, and am running it in Test.  It generates without errors and with the correct SSRS template (I can see my title, headers, time stamps, and sorting functionality) but no data!

When I run the stored proc in SSMS, it generates data for these parameters. When I preview the report in SSRS, it generates data for these parameters. And when I preview the report in Report Server, it generates data for these parameters! 

I have granted execute permissions to impusers. And I have given my user group permission to run the report (obviously, I guess, since I can run it in Reports & Utilities).

I would be worried that my URL is wrong, but wouldn't that be screwing with the report template, too? I would also be worried about my data source set-up in Report Manager, but wouldn't that throw an error? Or at least affect the version I can view in Report Viewer?

What am I forgetting??

Thank you for any suggestions!

frannie

Parents
  • Former Member
    Former Member $organization

    Hi Frannie,

     

    Have you set Execute permissions on the procedure that runs the report? In Report Manager there is also security which I think you are referring to below. And in the Security app you need to grant permissions to the report also.

     

    Also, sometimes I have to Exit Tessitura (not re-login) when I make changes in reports so I can see the changes.

     

    Gloria

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Friday, October 10, 2014 4:47 PM
    To: Gloria Ormsby
    Subject: RE: [Tessitura Technical Forum] No data in SSRS report in client

     

    Hi Gloria,

    Thanks for the tip! I had not done this. So I did, and along the way discovered that I had the report connected to the wrong data source in Report Manager (correct connection string in that incorrect data source, though, so I didn't catch it during preview in Report Viewer). I corrected this and built and deployed. No errors, and I can preview successfully in Report Viewer online as well as inside SSRS.

    but still no data in the client.

    Is there another step I'm missing?

    Thanks so much,

    frannie

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 10/10/2014 7:59:52 PM

    Have you tried to build and deploy the report again? And I would verify the data source in Visual Studio before doing that.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Friday, October 10, 2014 3:47 PM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] No data in SSRS report in client

     

    Hi everyone,

    Happy Friday!

    ...or it was, until I hit this problem in SSRS.  I have just hooked up an SSRS URL report to our Test Client in Test Report Set-Up, given myself permissions in Test Security, and am running it in Test.  It generates without errors and with the correct SSRS template (I can see my title, headers, time stamps, and sorting functionality) but no data!

    When I run the stored proc in SSMS, it generates data for these parameters. When I preview the report in SSRS, it generates data for these parameters. And when I preview the report in Report Server, it generates data for these parameters! 

    I have granted execute permissions to impusers. And I have given my user group permission to run the report (obviously, I guess, since I can run it in Reports & Utilities).

    I would be worried that my URL is wrong, but wouldn't that be screwing with the report template, too? I would also be worried about my data source set-up in Report Manager, but wouldn't that throw an error? Or at least affect the version I can view in Report Viewer?

    What am I forgetting??

    Thank you for any suggestions!

    frannie




    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!




    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
  • Former Member
    Former Member $organization

    Hi Frannie,

     

    Have you set Execute permissions on the procedure that runs the report? In Report Manager there is also security which I think you are referring to below. And in the Security app you need to grant permissions to the report also.

     

    Also, sometimes I have to Exit Tessitura (not re-login) when I make changes in reports so I can see the changes.

     

    Gloria

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Friday, October 10, 2014 4:47 PM
    To: Gloria Ormsby
    Subject: RE: [Tessitura Technical Forum] No data in SSRS report in client

     

    Hi Gloria,

    Thanks for the tip! I had not done this. So I did, and along the way discovered that I had the report connected to the wrong data source in Report Manager (correct connection string in that incorrect data source, though, so I didn't catch it during preview in Report Viewer). I corrected this and built and deployed. No errors, and I can preview successfully in Report Viewer online as well as inside SSRS.

    but still no data in the client.

    Is there another step I'm missing?

    Thanks so much,

    frannie

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 10/10/2014 7:59:52 PM

    Have you tried to build and deploy the report again? And I would verify the data source in Visual Studio before doing that.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Friday, October 10, 2014 3:47 PM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] No data in SSRS report in client

     

    Hi everyone,

    Happy Friday!

    ...or it was, until I hit this problem in SSRS.  I have just hooked up an SSRS URL report to our Test Client in Test Report Set-Up, given myself permissions in Test Security, and am running it in Test.  It generates without errors and with the correct SSRS template (I can see my title, headers, time stamps, and sorting functionality) but no data!

    When I run the stored proc in SSMS, it generates data for these parameters. When I preview the report in SSRS, it generates data for these parameters. And when I preview the report in Report Server, it generates data for these parameters! 

    I have granted execute permissions to impusers. And I have given my user group permission to run the report (obviously, I guess, since I can run it in Reports & Utilities).

    I would be worried that my URL is wrong, but wouldn't that be screwing with the report template, too? I would also be worried about my data source set-up in Report Manager, but wouldn't that throw an error? Or at least affect the version I can view in Report Viewer?

    What am I forgetting??

    Thank you for any suggestions!

    frannie




    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!




    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
  • $organization in reply to Former Member

    Again, thank you!

    I granted execute permissions for impusers in SSRS. 

    I associated the report to my user group (SysAdmin) in the client.

    I didn't know about the security settings section in Report Manager, but I found it and made the settings for this report match those of a functional report in our Live environment (required I add one role).

    Fully exited the client and relogged in and ran the report - and still no data!

    This may have to wait until next week...