Running report if parameter is left empty

  • Thread starter Thread starter tracy
  • Start date Start date
T

tracy

I have a report that pulls invoice information. I would
like to have my users run it either by the customer name
or a date range. I have the date range parameter set up,
running fine. I can add the other parameter for the
customer, but if I don't know the customer and just want
to run it for the date range, I bring back no data. How do
I tell it that if either parameter is null, to run with
what it has?

Thanks in advance.
Tracy
 
Hi Tracy,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

I believe the following Knowledge Base article contains the information you
are looking for:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209645

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top