0

I have a report that contains several subreports that are very similar to the main/base report. I want each subreport's data to be housed on a separate tab when the user exports the report as Excel.

I found a similar answer here, but it's not subreport-specific (I don't see a "PageBreak" property on Subreports, so the answer there doesn't seem to help me).

How can I cause the exported Excel file to break into separate sheets on each subreport, and with the name of each subreport on its respective sheet or the text property of the label that I place above each subreport?

Community
  • 1
  • 1
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862

1 Answers1

2

Place the subreport inside of a rectangle control and set the PageBreak options on the rectangle.

Mike D.
  • 4,034
  • 2
  • 26
  • 41
  • Okay, I see a PageBreak property on the Rectangle I plopped, then dropped a subreport on/into; its Disabled subproperty is already set to False, and I set "BreakLocation" to "Start" - the report has been hourglassing for several minutes now, so I'll see what (eventually) happens... – B. Clay Shannon-B. Crow Raven Jun 20 '16 at 15:36
  • How do you name the tabs that the subreports end up in? – Muskie May 28 '20 at 14:21