Microsoft Access: Help me streamline (or completely automate) creating weekly reports that include tables and charts. I'm almost there, but I just can't wrangle the formatting. Is it me or is it Access?
We keep statistics of our library's reference desk in an Access (2007, 2010) database I put together. It's a small enough DB that I can manage creating queries and reports on the fly as needed. I do, however, send around a weekly report that hits the highlights. Thus far, I've been exporting data to Excel and making tables and charts -- like this
I've been trying to recreate that in the Access database by selecting a date on a form
, and pushing a button that opens a PDF preview of a report that has subforms that open in pivot table and pivot chart views
. But it comes out looking like this
. Serviceable, but I need to:
- understand how reports create blank pages. I've been fiddling with the margins (and googling endlessly) but I can't get the preview to stop making blank pages.
- control column width (and other formatting issues) for the tables.
- show zero value hour/dates on the chart.
But, of course, I might be missing the forest for the trees. Is there another way I can accomplish this? Not only would I like to save myself some time with the weekly reports, but I'd like to make it so that my colleagues can do it themselves. Picking a date, pushing a button, and hitting print is about as sophisticated as it can get.