Post reply

To avoid underscore while exporting report

  • October 10, 2008 at 3:04 am

    #192028

    Hi Friends,

    Can u tell me how to avoid underscores while exporting report to Excel Format.

    For ex: I have created a report with name "My Report.rdl".While exporting in Excel Format

    the file name sholud be"My Report.xls" instead of "My_Report.xls"

    Thanks in advance

    vijaya

  • October 10, 2008 at 9:51 am

    #883514

    The only way this can be done (that I am aware of) is a very convoluted process changing the style sheets which is coded in xml and isn't an easy thing at all - this link might help or create a VB package that will rename the file for you i.e. removes the _ using a find and replace.

    http://spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx

  • October 13, 2008 at 5:48 am

    #884094

    Thanks a lot:)

  • October 14, 2008 at 8:38 am

    #884672

    Would it be easier if you just took the space out of your report name: i.e. "My Report" is renamed "MyReport" on the .rdl file? Then when you export, the file will be exported as "MyReport.xls".

Viewing 4 posts - 1 through 3 (of 3 total)

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