Post reply

SSRS 2008 r2 Subreport Data load when clicked

  • December 6, 2012 at 4:30 pm

    #271578

    Need Help...

    I created mater and detail Report.

    Detail Report works as Subreport, but contains 1000's of data Row.which i want to make it invisiible, when viewed Mater Report.

    But when i click parent id from Master Report, Detail SubReport should Load on same Report

    I tried all ways in SSRS, but no use... because Subreort always load wehn Master report load.So no use of Subreport.

    Does anyone have idea about this...

    It is very argent...

  • December 7, 2012 at 9:44 am

    #1566682

    Right click on your subreport and go to the properties and choose the visibility tab. Set it to hide, then check the "Display can be toggled by this report item" and choose which textbox in the master report you want to use to toggle the visibility on and off.

  • December 9, 2012 at 2:29 pm

    #1566890

    Hi Daniel,

    Thanks for the response..

    Basically subreport data loads when the main report executes.

    like I added the subreport in detail area of one tablix,

    and have parameter as group id of main tablix report.

    so every group id , this subreport will be called and executed.

    What I want that subreport will be executed only when user click the Group ID.

    so the performance of main report will be improved.

    in this situation I tried Drill through Report, But the child report is open in another window , which my cliect doesn't like.

    So, for this type of sinareo, what will be the best thing i can do ?

    I need a some trick, so that subreport will be open in main report and it doesn't affect the performance of report.

    Any suggestion will be helpful

    Thank you

    Sneha

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

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