troubleshooting Question

Add parameter

Avatar of Sue Taylor
Sue TaylorFlag for United States of America asked on
SQLMicrosoft Visual Studio
1 Comment1 Solution104 ViewsLast Modified:
Newbie here!  

I am trying to modify an existing report  to allow the user to enter multiple user id's to a report.  Currently, the report will allow you to filter by one user id, but I need to have it filter by more than 1.  I changed the parameter to 'allow multiple values'.  I then changed the query to IN(@parameter) instead of =@parameter. Now when I attempt to run the report I get "The report parameter has a defaultvalue or a validvalue that that depends on the report parameter.  I changed the order of the parameters and still get this error.  My report consists of open Purchase Orders.  It originally was set up to enter in a buyer id.  After that was established then it would allow you to select what supplier id(s) you wanted to filter by.  I am doing all of the editing in Visual Studio 2012, then it gets deployed and ran on Report Manager.
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros