| Author |
 Topic  |
|
|
csrite
3 Posts |
 Posted - 01/05/2012 : 12:47:23
|
| I'm having a problem with exporting data to Excel or CSV. I have a text column in my report with data in the format "1-11" as an example. If the number before the hyphen is something that could be a month, the data is being formatted as a date. If I have the text field "1-11", it exports as "11-Jan". If I have the text field "1-32", it exports as "Jan-32". If I have the text field "13-11", it exports correctly as "13-11". Is there a way I can get all values to export as text? |
|
|
admin
1644 Posts |
|
|
csrite
3 Posts |
Posted - 01/05/2012 : 16:02:48
|
| It isn't supposed to be a date. It's just supposed to be regular text. It shouldn't have any date formatting. |
 |
|
|
admin
1644 Posts |
Posted - 01/05/2012 : 19:54:16
|
| Can you please be more specific? Is this for OLAP or SQL report? Is this for row header of for cell data? |
|
|
|
csrite
3 Posts |
Posted - 01/06/2012 : 08:10:11
|
It is a SQL report, and it is cell data.
Switch PullDate PM_Type MGW_ID TrkQty NumMem
XXXYZ 1/5/2012 20:02 MGW 11-Jan 24 24
XXXYZ 1/5/2012 20:02 MGW Jan-32 24 24
XXXYZ 1/5/2012 20:02 MGW 13-10 24 24
The column in question is MGW_ID. When I run the report through the web interface, the values show correctly as "1-11", "1-32", and "13-10". When I export to Excel, some of the values get changed to dates. |
|
|
|
admin
1644 Posts |
Posted - 01/06/2012 : 22:28:29
|
Thanks.
To get a hot fix for Excel date exporting, please contact support@ReportPortal.com.
There is nothing that can be done about CVS exporting. Excel formats date data for all CSV files automatically. |
|
|
| |
Topic |
|
Report Portal
Export to Excel
