Rogero
asked on
SSRS - Blank parameter
Hi there,
I have a parameter in a report @postcode. What I would like is for the report user to enter the first x characters of the postcode and the report use that entery to filter results. I have that working no problem with
j.postcode like @PostCode + '%' in the stored procedure
What I would like is the option for the report user to leave this parameter option blank, and the report return ALL values. Any help is appreciated,
Rog
I have a parameter in a report @postcode. What I would like is for the report user to enter the first x characters of the postcode and the report use that entery to filter results. I have that working no problem with
j.postcode like @PostCode + '%' in the stored procedure
What I would like is the option for the report user to leave this parameter option blank, and the report return ALL values. Any help is appreciated,
Rog
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
'Allow Blank Value' option will work with SP above
ASKER
That's great, thanks!