No Boolean Values On CSV Export From Grid

[Shawn]

When i do an export of my datagrid to csv my boolean values that are in the grid do not display on the report - they are blank.  In Excel the values show up as capitalized TRUE or FALSE, but in csv nothing.

I am not doing anything different in the export - simply the MyGrid.MasterTableView.ExportToCSV()

How can I fix this?

[Daniel]

Hello Shawn,

Our developers already addressed this issue. Could you please try the latest version - RadControls for ASP.NET AJAX Q2 2009?

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Shawn]

How am I able to fix with older versions of RadGrid?  Isn't there a simply way of putting it into Configure Export function like so:

Protected Sub btn_ExportCSV_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportCSV.Click
        For x = 0 To 29
            'display hidden columns for reporting
            'IF IS Datatype Boolean show true/false???
            MyGrid.MasterTableView.Columns(x).Visible = True
        Next
        MyGrid.MasterTableView.ExportToCSV()
    End Sub

[Daniel]

Hello Shawn,

The easiest way is to insert a hidden bound column that uses the same DataField and then switch the columns when exporting.

For your convenience I attached a demo that illustrates this approach.

Kind regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.