Hide DetailItemTemplate on Export

[Glenn]

I am trying to find a solution to exclude the DetailItemTemplate from export to Excel and Word. 



I have tried the following code in the export onclick event and whilst debugging shows that whilst it does change visible to false for each item, the detail still appears in Excel and Word:

For Each item As GridDataItem In RadGrid1.MasterTableView.Items

item.DetailTemplateItemDataCell.Visible = False

Next

Me.RadGrid1.MasterTableView.ExportToExcel()

(Note by default without any additional code Export to CSV or PDF appears to be excluding the DetailItemTemplate)

 

Any idea?



Thanks



Glenn

[Glenn]

Never mind, it just started working. Not sure why.