When I am generating report from UI it is showing up blank rows and data rows but when I export report in xls it only shows up rows with data. Is there a way to eliminate blank rows from report on UI.
Are you able to provide the query that is being used please?
Just thinking that Excel may be simply ignoring empty rows.
Retrieving data ...