Display two types of reports

• vick12

  SSC Eights!

  Points: 856

  More actions

  November 2, 2011 at 7:17 pm

  #247277

  Hello Everyone,

  I am using ssrs 2005 and have a requirement where I need to have two types of reports(TypeA and TypeB). TypeA and TypeB reports differ in grouping and subtotals but the overall layout remains same.The user can select any one of the reports or both reports at a given point of time.When the user selects TypeA, then only TypeA needs to be displayed. If the user selects TypeB, then TypeB needs to be displayed and if he select both then both reports needs to be displayed.

  I was not sure what will be a best approach to achieve this kind of functionality. The report will be displayed in the report viewer, so I do not want to use sub reports as it will cause an overhead.

  One approach I was thinking was using two tables objects with two different datasets(from the same data source) with in one report and display one table and hide another or display both depending on what the user wants?

  Thanks for your replies and suggestions.

• atlancharlo

  Mr or Mrs. 500

  Points: 554

  More actions

  November 3, 2011 at 11:34 am

  #1402819

  I think your approach will work,you can create two datasets and join them into a table object.

• SQL_path

  SSCrazy

  Points: 2810

  More actions

  November 7, 2011 at 4:22 pm

  #1404210

  create a report parameter report

  type , give it values like type A, type B in the parameter window.

  now create 2 different lay outs or dataregions or tables in the body of your report.

  then set the visibility condition of that particular dataregion/table.

  iif(parameter!value = 'Type A', false, true) & Similarly for the other table

  try that.