Report Problem

  • Thread starter Thread starter BNK
  • Start date Start date
B

BNK

Hi,

I have several reports that print sales records for each sales person.
If I need to create or make changes to a report I copy the basic
layout from an existing report. My problem is that whatever
information I put into the new report is copied to the existing
report, even if it is closed.

Does anyone know if this happens because the database might be
corrupt, or is there a switch to fix this problem.

Thanks

Barry
 
Hi. I suspect what you are refering to is that the query specification. If
so, rather than use a distinct query for the data source for your report
incorporate the query in the report by copying the SQL from the distinct
query to the data source of your report. Now you can modify the query for
each report as desired, this still allows you to use the same basic layout of
the report and modify each as desired.
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 to be Lorry income per week.
take out the parameter for the Registration Number, therefore having all
registrations displayed BUT still have the parameter on 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 to easily?
 
Back
Top