My Thoughts & Views

Export Limitations in SSRS

Posted on: January 28, 2010

Problem :

In SSRS, when you export the report in CSV format, you will not get values. (Export Limitations in SSRS)

Solution :

The data renderers, CSV and XML, only show data and not any layout, means it display non-static data.

Data renderers don’t render static data by Default, they only render expressions.
So either change the table to render real data coming from data base or expressions, or change data output option for table cells (only cells which contain dynamic data, not the headers) from “Auto” to “Yes”.

Or
you can control the export behavior on a textbox-by-textbox basis with the DataElementOutput property.You have 3 options to select, Auto (default), Yes, No.

Right click on Report in Visual Studio solution explorer, select view code & then

add <DataElementOutput>Output</DataElementOutput>

After the name of the text boxes which will be filled by dynamic data.

Hope this helps, Let me know if you find any difficulty.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: