SSRS 2008R2 - Excel 2007 XLSX Render - Tab Names do not render properly

hi

we have two issues with rendering tab/sheet names

1) tab names dont appear at all

2) we get the error message below. please assist

"The max length of the sheet name is 31".

thanks

c

Hi,

2) In MS Excel (you may check in MS Excel 2007 etc.), you cannot specify name of a worksheet with more than 31 characters which is the limitation put forth by MS Excel.

1) Please give us your sample RDL file here, we will check your issue soon. And, which version of the product you are using?

Thank you.

Hi,


I have received your RDL file via mail.

As we already told you that in MS Excel (you may confirm in MS Excel 2007 manually), you cannot specify name of a worksheet with more than 31 characters which is the limitation put forth by MS Excel.

I have logged a ticket with an id: CELSSREP-28700 for your further investigation. We will update you soon.

thank you.

hi

again, i noted 2 errors.

one was the 31 character issue, one was the fact that tab names didnt appear on some reports

thanks

c

Hi,

We had tested your rdl file and fixed it.

Please download: Aspose.Cells for Reporting Services v1.7.0.34 (SSRS 2008 R2)

If it still does not meet your requirement, please provide correct exported excel file.

We will investigate the issue. Thanks for your cooperation.

hi
we tested it. i get the following error. still. i can email you the RDL and EXCEL

c

<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val="–"/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

<![endif]–>

The same worksheet name already exists

at Aspose.Cells.x59e54927437fee85.set_x759aa16c2016a289(String xbcea506a33cf9111)

at Aspose.Cells.ReportingServices.ReportItem.x593bccdf2b9e906f.x958045f9b3dbfc27(xcf736b78463acc83 xb5d36a5b57626517)

at Aspose.Cells.ReportingServices.ReportItem.x5d9a63140eb6b015.Render()

at Aspose.Cells.ReportingServices.Renderer.x287918d12b9d430a(Report x64343a0786fb9a3f, NameValueCollection x4d7e972a483f38e6, NameValueCollection x769338e163ee6eb4, NameValueCollection x69ea43ef171861cd, Hashtable& xcc726f61cfb91835, CreateAndRegisterStream x6af66da7eca40f82)

at Aspose.Cells.ReportingServices.Renderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)


Hi,


Yes, please give us your sample RDL and Excel files, we will check your issue soon.

Thank you.

i emailed you the RDL and EXCEL

Hi,

Thanks for your RDL and Excel files. We have logged your comment and posted your files in our bug tracking database.We will update you asap.

Hi,

We have checked “DailyPosition” report and found issues. Please try the attached fixed version (V1.7.0.37) for SSRS 2008 R2.

your fixed worked!! please closed this bug ticket

do you have this fix for 2005

this still happens for SSRS2005 with aspose ver 1.7.0.46

Hi,


Well, I think you may try our MSI Installer (v1.7.0.45) to use with SQL Server 2005 if it works fine, you may get the MSI Installer from the thread:
https://forum.aspose.com/t/125276

Thank you.

the 1.7.0.45 version in SRS2005 still threw this error

An error occurred while exporting the report.
error message The max length of the sheet name is 31
stack trace at Aspose.Cells.x59e54927437fee85.set_x759aa16c2016a289(String xbcea506a33cf9111)
at Aspose.Cells.ReportingServices.Renderer.x80b6775ad7aafda5(Report x64343a0786fb9a3f, NameValueCollection x4d7e972a483f38e6, NameValueCollection x769338e163ee6eb4, NameValueCollection x69ea43ef171861cd, EvaluateHeaderFooterExpressions x8e9b8ee9ee04750f, CreateAndRegisterStream xfa5acad7c47e3f3c)
at Aspose.Cells.ReportingServices.Renderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions ehfe, CreateAndRegisterStream createStream)

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services

Please download and try the latest version: Aspose.Cells for Reporting Services v1.7.0.46 (SSRS 2005)

Let us know your run results.

Hi ,

We have looked into your issues and found them.

We have fixed this issues for more than the max length of the sheet name for SSRS 2005.

Please try the fixed version: Aspose.Cells for Reporting Services v1.7.0.49 (SSRS 2005).

Let us know if you still face any issue.

that version fixes this bug in 2005

thanks