• 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

    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!

  • $organization in reply to Former Member

    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

Reply
  • $organization in reply to Former Member

    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

Children
No Data