locked
How to call subreports from main reports. RRS feed

  • Question

  • Hi,

    My query is, i have to call 4 subreports and 1 main report.

    i have to  call the 4  subreport from main report repetadely based on the parameter values.

    how can i do that?

    Please let me know...

    Monday, October 24, 2011 2:01 PM

Answers

  • Are you looking to call your subreports from a dropdown like shown in the blog below?

    http://road-blogs.blogspot.com/2010/04/report-selection-in-parameter-toolbar.html

    The above article uses a parameter, and based on that displays the subreport.

     

    Or do you want to use the subreport item from the toolbox?

    Can you explain your requirements in detail? 


    Cheers,
    Jason
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

     


    • Edited by Jason Tom Thomas Monday, October 24, 2011 2:34 PM
    • Proposed as answer by Zilong Lu Tuesday, October 25, 2011 10:57 AM
    • Marked as answer by Zilong Lu Tuesday, November 1, 2011 1:28 AM
    Monday, October 24, 2011 2:33 PM

All replies

  • I think you can link  your sub report with main report based on parameters , I mean not need to call explicity

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, October 24, 2011 2:07 PM
  • Are you looking to call your subreports from a dropdown like shown in the blog below?

    http://road-blogs.blogspot.com/2010/04/report-selection-in-parameter-toolbar.html

    The above article uses a parameter, and based on that displays the subreport.

     

    Or do you want to use the subreport item from the toolbox?

    Can you explain your requirements in detail? 


    Cheers,
    Jason
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

     


    • Edited by Jason Tom Thomas Monday, October 24, 2011 2:34 PM
    • Proposed as answer by Zilong Lu Tuesday, October 25, 2011 10:57 AM
    • Marked as answer by Zilong Lu Tuesday, November 1, 2011 1:28 AM
    Monday, October 24, 2011 2:33 PM
  • you can  choose a jump to report option and have your parameter connected to that report
    Monday, October 24, 2011 7:37 PM