Search code examples
ms-accessreport

MS Access: Keeping grouped report controls on the same page


I have been begrudgingly using Access reports and figured out most of the quirky caveats to the system, but there is one issue I am facing to which I am unsure if there is a remedy.

Basically, I have a report where the question title is displayed above its relevant chart and I would like for the title and chart to remain on the same page, so that when other controls grow the two are forced onto the next page together (otherwise I would just insert a page break). I thought grouping these controls would have the desired effect but alas no luck.

I have attached pictures of the group i wish to keep together in design view, and the print preview of my dreams being shattered when they are not. (These are attached as links below since I am not allowed to embed....)

Any help would be greatly appreciated!

Grouped controls in design view

Failure in print preview


Solution

  • Instead of building all graphs on report, use sub-reports to group items together. Simply, create new report with title/graph, and insert it into your main report. I suggest you do the same with other graphs, and if possible reuse sub-reports. This way is much easier to maintain reports and you can use 'keep together' function.

    Here is example of one of my reports that I automatically export in PDF for each of selected vendors:

    enter image description here

    On print, I keep 4 graphs per page and here is how it looks:

    enter image description here

    Hope this helps.