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


Customizing the CSV subscription in SSRS


Customizing the CSV subscription in SSRS

Author
Message
Rajib Bahar
Rajib Bahar
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 247
I already have subscriptions setup for my report. It sends CSV files over email. I got a new request from the end user that they do not like comma as the delimiter. They want a different character to be used as the delimiter. When I setup the subscriptions, I did not see any step to customize the delimiter. I recommended using SSIS job to customize the delimiter. I would like to ask if there are other better ways to do this?

Rajib Bahar
http://www.rajib-bahar.com
http://www.twitter.com/rajib2k5
http://www.youtube.com/icsql
Luke L
Luke L
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33617 Visits: 6226
You can actually do a lot to customize the rendering extensions in SSRS...

here is a link to the MSDN documentation for 2008 (there is a 2005 page as well) for modifying the CSV extension.
http://msdn.microsoft.com/en-us/library/ms155365.aspx


Also at the bottom of the page there is a link to the section on modifying the rendering extensions themselves... it's actually fairly easy, all you have to do is make the appropriate changes to the RSReportServer.config xml document on your report server. Just make sure you make a backup first!

-Luke.

To help us help you read this

For better help with performance problems please read this
Rajib Bahar
Rajib Bahar
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 247
Luke, Thanks for the suggestion. I appreciate it. I am preferring something that'd not affect most csv export.

Rajib Bahar
http://www.rajib-bahar.com
http://www.twitter.com/rajib2k5
http://www.youtube.com/icsql
Luke L
Luke L
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33617 Visits: 6226
you can create a new rendering extension by copying the existing csv one and calling it something else. Then you can even hide it so that it can only be used by this one report schedule and not shown to the users. I believe the BOL documentation talks about creating one where the default print orientation is portrait and the other is landscape.

As an example, my users only see the rendering extensions to export to xls and pdf, but ones like the image one are still there because the rsclientprint utility needs it to operate properly.

-Luke.

To help us help you read this

For better help with performance problems please read this
Rajib Bahar
Rajib Bahar
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 247
Thanks Luke. I'll try your suggestion. Have a good Weekend!

Rajib Bahar
http://www.rajib-bahar.com
http://www.twitter.com/rajib2k5
http://www.youtube.com/icsql
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