Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4191
  • Last Modified:

changing a ssrs subreport name dynamically

I want to change the ReportName property of a subreport in the SSRS Dynamically.

The value of the name will come from a table in sql server.

When the report runs, i would like to pull the name of the report from the table in the Database and change the subreport name to match that value.
0
oseibonsu
Asked:
oseibonsu
  • 2
  • 2
1 Solution
 
aelliso3Commented:
I fought this same issue once before and the answer to the question as asked is no because the ReportName properties field does not take dynamic values.
There is a possible workaround if you're willing ... you can create ALL the subreports that you need and place them onto the main report. Using the field, or parameter, you can dynamically unhide the subreport that you want ...
0
 
oseibonsuAuthor Commented:
I don't want to hide or unhide. I would rather create the RDL dynamically. (does anyone have method or link to a site on how to do this?)
0
 
aelliso3Commented:
Then create an app that will display the reports instead of using Report Manager and change the xml in the rdl file on the fly. SSRS embeds the xml in the database without giving the front end the option to change it. This is why you have to create your own means of displaying it ... Here is the section that you have to change in the xml:

<Subreport Name="Subreport4">
     <ReportName>Report1</ReportName>  

Good Luck ...
0
 
oseibonsuAuthor Commented:
Question Answered
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now