Blank rows when exported to Excel from Crystal Report with Sub Report

alucor-it 0
Viewed 21

we have a Crystal report with Suv-report. When we tried exporting it to Excel, it creates a blank row above and below each row with data that comes from the sub-report. how to resolve this? Main Report

enter image description here

Sub Report - TranDetails

enter image description here

I've tried the below:

  1. Suppressing empty sections
  2. Suppress blank sub-report
  3. Resizing the fiels
  4. Aligning fields.

Is there any other way to resolve this?

subreport crystal-reports excel
1 Answers

According to this blog by Ken Hamady, "The only method I found that worked was to use the regular Excel Export instead of “Data Only”. But you have to line up the subreport (as well as the objects within the subreport) so that they are in line with the main report objects. Line them up carefully and they will export to excel with subreport objects aligned correctly."

As an alternative, at least one of the 3rd-party Crystal Reports automation tools listed here automatically removes blank rows from Excel exports.

MilletSoftware0
Related