This is a migrated thread and some comments may be shown as answers.

How to Hide Row Header in CSV Outpuit

1 Answer 943 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Hui
Top achievements
Rank 1
Hui asked on 26 Feb 2019, 01:43 AM

Dear Sir/Madam,

I am trying to hide Row Header in CSV Output, where I have designed the data in Table/Cross tab format, it seems even I have made them invisible, the Row Header still appear in CSV output, it works fine with Excel and PDF.

Is there a way to exclude the Row Header from CSV file?

Kind Regards

Hugo

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 28 Feb 2019, 03:01 PM
Hello Hugo,

The CSV rendering output reports as a flattened representation of a report data in a plain-text format. Importantly, Formatting and layout are ignored. For those reasons, even if you hide the row headers (e.g. with Bindings or Conditional Formatting), they will still be present in the CSV exported document. For more information, you can visit Design Considerations for CSV Rendering. This behavior is by design and cannot be avoided.
The first record in the CSV rendering will contain headers for all the columns in the report (the items' name, not value). You may exclude it by setting 'NoHeader' to True - check CSV Device Information Settings articles.

Regards,
Neli
Progress 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
Aleksandra
Top achievements
Rank 1
commented on 08 Sep 2022, 12:44 PM | edited

hi,
how is it possible to make NoHeader -> True OR NoStaticText -> true for Telerik Report Designer Q1 2015
what I'm trying to do is I want to hide groupHeaderSection from exporting in CSV format.i want to show only detail 

Neli
Telerik team
commented on 13 Sep 2022, 12:11 PM

Hi Aleksandra,

If I understood correctly, you would like to hide the group header sections when you export to CSV. If so, you can set the ConditionalFormatting property of the headers as follows:

 

Aleksandra
Top achievements
Rank 1
commented on 13 Sep 2022, 12:22 PM | edited

An error has occurred while processing GroupSection 'groupHeaderSection': The expression contains object 'RenderingFormat' that is not defined in the current context.

IT SHOWS ME THIS.
Neli
Telerik team
commented on 14 Sep 2022, 11:13 AM

Hi Aleksandra,

Can you please send me the problematic report, so I can inspect it on my end?

Tags
Report Designer (standalone)
Asked by
Hui
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or