1. 

   cayasanchez, Member

   I need to remove all the percentages and currency symbols when exporting my report to CSV. So I export only numbers.
   I didn't find how to do it in the export options.

   I tested the option

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

   But didn't work.

   My report has several resultsets, If I export to excel I want each resulset in a different sheet. How can I do that?

   Please let me know how to export only data without any formatting and how to split the resultsets in different sheets when exporting to excel

   Thanks!
2. 

   myDBR Team, Key Master

   Use

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

   We'll improve the documentation on this.

   --
   myDBR Team
3. 

   cayasanchez, Member

   How to split the resultsets in different sheets when exporting to Excel?
   My report has a daily, weekly, monthly and yearly resultsets. I want each one in different tabs/sheets
4. 

   myDBR Team, Key Master

   Use the worksheet export option.

   select 'dbr.export.options', 'worksheet', 'First sheet';
   
   select data_sheet_1...
   
   select 'dbr.export.options', 'worksheet', 'Second sheet';
   
   select data_sheet_2...

   --
   myDBR Team

Reply

You must log in to post.