Multiple table with filter or Subreport in ssrs


  • Hii all

    Please guide me 

    what should we feed the most ..?

    multiple tables with parameter based filter OR Subreport

    Help ..

    Dilip Patil..

    Friday, May 09, 2014 7:03 AM


  • depends on the data that are to be displayed and also when you want to display it. FOr example if scenario is like you want all data to be displayed always it would make sense to keep them in same report multiple tables with filter applied. But if scenario is like only some part of data is displayed initially say summary data and detail is displayed as per use request ie like drilldown functionality then it might be better to keep it in subreport as chances are less that user will look at each and every detail level data.

    I've seen cases where subreport execution gets failed due to large response times taken by reports used witin them. So you need to make sure that the reports used within subreports are performing well with low response times.

    Please Mark This As Answer if it helps to solve the issue Visakh ----------------------------

    Friday, May 09, 2014 7:12 AM