none
Remove Textbox names from CSV export RRS feed

  • Question

  • Export only data regions, table1_Details_Group, or DataSet fields to CSV

    Hi Team,
    I am trying to export ONLY table1_Details_Group, or data fields, or DataSet fields to CSV or Excel.  I need to strip report header, column headers, and report footers.  We need headers and footers in PDF and Word.  However, our end users need to import many of these reports into third party systems.  I have found that I can set DataElementOutPut to NoOutput, however, the CSV files still contains the text box names of the data rows.  Why does it export the text box name and the data?  How do I supress that?

    Example:
    Textbox1, Textbox2, Textbox3
    Andy,Adams,Analyst
    Bobby,Wilson,Programmer
    AnotherName,AnotherLastName,Manager


    I have read about creating new rendering extensions but I'm not sure if this is the right answer, and if it is, what strategy should I use to implement the solution.  I thought about streaming the XML and stripping headers or rendering to Excel and doing the same thing.

    I have also thought of exploring capturing the DataSet fields or returned dataset from the stored procedure.  But I haven't looked in to that yet.

    What I want to avoid is writing custom code for each of the 160+ reports.

    Any ideas?  Is there an easy way to strip headers and footers from CSV?

    Thanks!


    • Edited by BClaydon Friday, March 8, 2013 12:55 AM
    Friday, March 8, 2013 12:23 AM