1. 

   cayasanchez, Member

   I have a report where all values are numbers, when exporting to CSV I use the statement:

   select 'dbr.export.options', 'csv.skip_formatting', 1;

   Some values are exported as numbers and others as text.
   I'm using the latest MyDBR version myDBR 7.1.0 (build 5232).
   Is there anything I can do so all the data is exported as numbers instead of text?

   Thanks in advance.
2. 

   myDBR Team, Key Master

   Where do you see the numbers shown as text?

   Can you open up a support ticket with example data as a SQL export if your report.

   —
   myDBR Team
3. 

   cayasanchez, Member

   I see the numbers as text when opening the CSV file in Excel
4. 

   myDBR Team, Key Master

   It could be just Excel interpreting the CSV file.

   Please open a support ticket with example data as a SQL export of your report.

   —
   myDBR Team

Reply

You must log in to post.