I have a Crystal report that is a main report with a subreport. I push all the main report data to the subreport, so that when we export the data, it all exports on one line (rather than one line for main report data and another line for sub report data).
The sub report has two details section. Section A prints if the item is Finished goods and section B prints if the item is a Kit. There are conditional suppression statements if any of the sections are blank, plus another conditional statement on the section of the main report to not print if the sections are blank. All the other sections are suppressed. The report looks great.
The issue is that when I export to Excel (I'm using Visual Cut, but don't think that is relevant), I get data all in one row (yeah!), then two blank rows, data, two blank rows, etc.
Does anyone know how to get this exported to Excel without the blank rows? I need a report/subreport layout because of the calculations of F vs. K items and their obvious link (or lack thereof) to BOM. The report just won't run when I tried this in one main report. (I tried moving the subreport info to the main report using Shared VARs, but I couldn't get the information to come over properly.)
Thanks,
Roberta