Skip to Content
0
Sep 17, 2020 at 06:55 PM

How I make a subreport export (excel) in the same line as the main report?

245 Views

I have a report that requires a subreport. I was hoping to export all data into an excel report. However, crystal puts all data in a subreport on the next row after the data from the main report. I was told a way around this was to use shared variables. That works but the subreport still exists on the main report and will still put the data on the next line, whereas the data I want is on the right line. But now if I want to use that exel report I have to delete every other line. Is there a better way to do this?

What I want:

Joe Smith 45 16 8 9 10 15

Ann Doe 50 20 3 8 10 12

The best I can get it:

Joe Smith 45 16 8 9 10 15

16 8 9 10 15

Ann Doe 50 20 3 8 10 12

20 3 8 10 12