Wednesday, March 7, 2012

parameters filters

Hi,
I have created a simple report that uses the parameter customer_code as
selection criteria. When users use the report they can only select one
customer code at a time. How can I change this to accept an asterisk for a
range of customers? Is Reporting services able to do this?
xp_aol@.discussions.com> I have created a simple report that uses the parameter customer_code as
> selection criteria. When users use the report they can only select one
> customer code at a time. How can I change this to accept an asterisk for a
> range of customers? Is Reporting services able to do this?
Here is an example how to use IN operator with list of values as a
parameter:
http://solidqualitylearning.com/blogs/dejan/archive/2004/10/22/200.aspx.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

No comments:

Post a Comment