In a report I am making use of a couple of subreports. all these subreports are placed in group header 1. Values from these subreports are placed in group footer 1.
If I export my report to Excel (Data only), it is creating 8 blank lines between the footers. I am looking for a way to suppress these blank lines. Suppressing or hide the group header is not an option because then the subreport values in the group footer are set to 0.
Does anyone know a way to automatically suppress these blank lines?