1. 

   elb98rm, Member

   Hi,

   When exporting to excel, the following format is not being preserved:

   select 'dbr.colstyle', 'Employee ID','%06d';

   As you can guess - it's employee IDs, and they need to be of the above style (6 digit, leading zeros).

   With the ID 1234, you correctly see 001234 in myDBR.
   When you export to excel, you get: 1,234.

   This will cause problems in our other systems.

   Can you let me know if there's a work around or way of specifying this.

   Cheers
   Rick
2. 

   elb98rm, Member

   HA!

   I was just reviewing this and there's a second set of bugs as well, but pertaining to the same process...

   I have the following header level and counts:

   select 'dbr.count', 'Role';
   select 'dbr.hdr', 'Name';
   select 'dbr.hdr', 'Employee ID';
   select 'dbr.summary.options', 'limit_summary_level', '0';

   I am selecting (amongst others):

   concat(e.first_name,' ',e.last_name) as 'Name',
   e.id as 'Employee ID',
   cr.role as 'Role',
   cr.role_id as 'Role ID'
   ...

   In excel the following occurs:

   • Name appears in every row, as opposed to blank name's where there are multiple rows
   • Every name has a count, as opposed to the report, which only has a total count
   
   

   I've only just noticed these items, as the actual report behaves as expected.

   Many thanks.
   Rick
3. 

   myDBR Team, Key Master

   Both of these Excel exports should behave better in latest build.

   --
   myDBR Team
4. 

   elb98rm, Member

   I'll update and report in.
   Cheers
   Rick
5. 

   elb98rm, Member

   Updating worked.

   Great job guys! :)

Reply

You must log in to post.