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......
Crystal Reports
Last Comment
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect!! Thanks.
mlmcc