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!
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:
On print, I keep 4 graphs per page and here is how it looks:
Hope this helps.