Link to home
Start Free TrialLog in
Avatar of Datakat
DatakatFlag for United States of America

asked on

Printing out report parameters with no record selection match.

I have a report parameter that accepts multiple, user entered items.  User would like to see a list of any entered parameter values that do NOT get a record from the database table.  This is a char field in the database.

It's a quick query, so I could use a subreport. The report outputs as a crosstab with store #'s for rows and items for column and is exported to Excel.  The list of not found items could go in report footer or header or somewhere......
Avatar of Mike McCracken
Mike McCracken

Which database field does the parameter refer to?

mlmcc
Avatar of Datakat

ASKER

The report selects UPC by Store and sum of number sold for user entered date range. The parameter refers to UPC#. The user wants a list of any UPC they entered that has no counts sold. Obviously those will not have any records selected.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Datakat

ASKER

Perfect!! Thanks.