Thursday, June 18, 2009

Tab Delimited Renderer in SSRS 2005

I was recently tasked with coming up with a tab delimited renderer in SSRS 2005.

My first thought was to use the CSV renderer and add a config entry in the ReportServer.config file to use a tab as a field delimiter.
However, in SSRS 2005, Microsoft clears any whitespace when reading the config file for the CSV renderer, meaning that the tab character does not work.

So I set about researching how to create a tab renderer.

The first article I read stated that you would have to visit Redmond, WA and sit with an SSRS developer to even think about developing a rendering extension. I didn't buy this and kept searching.

There isn't a lot out there on rendering extensions, but I did find several references to the following assemblies:

Microsoft.ReportingServices.Interfaces
Microsoft.ReportingServices.ReportRendering


So with that, I started to develop a prototype solution to the tab rendering problem.

My first decision was to only render tables and matrices. The SSRS CSV renderer tries to render textboxes, which only leads to malformed CSV files. And since most of the time the tab delimited export is going to be loaded into Excel, I decided to just focus on the table and the matrix control.

More to come in the next post...

4 comments:

Jegan said...

Did you manage to do a custom renderer?

Post any updates

Thanks.

Bob Pearson said...

I did create a custom renderer, but have not had time to post. I will try to get to this in the next few days.

Anonymous said...

I would love to see your solution as well.

Anonymous said...

A custom renderer in this case is no longer necessary... you can specify the delimiter (including tabs). See
http://blogs.msdn.com/b/robertbruckner/archive/2009/01/20/take-another-look-at-csv-rendering-in-rs-2008.aspx