June 26, 2014 at 9:54 am
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
June 26, 2014 at 1:00 pm
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);June 26, 2014 at 2:41 pm
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)?
June 26, 2014 at 4:06 pm
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);June 27, 2014 at 10:22 am
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?
June 28, 2014 at 4:05 am
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);June 29, 2014 at 9:04 pm
I am using visual studio 2008. In the property, I am entering 'gov qc-export'
June 30, 2014 at 6:29 am
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.
June 30, 2014 at 8:52 am
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?
July 1, 2014 at 6:12 am
Go to the Properties Page of the solution and change the TargetServerVersion (right below where you set the TargetServerURL for publishing) to 2008 R2.
July 1, 2014 at 8:09 am
I can not change the reporting services since it is only running on sql server 2008.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply