I have an existing report the allows 3 parameters.
Start Date, End Date and Customer. Start Date and End Date are required.
I need to add the opion of searching by the Invoice Number field only.
Invoice Number field. is a varchar (20).
When I added the invoice number paramter and set the start date to allow null value or blank values data does not get returned.
I know there is a data for a specific invoice #, but when I placed this as the paramter no data gets returned. When I place this value plus a start and end date I get a record bank.
I declared my invoice parameter as a string.