Copying Reports

[MitziUK]

I have created a report based on a query. The report displays Lorry income
per month, has a parameter asking for registration number of vehicle and also
a parameter for Date on Hire e.g. the parameter for date on hire asks for
dates between such and such a date. The report header displays
=Format$([DATE ON HIRE],"mmmm yyyy",0,0).

I want to replicate this report but the report will be Lorry income per
WEEK.
The parameter for the Registration Number will not be needed as I wish to
show all registrations, BUT I still need the parameter for Date on Hire.
The
report header will therefore need to change.

As lining up reports are very fiddly, is there anyway I can copy the
original report and make my changes easily without creating another
query/report?

 

[Fons Ponsioen]

Hi Mitzi
The way OI replicate reports and than make changes is to simply hi-lite the
desired original report in the reports window, than paste and give the report
a new name and modify the new report as desired.
An other way is to open the original report in design view and than use the
save as menu option to save it under a different name.
Hope this helps.
Fons

 

[MitziUK]

I can copy and paste the report no problem.

The report is based on an underlying query, which I can also copy/paste.
but how then do I change the way the report works based on the pasted query?

Hi Mitzi
The way OI replicate reports and than make changes is to simply hi-lite the
desired original report in the reports window, than paste and give the report
a new name and modify the new report as desired.
An other way is to open the original report in design view and than use the
save as menu option to save it under a different name.
Hope this helps.
Fons

I have created a report based on a query. The report displays Lorry income
per month, has a parameter asking for registration number of vehicle and also
a parameter for Date on Hire e.g. the parameter for date on hire asks for
dates between such and such a date. The report header displays
=Format$([DATE ON HIRE],"mmmm yyyy",0,0).

I want to replicate this report but the report will be Lorry income per
WEEK.
The parameter for the Registration Number will not be needed as I wish to
show all registrations, BUT I still need the parameter for Date on Hire.
The
report header will therefore need to change.

As lining up reports are very fiddly, is there anyway I can copy the
original report and make my changes easily without creating another
query/report?

 

[Fons Ponsioen]

You would also copy the current query to a new query with different name and
use this new query as the source for your new report. I usually incorporate
the query in the report so when I change one report it will not effect other
reports or forms which could potentially be based on the same query.
Hope this helps.
Fons

I can copy and paste the report no problem.

The report is based on an underlying query, which I can also copy/paste.
but how then do I change the way the report works based on the pasted query?

Hi Mitzi
The way OI replicate reports and than make changes is to simply hi-lite the
desired original report in the reports window, than paste and give the report
a new name and modify the new report as desired.
An other way is to open the original report in design view and than use the
save as menu option to save it under a different name.
Hope this helps.
Fons

I have created a report based on a query. The report displays Lorry income
per month, has a parameter asking for registration number of vehicle and also
a parameter for Date on Hire e.g. the parameter for date on hire asks for
dates between such and such a date. The report header displays
=Format$([DATE ON HIRE],"mmmm yyyy",0,0).

I want to replicate this report but the report will be Lorry income per
WEEK.
The parameter for the Registration Number will not be needed as I wish to
show all registrations, BUT I still need the parameter for Date on Hire.
The
report header will therefore need to change.

As lining up reports are very fiddly, is there anyway I can copy the
original report and make my changes easily without creating another
query/report?

 

[MitziUK]

Fons

How do I incorporate the query into the report please? Is it something to
do with the SQL. Where do I paste the SQL code to in the report? I'm using
Access 2003.

Thanks

You would also copy the current query to a new query with different name and
use this new query as the source for your new report. I usually incorporate
the query in the report so when I change one report it will not effect other
reports or forms which could potentially be based on the same query.
Hope this helps.
Fons

I can copy and paste the report no problem.

The report is based on an underlying query, which I can also copy/paste.
but how then do I change the way the report works based on the pasted query?

Hi Mitzi
The way OI replicate reports and than make changes is to simply hi-lite the
desired original report in the reports window, than paste and give the report
a new name and modify the new report as desired.
An other way is to open the original report in design view and than use the
save as menu option to save it under a different name.
Hope this helps.
Fons

:

I have created a report based on a query. The report displays Lorry income
per month, has a parameter asking for registration number of vehicle and also
a parameter for Date on Hire e.g. the parameter for date on hire asks for
dates between such and such a date. The report header displays
=Format$([DATE ON HIRE],"mmmm yyyy",0,0).

I want to replicate this report but the report will be Lorry income per
WEEK.
The parameter for the Registration Number will not be needed as I wish to
show all registrations, BUT I still need the parameter for Date on Hire.
The
report header will therefore need to change.

As lining up reports are very fiddly, is there anyway I can copy the
original report and make my changes easily without creating another
query/report?

 

[Fons Ponsioen]

Open the current queryin design view, on the view menu (left most icon on the
menuy bar) select the SQL view. Select the entire text in the SQL window and
press Ctrl-C (or copy from the edit menu).
Open the report in design view, dbl click the left to gray square with the
black square in the middle. this will open the properties window.
Click on the data tab. Click in the record source field, this will show a
rectangle with three dots to the right of the record source field, click on
the 3-dot-reectagle.
Open the new query window go to the SQL view as described above, press
Ctrl-V (or paste from the edit menu). Now you can edit the SQL if you wish
but I rather change the View menu to the design view nad make any desired
changes to adapt the query for your new report. This will incorporate the
query in the report withou affecting any other form or report which may have
been based on the original query.
It seems involved, but after looking at it you'll see it is quite straight
forward.
Hope this helps.
Fons

Fons

How do I incorporate the query into the report please? Is it something to
do with the SQL. Where do I paste the SQL code to in the report? I'm using
Access 2003.

Thanks

You would also copy the current query to a new query with different name and
use this new query as the source for your new report. I usually incorporate
the query in the report so when I change one report it will not effect other
reports or forms which could potentially be based on the same query.
Hope this helps.
Fons

I can copy and paste the report no problem.

The report is based on an underlying query, which I can also copy/paste.
but how then do I change the way the report works based on the pasted query?

:

Hi Mitzi
The way OI replicate reports and than make changes is to simply hi-lite the
desired original report in the reports window, than paste and give the report
a new name and modify the new report as desired.
An other way is to open the original report in design view and than use the
save as menu option to save it under a different name.
Hope this helps.
Fons

:

I have created a report based on a query. The report displays Lorry income
per month, has a parameter asking for registration number of vehicle and also
a parameter for Date on Hire e.g. the parameter for date on hire asks for
dates between such and such a date. The report header displays
=Format$([DATE ON HIRE],"mmmm yyyy",0,0).

I want to replicate this report but the report will be Lorry income per
WEEK.
The parameter for the Registration Number will not be needed as I wish to
show all registrations, BUT I still need the parameter for Date on Hire.
The
report header will therefore need to change.

As lining up reports are very fiddly, is there anyway I can copy the
original report and make my changes easily without creating another
query/report?