When i save a report in xlsx from the button "Save Data to file" i get a nice excel with row 1 containing headers and one row for eache result.
When i put the same report in a auto report and with the xlsx format i get a monstruosity with row 1 containing headers, row 2 containing nothing visually, collapsed (vertical size reduced) in excel and a Thirs row also looking empty but counting as a row when manipulating the file.
Why ? Is it possible to get the auto report report files in the same format as when you do the "Save Data to file" ?
this is really annoying.
P.S. I would not care if there was an option to save/send reports only if they have results. an option asked by many and that should not be too hard to implement.
I tried to mimic that by using scripts and auto reports files but now I have trouble finding if a report has data or not because if i have 0 results i get an excel with 3 rows and if I have one result i also get an Excel with 3 rows (and the second row contains the data.)
Please sign in to leave a comment.