troubleshooting Question

Specify One or All records in Dropdown

Avatar of BobRosas
BobRosas asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008SSRS
5 Comments1 Solution487 ViewsLast Modified:
I want to either select “Null” from the dropdown for all Supervisor records or select a specific Supervisor from the dropdown.  If I fill in Supervisor it works but if I leave it null I get nothing…instead of all records.  What do I need to change so that one of the dropdown options allows the user to select all Supervisors?

My dataset code is...
SELECT        SupervisorID, Supervisor
FROM            vw_HrLkUpSupervisor
WHERE        (SupervisorID IN (@Supervisor)) OR
                         (@Supervisor IS NULL)
ORDER BY Supervisor

My Supervisor parameter code is...
SELECT DISTINCT SupervisorID, Supervisor
FROM            vw_HrLkUpSupervisor
UNION
SELECT        ' ALL' AS Supervisor, NULL AS SupervisorID
ORDER BY Supervisor

Sample data is…
NULL
ATKL3456
SOFT8765
BNAB9123

I have tried setting the Manager parameter to "Allow null value" and “Allow blank value”.
I have value field as SupervisorID and label as Supervisor.
ASKER CERTIFIED SOLUTION
BigSchmuh

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
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 5 Comments.
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