CSV Export Question

[David]

Hello,

 I have a few simple reports and have a question about the CSV export format.

I have attached a screenshot of the report. Exporting to Excel looks great, but when I export a CSV I get this text:

Telerik Reporting v9.2 trial version. Copyright Telerik AD © 2006-2015.
To remove this message, please obtain a commercial version from http://www.telerik.com
textBox1,textBox6,textBox3,textBox4,textBox13,textBox8,textBox5
Quality Double Blind Report,Date,Field Count,Error Count,Wednesday 12/16/2015,1000,20        
Quality Double Blind Report,Date,Field Count,Error Count,Thursday 12/03/2015,100,10        
Quality Double Blind Report,Date,Field Count,Error Count,Tuesday 12/01/2015,25,1         
Telerik Reporting v9.2 trial version. Copyright Telerik AD © 2006-2015.
To remove this message, please obtain a commercial version from http://www.telerik.com

As you can see it is is exporting the textbox names for headers and the header values on each row.

Is this a bug, or am I doing something wrong?

Thanks,

David

[Stef]

Hello David,

The CSV rendering extension can be configured to remove the static text and other from the result CSV file.
For the purpose the application's configuration file must have a registered Telerik.Reporting section and device settings for the corresponding extension:

• Telerik Reporting Configuration Section
• Extensions Element
• Device Information Settings

In the case of Telerik Report Server, the settings must be manually applied in the server application's config file (Telerik/ReportServer/Telerik.ReportServer.Web/web.config) and the Scheduler service's configuration file (Services>Telerik.ReportServer.ServiceAgent.exe.config).
After adding the settings, you will need to restart the Scheduler service and the Report Server application.

<configSections>
        <section
                name="Telerik.Reporting"
                type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting, Version=9.2.15.1106, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"
                allowLocation="true"
                allowDefinition="Everywhere"/>
....
    </configSections>
<Telerik.Reporting>
        <Extensions>
            <Render>
                <Extension name="PDF" description="PDF Description">
                    <Parameters>
                        <Parameter name="DocumentAuthor" value="John Doe"/>
                    </Parameters>
                </Extension>
                <Extension name="CSV" description="CSV Description">
                    <Parameters>
                        <Parameter name="NoStaticText" value="true"/>
                    </Parameters>
                </Extension>
            </Render>
        </Extensions>
    </Telerik.Reporting>

Please note that the CSV rendering does not work with the report's data, but aims to describe what data is presented by each item and the structure of the report e.g., group information is repeated for each detail record. For more details please check Design Considerations for CSV Rendering.


Let us know if you have any further questions.

Regards,
Stef
Telerik