CSV Export Question

Thread is closed for posting
2 posts, 0 answers
  1. David
    David avatar
    19 posts
    Member since:
    Feb 2013

    Posted 17 Dec 2015 Link to this post

    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

  2. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 22 Dec 2015 Link to this post

    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:
    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
Back to Top