How to Export the Report data into More than one tab in Excel

• Smash125

  Hall of Fame

  Points: 3547

  More actions

  October 11, 2012 at 7:23 am

  #283003

  Using Following Query i have generated Tabular Report

  SELECT Person.Contact.ContactID, Person.Contact.FirstName, Person.Contact.MiddleName, Person.Contact.LastName, Sales.SalesOrderHeader.TotalDue

  FROM Person.Contact INNER JOIN Sales.SalesOrderHeader ON Person.Contact.ContactID = Sales.SalesOrderHeader.ContactID

  ORDER BY Person.Contact.ContactID

  Now I want to export Report Data in such i manner to excel

  Conditions

  ContactID>1000 and ContactID<2000 In To First Tab in Excel

  ContactID>2000 and ContactID<3000 In To Second Tab in Excel

  ContactID>3000 Third Tab in Excel

  Please let me know how we can achive it in SSRS

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  October 11, 2012 at 8:31 am

  #1548159

  See if this works for your situation: http://weblogs.sqlteam.com/joew/archive/2008/11/12/60755.aspx

  HTH,

  Rob