1. 

   ziuras, Member

   Hi
   Today I updated to 5.7.5 (build 4062) old was 5.7.4 maybe.

   Report export in xlsx format
   now there are not "select 'dbr.title', 'aaaa'" in first row.
   befor update i have title in first row and first column: (in xlsx file)
   ------------------------------
   Client: 123456 — Name Surname
   A B C
   abc abc 10
   acb acb 11
   ------------------------------
   select 'dbr.title', 'Client:' + @inKs
   select A, B, C from ...

   now I have only:
   ------------------------------
   A B C
   abc abc 10
   acb acb 11
   -----------------------------
   how to add title in first row?
2. 

   myDBR Team, Key Master

   Hi,
   just run the automatic updater and the title will be back.

   --
   myDBR Team
3. 

   ziuras, Member

   hi,
   now we get one extra emty line
   1 line: Client: 123456 — Name Surname
   2 line: emty
   3 line: A B C
   if you can, remove 2 empty line

   Thanks
4. 

   myDBR Team, Key Master

   Hi,
   The title is, by default, separated from the first result set with one empty line. There is no empty lines between subtitles and the result set.

   if you run the updater again, you can use setting in user/defaults.php:

   $mydbr_defaults['export']['excel']['lines_after_title'] = 0;

   This will remove the line between the title and the first result set.

   --
   myDBR Team
5. 

   ziuras, Member

   thanks, its working.

Reply

You must log in to post.