Is it possible to suppres an individual record on a report?

  • Thread starter Thread starter Jasonm
  • Start date Start date
J

Jasonm

Hi...

I would like to know if it is possible to suppress an individual record on a
report based upon wheter or not a corosponding record exists in a subreport,
OR if a calculated value from the sub report is greater than another value.

I have gotten so far as to make the controls NOT visible when either
condition is met, but this only gives me a bunch of white space on my
report. What I would really like is to simply ignore these records.

Is this possible?

Thanks in advance for any assistance that you can offer.

Jason M Canady
 
Hi Jason

The trick is to base the report on a query, and eliminate the undesireable
records there before it ever gets to the report.

To eliminate records that have no match in the subreport, you could use a
subquery in the WHERE clause of your main report's query.

This example assumes the main query is based on the tblClient table, and you
want to eliminate anyone who has no orders:
WHERE NOT EXISTS (Select OrderID FROM tblOrder WHERE tblOrder.ClientID =
tblClient.ClientID)

If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066
 
Back
Top