Post reply

How to activate one subreport and disable the other in SSRS 2008

  • March 28, 2011 at 2:51 am

    #236860

    Hi ,

    I have one main report which has two subreports based on two parameters. We are facing performance issue, as with this design i think dataset is being generated for both the subreports and when End-User selects a particular parameter the desired subreport is shown.

    Can someone suggest a design in which only the selected parameters subreport dataset will be generated.

  • March 29, 2011 at 9:45 am

    #1304976

    I would probably use an IF to decide whether or not to run the code for the dataset for the sub report. For example:

    IF ParameterValue = RunMe

    BEGIN

    Your dataset code for the subreport here

    END

  • March 29, 2011 at 9:45 pm

    #1305239

    Just to add we are using MDX. Is it possible to have IF conditions in MDX Queries?

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

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