changing ssrs report that has several embedded reports

  • In a new ssrs 2008 rdl, I am going to combine existing reports into one rdl. The reports that will be executed will be determined by a parameter vale that says what reports are to be selected. Each tablix in the rdl will be displayed based upon the particular parameter value of what reports are selected.

    My questions are the following:

    1. If a user wants to change the order of how the reports are displayed in the combined rdl, is there a way to accomplsih that goal? Would you just remove the rdl from its current location and place in the order the user wants to see that report?

    2. If a user wants to delete a report or two from the combined rdl, how would you accomplish this goal? Would you have to go into the rdl and delete the reports that are no longer needed? Would I change the rdl to just never display the reports that need to be deleted?

  • You can't dynamically set the position of objects in rdls (sadly). There may be workarounds that go some of the way though depending on how complex the "subreports" are. If they're simply a tablix per subreport and nothing else, then you might have more luck NOT embedding sub-reports, and instead just converting them to tablixes in the main report, then conditionally displaying the tablixes based on the users choices in a parameter... although obviously this won't change the order of what's displayed.

    IF you're only displaying tablixes, and IF you could shoe-horn all the data into a single dataset (and then a single tablix) you could order "sub datasets" and conditionally display based on parameters.

    ...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply