June 28, 2010 at 8:38 pm
I have a report with page breaks in ssrs 2008 and when i rendered to excel it is creating 2 worksheets in excel.
I want it to be in 1 work sheet.I have tried to remove the page breaks and rendered to excel then it is coming in 1 worksheet.
Is there any way that i can use the page breaks in the report and if i rendered to excel i need it that it should come in 1 worksheet?
June 29, 2010 at 9:16 am
I don't think so, by using page break you are telling the SSRS to show the part of the report after the pafe break in a new page and new page is excel is a new sheet.
June 29, 2010 at 9:35 am
The only way I can perceive this working is to create a custom macro in Excel to effectively "move" sheet2 to sheet1.
The macro would need to sit outside of the generated excel spreadsheet and lookup the filename, check contents, perform the move, save and exit...something like:
Sheets("Sheet2").Select
Cells.Select
Range("A2").Activate
Selection.Cut
Sheets("Sheet2").Select
Range("B9").Select
Columns("A:A").ColumnWidth = 8.57
Columns("A:A").EntireColumn.AutoFit
Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Application.CutCopyMode = False
Selection.Cut
Sheets("Sheet1").Select
ActiveSheet.Paste
gsc_dba
July 2, 2010 at 1:45 pm
May be worth it to mention that this is a built in functionality in SQL2008 R2.
Here is how to do this...
http://www.bidn.com/blogs/PatrickLeBlanc/ssis/762/ssrs-r2-naming-excel-worksheet-tabs
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply