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

No Boolean Values On CSV Export From Grid

3 Answers 26 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Shawn
Top achievements
Rank 1
Shawn asked on 09 Jul 2009, 01:56 PM
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?

3 Answers, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 09 Jul 2009, 02:28 PM
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.
0
Shawn
Top achievements
Rank 1
answered on 09 Jul 2009, 03:50 PM
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 ObjectByVal 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 

0
Daniel
Telerik team
answered on 09 Jul 2009, 07:06 PM
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.
Tags
Grid
Asked by
Shawn
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Shawn
Top achievements
Rank 1
Share this question
or