Reports

L

Larry G.

Is there anyway to save a report as a template. I have 12 months and need to
create a report for each month, but every time I create the report I have to
go in and set the report up so that it all fits and looks good. So can I do
taht once and repopulate the report?
 
R

Rick B

Why not make one report that is dynamic? Ask the user which month they'd
like and limit the data to that month? You'd have to give us more details
if you want specific help on how to do this with your data.

We'd need to know what the data source is and what type of data you
display. Along with the layout, sorting, grouping, etc.

Rick B
 
L

Larry G.

The way the data is set up is like this:

There are 12 monthly tables, each table has data from 17 sites, each site
has 9 pieces of information, so there are 12 tables with 17 rows, and 9
columns. I want to print a report for each month based on the information in
each table, so basically what I want to do is rather than go through and set
each month's report up, I want to make one "master" template for the report,
and then have each month populate into it. I know it sounds complicated, but
I am just looking for a time saver.

I had thought about just making one table and then adding another column of
"Month" to it, but then I would not be able to make separate forms for each
month, which was what the user wanted in the first place. I am taking the
information from an Excel spreadsheet.
 
F

fredg

The way the data is set up is like this:

There are 12 monthly tables, each table has data from 17 sites, each site
has 9 pieces of information, so there are 12 tables with 17 rows, and 9
columns. I want to print a report for each month based on the information in
each table, so basically what I want to do is rather than go through and set
each month's report up, I want to make one "master" template for the report,
and then have each month populate into it. I know it sounds complicated, but
I am just looking for a time saver.

I had thought about just making one table and then adding another column of
"Month" to it, but then I would not be able to make separate forms for each
month, which was what the user wanted in the first place. I am taking the
information from an Excel spreadsheet.
Click to expand...

Regarding: >I am taking the information from an Excel spreadsheet.<

If you are making this database for someone else, you are digging a
hole for yourself and may never get out.

You're creating a database using Access. Use Access as it was
intentioned. One main table (and related tables with site information,
etc.) and one report is all you really need.
Do it the right way and you'll be done.

If the user wishes to retain the spreadsheet method of handling the
data, he should retain the spreadsheet.
 
Top