• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 115 views
  • Users 0 members are here
Related

SSRS Paramters subreport not working in LIVE

Beth Hawryluk
$organization

Hey all,

I hate to post such a newb question on here but I haven't been able to figure it out on my own. Google has not been a good friend on this one...

I'm finally learning how to write SSRS reports which is super exciting. I've written a few basic ones in my TEST system so far. Everything looks great and my end users love them. But when I deploy them to my LIVE system something goes wrong. At the top of the report where the parameters subreport should be displaying I see this:
Error: Subreport could not be shown.

The rest of the report displays fine and the data appears to be correct. I built them using the awesome report templates provided by TN as the base. I admit that I forgot to deploy the report parameters to LIVE at first but it didn't resolve the problem when I realized and did the deploy. I've also checked all of my Data Connections and everything appears to be on the up and up from that end.

If I try to run the report through IE (http://<<servername>>/reportserver) I get the error: The 'UserGroup' parameter is missing a value.

But I also get that when I try to do the same thing for my TEST server... and that one appears to be working fine in the client. I also thought I didn't need to supply values for the parameters subreport...?

Needless to say, I'm confused and probably missed a small and silly step along the way.

Any SSRS gurus out there that can point me in the right direction?

  • $organization

    Hi Beth,

    The report template refers to a sub-report ReportParameters.rdl that also needs to be uploaded to your report server (check that the path is correct). Parameters like UserGroup which is a string I usually assign a default value of dbNull and RequestId which is an int of 0. These will get populated when the report is run thru Tessitura.

    Hope this is helpful.

    Lou Ann

  • $organization in reply to Lou Ann Mendoza

    Hi Lou Ann,

    Thanks so much for your response!

    I have verified that I did deploy the report parameters rdl to my live server as well. So it should be there!

    I thought that the standard behind-the-scenes parameters didn't require preset values? However, I did try giving them default values as you suggested and it didn't seem to make any difference.

    I find it weird that the report works perfectly fine in TEST and in LIVE the data loads fine... it's just the parameters at the top that don't render for some reason.

    Any other suggestions for me?

    Thanks again!

  • $organization in reply to Beth Hawryluk

    I would think it would have to be either the path to the subreport is wrong or you did not assign a data source on the server to the ReportParameters.rdl (go into Manage and then navigate to your data source).

  • $organization in reply to Lou Ann Mendoza

    Ah! Thanks again for your help. You definitely helped me get on the right track. I don't know how I managed to do it but somewhere along the way between deploying to Test and deploying to Live I made some sort of change to the ReportParameters.rdl and it was now looking for me to supply all the values instead of pulling them itself.

    I fixed it by deleting the .rdl entirely, putting it back in fresh, and then deploying it.

    Everything is smooth sailing now!

    You rock!