Naming Excel Worksheets Issues

Question

Naming Excel Worksheets Issues

Pravasis

Default port

Points: 1455
More actions
October 28, 2010 at 12:19 am

#225576

Hi,
I am using the SSRS 2008 R2 which has the feature of Naming Excel Worksheets. But its not working properly. I have followed the steps mentioned in msdn. Still its not working. Is there any other feature that I need to enable to use this functionality?
Thanks In Advance,
Pravasis
Regards,
Pravasis

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

Can you post the MSDN link so that we know what you're talking about? Seriously, pretend that you know anything about your problem, read the question you posted, and try to figure out what you're talking about.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Pravasis Default port Points: 1455 More actions · Answer 2

Oops.. I tried the following link to implement the same. But it did not work as expected.

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

Regards,
Pravasis

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 3

Hi, the renaming of excel worksheets is quite straigtforward. Do you have groups in your report? and do they have a page break between them?

All you need to do is change the 'pagename ' property for the group to the field name you want for the worksheet.

http://www.reportingservicestnt.blogspot.com

Pravasis Default port Points: 1455 More actions · Answer 4

Even I thought so. It has groups and I have given page breaks after each group. While writing in the excel file it is also creating the sheets but the sheet names are not as expected. Its giving Sheet1, sheet2 etc.

Regards,
Pravasis

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 5

When you view the report in bids do you have a separate page for each group?

The field you are using for the groupname place it in the group header, does this now show the correct value for the group ?

Pravasis Default port Points: 1455 More actions · Answer 6

yes, it does. Thats what I tried when the sheet renaming did not work. Did you change any setting to enable this feature. Even I downloaded the sample report that was there in the msdn site. Its also not working in my system!!!

Regards,
Pravasis

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 7

Which sample report did you use?

I should have read the blog! i will check it out.

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 8

I have tried the Product Catalog 2008 report and the renaming does work except for the second page which is to do with document map and the pictures on the first page. The sheet renaming of the Catalogues does work. I think it must be the report but if the sample is not working then I don't really know what it is the cause. It might be worth trying the sample report again to see if you can get it to work.