Report format - Access 07

[Bob76]

I would like to copy the exact format of a report that I had created earlier
but with a different set of data (another query as data source). How do I do
this? This would save me a lot of time involved in formatting the columns,
rows, fonts, colors, etc. once again. Please advise.

Thanks, Bob

 

[Allen Browne]

1. While the report is NOT open, select it in the Navigation Pane, copy
(Ctrl+C), and paste (Ctrl+V.) Access will ask what name to give the new
copy.

2. Open the new report in design view, and set its RecordSource property.
That's the first property on the Data tab of the Properties sheet, when
looking at the properties of the report (not those of a text box.)

There may be a way to filter the report without having to duplicate it and
create lots of queries. Here's an example where you can filter the report to
a specific date range:
http://allenbrowne.com/casu-08.html

 

[DStegon]

Just copy the report and give it a new name. Then open the report in Design
and bring up the report properties. You can then change the Record Source to
whatever new set of data you want (table, query, sql statement, etc.). Then
go to the report and if the fields of the new record source is different,
bring up the properties of each data field on the report and change it the
new data field.

Capeesh?
Drew

 

[Bob76]

Allen,
I did it!!! Thanks so much... You've helped me quite a few times already.
I have another question (tho' this might be an irrelevant and silly
question). Is there a way of having the Report Header print on top of every
page of a report (top of the page header)? If not, that's okay...
I did check a lot of Access books and often times can't find the solution to
some basic database problems... This Discussion Group is a Godsend..
Appreciate your help..

Bob

 

[Allen Browne]

Allen,
I did it!!! Thanks so much... You've helped me quite a few times already.
I have another question (tho' this might be an irrelevant and silly
question). Is there a way of having the Report Header print on top of
every
page of a report (top of the page header)?

Try using the Page Header instead of the Report Header.