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

Hide rows from exported table which have flag NoMasterRecords or NoDetailRecordsText

3 Answers 56 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Vasssek
Top achievements
Rank 1
Vasssek asked on 05 Jul 2012, 12:47 PM
Hello,

Could somebody help me to solve my issue ? I've exported data from hierarched grid to Excel. Export is done properly, but in the result .xls file there are some rows which have text No child records to display. These rows I don't want to include in the export...

RadGrid export declaration is:
<ExportSettings Excel-Format="Html" ExportOnlyData="true" IgnorePaging="true"
                OpenInNewWindow="true">
            </ExportSettings>

I've tried to hide them in server code methods, e.g. RadGrid1_ItemCreated or RadGrid1_ExportCellFormatting, empty row text is still there :(.

Please help me to solve my issue.

For further information, please check the attachment.
The question is, how to remove rows 9 and 22 from exported xls...

Best regards

Vasssek

3 Answers, 1 is accepted

Sort by
0
Milena
Telerik team
answered on 10 Jul 2012, 03:02 PM
Hello,

Please find the attached project, where it is demonstrated how the desired functionality could be achieved.

Greetings,
Milena
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Vasssek
Top achievements
Rank 1
answered on 11 Jul 2012, 06:04 AM
Hello,

I've tried your example, but it doesn't work as expected.

1. Even though radgrid has declared ExportOnlyData = "true" it exports whole controls (buttons, images), not just data.
2. I've added into radgrid declaration AllowFilteringByColumn = "true" because of getting text No child records to display. After applying filter, there are still all rows in the exported xls file instead of just filtered rows.

Please help me to solve this issue...

Thank you.

P.S. My dll version is 2012.1.411.40

Vasssek
0
Accepted
Milena
Telerik team
answered on 13 Jul 2012, 12:10 PM
Hello,

I would suggest you to continue this discussion in the opened support ticket, where you are facing the same issue.

Greetings,
Milena
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Vasssek
Top achievements
Rank 1
Answers by
Milena
Telerik team
Vasssek
Top achievements
Rank 1
Share this question
or