ssrs export to different tabs in excel

Question

Post reply

ssrs export to different tabs in excel

wendy elizabeth

SSCoach

Points: 16915
More actions
June 26, 2014 at 9:54 am

#287168

In a new SSRS 2008 report, I have 5 different datasets that are running on the 'Main' report. I am not using subreports due to performance issues. The user wants each dataset to be able to exported to different tabs in the same workbook. Each tab is suppose to be a unique name.
Right now each dataset does go to a unique tab called sheet1, sheet2, sheet3, sheet4, and sheet5. This is probably occuring since I hve the following properties set on each tablix as 'add a page break after', 'repeat header columns on each page', and 'keep header visible while scrolling'.
I would like each tab to have a unique name that is not the generic ones that excel generates. The unique name can come from the dataset names or whereever I can specify them at.
Thus is this possible to have unique names in ssrs 2008 on each tab when the data is exported to excel? If this is possbile can you tell me how to make the unique labels for each excel tab?
If this is not possible, can you tell me if there are other versions of SSRS reports that would label the excel tabs uniquely and how to make each tab name unique? I am asking this question since my company does have ssrs 2008 r2 and ssrs 2012. I
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

No, the best you can do is replace Sheet1, Sheet2 etc with <A Custom String> (1), <A Custom String> (2) etc...

e.g.

MyPageName, MyPageName (2), MyPageName (3) etc

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

wendy elizabeth SSCoach Points: 16915 More actions · Answer 2

Would you tell me or show me how to replace each tab that is generated with a custom tab name when each report is exported to excel?

How can I get each tab to say customtab(1), customtab(2), customtab(3),customtab(4),customtab(5)?

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

click on the main report area, outside the "body" and the in the properties window (F4), set the InitialPageName to "customtab"

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

wendy elizabeth SSCoach Points: 16915 More actions · Answer 4

As per your directions, I did the following: 'click on the main report area, outside the "body" and the in the properties window (F4), set the InitialPageName to "customtab" '

I clicked on the main report and I clicked on the area that is not in the main report area. I could not get properties window (F4) properties so show up. The only properties that I could find was body properties and report properties. The body properties has 'InitialPageName' in it so I set the property. This made no difference on the export.

Thus how do I get to what you are talking about? When I find the properties window, what item should I select? Report, Body, tablix1?

mister.magoo SSC-Forever Points: 47174 More actions · Answer 5

Are you using Visual Studio (or BIDS) or Report Designer?

It sounds like you found the property - as far as I know it is only found in one place, so if you found it it should work - what did you enter in the property?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

wendy elizabeth SSCoach Points: 16915 More actions · Answer 6

I am using visual studio 2008. In the property, I am entering 'gov qc-export'

Tee Time Hall of Fame Points: 3745 More actions · Answer 7

If you have separate tables for each dataset, you can use the PageName property.

Go to the Properties window, choose the table name in the top box, and about 15 properties down, you will find PageName. The value you specify will become the name of the Excel tab.

wendy elizabeth SSCoach Points: 16915 More actions · Answer 8

I got the message. "Warning2The PageName property specified on the data region, rectangle, or group ‘Tablix1’ was removed from the report. SQL Server 2008 Reporting Services does not support the PageName property.".

Thus do you have any other suggestions that I can try?

Tee Time Hall of Fame Points: 3745 More actions · Answer 9

Go to the Properties Page of the solution and change the TargetServerVersion (right below where you set the TargetServerURL for publishing) to 2008 R2.

wendy elizabeth SSCoach Points: 16915 More actions · Answer 10

I can not change the reporting services since it is only running on sql server 2008.

ssrs export to different tabs in excel

Cookies on SQLServerCentral