Datakat
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......
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......
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect!! Thanks.
mlmcc