Display two types of reports

  • 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.

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

  • 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.

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

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