SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting : Addition of Custom Delimiters


Reporting : Addition of Custom Delimiters

Author
Message
ganatra.neha
ganatra.neha
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 167
Is it possible to add custom delimiter of ! in Text file in Sql Server Reporting Services.

My requirement is to export the data in text file with Custom Delimiter ! from Reporting Services.

Any help or idea to achieve above task is appreciated.

Thank you in advance.
happycat59
happycat59
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4799 Visits: 3227
You can do this by adding a custom renderer to reporting services based on the existing CSV renderer.

To do this you need to edit the reporting services config file "rsreportserver.config" (make sure you backup it up before you start). The file is located in a folder similar to
C:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\bin

Open the file (e.g. with notepad). Towards the end of the file, you will see the "Render" tags followed by the various renderers (as "Extension" tags).

Find the CSV extension. It should look something like :
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>


Copy this line as a new line. Change the name to something unique. Remove the / from the end of the line.
Add a closing tag for the "Extension" tag.

Add the following between the opening and closing Extension tags:
<OverrideNames>
<Name Language="en-us">MyDelimiter</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>!</FieldDelimiter>
</DeviceInfo>
</Configuration>
Save the changes and restart the reporting services services.

You should now have a new option when you save the report (with the above, you would see "MyDelimiter" as one of the options you can pick from when you save a report.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search