Hi, I need to export various reports created using SQL Server 2005 Reporting Services to ONE Excel workbook (with multiple work sheets - tabs - one for each report). Is there an option in Reporting services that can allow me that ? Thanks.

Try putting a page break after each section. That should force data onto multiple tabs.

If you need to "combine" other reports into a single report, create a new Report, add a rectangle with a subreport for each other report, and set PageBreakOnEnd for the rectangles. EDIT: Chris's response here is much better: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=793576&SiteID=1

Thanks, Geoff, it works all right If I had to get the name of the individual report on the tab in an Excel worksheet, is there a label or something in the report editor that i can use? That way i can directly send the different names of the reports to different tabs in the Excel worksheet. Also, I'm creating a graph in Reporting Serives, when i export the graph to excel it is exported as an image, whereas I would like it to be exported to Excel as an interactive graph so if the user manipulates the data in the Excel report, the graph will reflect changes. Thanks for any ideas !

Afraid the answer is no to both questions. There's no way to set sheet names in Excel as of now, although we're considering it for a future version. And we don't support native Excel charts at this point; it's definately on our wishlist for the future.

Hi, In my report, I have 3 rows in the details section. I need toshow all the 3 rows into a single line when it is exported to excel. Is this possible , please help me.

I'm sorry, I don't think I understand what you're trying to accomplish.Each row in RDL will get rendered to at least one row in Excel (depending on the content of the row and other items on the page, it may span multiple rows). I can't picture how you would want it to work differently; if you can explain in more detail, maybe I can give better guidance.

student, instead of 3 detail rows, use one and you can set it the expression equal to: =Fields!Field1.Value & vbcrlf & Fields!Field2.Value & vbcrlf & Fields!Field3.Value the vbcrlf's will force a line feed to make it in one detail row and thus, one row in excel

Hi, I have a report being exported to excel. In the data to be displayed in detail row, I have form feed for the text to be displayed one line after another, but in the same cell. Like, --------- |Line1| |Line2| |Line3| --------- in the same cell of an excel sheet. Data example: Report Name: Test Report\r\nDate: 15/11/2007\r\nAuthor: Seshadri But while the report gotexported, the details row height doesn't get adjusted according to the data, although i specify the row height in RDL file. I had to manually extend the row height to view the data. Please let me know if there is any work around. Thanks, Seshadri

This feature was added in Report Builder 3.0. http://technet.microsoft.com/en-us/library/dd255234.aspx#WorksheetTabNames http://technet.microsoft.com/en-us/library/dd255278.aspx "To provide the sheet name, you set the PageName property of a table, matrix, list, group, or rectangle." "Use the InitialPage property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the PageName property to provide different names for each worksheet. Each new report page, defined by a page break, is exported to a different worksheet named by the value of the PageName property."