Display 2 different report output results in tab 1& 2 of the single Spread sheet.

• Saintmount.Sql

  Ten Centuries

  Points: 1023

  More actions

  March 24, 2012 at 1:14 pm

  #253089

  HI,

  I have one requirement to generate SSRS report output in spared sheet 1, 2 tabs.

  I’m currently having 2 separate reports (Detail and summary kind of information). But my user wants to bring those 2 separate reports (Detail and summary kind of information) in to single report.

  So that when we generate report, Detail report should go to 1tab (sheet1) of the Excel sheet and summary report output display in 2tab (sheet2) of the same Excel sheet.

  Please let me how do arrive solution for this scenario to display 2 different report output results in tab 1 and 2 of the single Spread sheet.

  Thanks in Advance.

• Kaniguan_SQL

  Say Hey Kid

  Points: 681

  More actions

  March 26, 2012 at 7:52 pm

  #1464668

  Hoping this will help you. this is also my problem before.

  This is what i've done with my report and it's working.

  create multiple tablix and dataset in the SSRS report and have a page break between them. That will make them export to excel as different tabs.

• tom.wauters

  Say Hey Kid

  Points: 706

  More actions

  March 27, 2012 at 3:54 am

  #1464825

  Additionally, you can give a nice name to the tabs, like 'Summary' and 'Details'.

  This can be done using the 'PageName' property of the tablix/matrix/chart