Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
click on - linked reports ssrs

Answered click on - linked reports ssrs

  • Thursday, January 03, 2013 5:57 PM
     
     
    Sign In to Vote
    0

    Hi,

    I have main report1- (Member_Claims) as below.

    ClaimNO Visit Date
    1253 12/17/2009
    1252 3/14/2009
    1251 1/28/2008

    There is another report2 -(Member_Cliams_Details) with parameter visit date, that works fine saperately. Report2 gives details of claims for that visit date.

    My requirement is when i click on any visit date in report1, then that visit date should be used as parameter in report2 and then report2 is displayed.

    Is it possible in ssrs?

    Any help is appreciated. Its urgent.

    Thanks,

    Punia

     

All Replies

  • Thursday, January 03, 2013 6:58 PM
     
     
    Sign In to Vote
    0

    Hi,

    1. Right click the textbox that displays the visit date on Report1 and goto properties.

    2. Select Action

    3. Click on Goto Report

    4. Browse to the location of Report 2 and click on it

    5. Add a parameter to pass, on the pulldown, select your visit date fld from your datasource

    6. Done

    Hope this helps! k r o o t z

     
  • Thursday, January 03, 2013 6:58 PM
     
     Answered
    Sign In to Vote
    0

    Hi,

    1. Right click the textbox that displays the visit date on Report1 and goto properties.

    2. Select Action

    3. Click on Goto Report

    4. Browse to the location of Report 2 and click on it

    5. Add a parameter to pass, on the pulldown, select your visit date fld from your datasource

    6. Done

    Hope this helps!

    Hope this helps! k r o o t z

    • Marked As Answer by babbupunia Friday, January 04, 2013 4:04 PM
    •  
     
  • Friday, January 04, 2013 3:38 PM
     
     
    Sign In to Vote
    0

    Thanks Krootz. it Works!

    Do you know how to hide report2 (linked report) in reporting server. So that user ca only see the main report (report1).

    Thanks,

    Punia

     
  • Friday, January 04, 2013 3:49 PM
     
     
    Sign In to Vote
    0

    I'm glad it did. Please mark as answer.

    To hide the subreport, from the report mananer, follow below and there should be a check box to hide in tile view.

    Hope this helps!

    k r o o t z

     
  • Friday, January 04, 2013 4:06 PM
     
     
    Sign In to Vote
    0

    I Got it.

    All you have to do is check the option "hide in tile view" in properties of report in reporting services.

    Punia