Copying report, but report still wants to use original query

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

Greetings!
Here is my dilema:
I made a query called "Class A Roster". I created a
report from that query showing all students in Class A. I
make font and alignment changes to the report and it
works. Good so far.

I create another query called "Class B Roster". Now,
instead of creating a new report from scratch and having
to readjust all of the fonts, alignment, etc. again, I
thought, "I'll just copy the first report, change the
source query and save the new report as 'Class B Roster'."

OK, I did that, but for some reason, the report is still
asking me for data from the "Class A Roster" query. Even
after I have looked at every field in my new report and
told it to refer to the 2nd query, for some reason,
something hidden must be tied to the first query. I have
changed the report properties as well as all of the
relevant field properties to point to "Class B Roster"
query, so why is it asking me to "enter parameter data"
when I try to run the Class B Roster report...? It is
asking me to enter parameters from the first query, when I
want it to look at the 2nd query only.

I don't get it. Where is it that I have not changed from
query 1 to query 2? What am I missing that needs to be
changed? Again, I changed all fields and the report
properties, so why does it still want to look at the first
query?

Thanks in advance,
Christine --
 
Christine said:
Greetings!
Here is my dilema:
I made a query called "Class A Roster". I created a
report from that query showing all students in Class A. I
make font and alignment changes to the report and it
works. Good so far.

I create another query called "Class B Roster". Now,
instead of creating a new report from scratch and having
to readjust all of the fonts, alignment, etc. again, I
thought, "I'll just copy the first report, change the
source query and save the new report as 'Class B Roster'."

OK, I did that, but for some reason, the report is still
asking me for data from the "Class A Roster" query. Even
after I have looked at every field in my new report and
told it to refer to the 2nd query, for some reason,
something hidden must be tied to the first query. I have
changed the report properties as well as all of the
relevant field properties to point to "Class B Roster"
query, so why is it asking me to "enter parameter data"
when I try to run the Class B Roster report...? It is
asking me to enter parameters from the first query, when I
want it to look at the 2nd query only.

I don't get it. Where is it that I have not changed from
query 1 to query 2? What am I missing that needs to be
changed? Again, I changed all fields and the report
properties, so why does it still want to look at the first
query?
Click to expand...

Did you change the RecordSource property of the Report? If the field names
are the same that should have been the ONLY property that needed to be
changed.

As a side issue, there should be no reason to even have two reports. Do
you have Class A and Class B in the same table? They should be. Then the
report can just use the table and you can apply a filter when opening it to
determine which class to include (or none if you want both).
 
-----Original Message-----
Greetings!
Here is my dilema:
I made a query called "Class A Roster". I created a
report from that query showing all students in Class A. I
make font and alignment changes to the report and it
works. Good so far.

I create another query called "Class B Roster". Now,
instead of creating a new report from scratch and having
to readjust all of the fonts, alignment, etc. again, I
thought, "I'll just copy the first report, change the
source query and save the new report as 'Class B Roster'."

OK, I did that, but for some reason, the report is still
asking me for data from the "Class A Roster" query. Even
after I have looked at every field in my new report and
told it to refer to the 2nd query, for some reason,
something hidden must be tied to the first query. I have
changed the report properties as well as all of the
relevant field properties to point to "Class B Roster"
query, so why is it asking me to "enter parameter data"
when I try to run the Class B Roster report...? It is
asking me to enter parameters from the first query, when I
want it to look at the 2nd query only.

I don't get it. Where is it that I have not changed from
query 1 to query 2? What am I missing that needs to be
changed? Again, I changed all fields and the report
properties, so why does it still want to look at the first
query?

Thanks in advance,
Christine --


.
Click to expand...
 
Have you checked in sorting and grouping? That is not the most obvious place
to look.
 
Back
Top