Help!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a subreport. The report's source object is a query.
When I open the query, the correct data is displayed. When I run the report,
it displays data that is not in the report. The query filters some of the
data so not every record is displayed. I thought if I had the accurate
information in the query and then used that as a source object for the
report, it would limit the records that the report would display....What do I
need to do to do this??? I only want the records that are in the query....

Thanks for any info!!
 
If a report is based on a query, it should always/only/forever display the
records from the query unless you have code or something in the report that
cancels or hides sections/records.

What's up with the subreport? Are you seeing records from the subreport that
are causing confusion? Are you seeing duplication of records?
 
I checked the code and it had some extra information in it. Now, the report
only shows the records in the query....

I am getting duplicates of reports when a customer has systems that are
service in A and an S....Is there a way to get rid of the duplicate?? They
are not identical because the Service requirement can have an A or an S. The
report groups correctly. I just get two exact reports if they have both an A
and an S listed under one customer.
 
I forget that I need to be more specific--I apologize!!

A stands for annual and S stands for summer, which is the criteria for the
Service field. I have queries that sort the data according to whether they
have an A or S or W. Service in the summer will have all records that have
either an A or an S in the Service. Service in the winter will have all
records that have either an A or a W. The query pulls the right data and
correct records are displayed on the report. However, if a customer has a
system that has an A and a system that has an S in the Service Field, it will
group them correctly however I get 2 reports that display both systems. I
only need one report showing the 2 systems.
 
I don't understand. If you have the same information displaying in two
different reports then set the criteria in one of the reports to not show
some of the records.
 
Back
Top