February 28, 2014 at 8:01 am
I have a report that has a multi-value queried parameter. The query for the parameter is pretty straight forward:
select ORGCODE
from orgcodes
where active=1
and strength=1
and isnumeric(left(orgcode,1)) = 1
order by orgcode
When I run this query in SSMS, it returns 52 4-character codes which is correct. When in BIDS I run the query for that dataset on the data tab I also get 52 4-character codes. However, when I run (or preview) my report I only get 46 4-character codes plus the select all option in my parameter drop down box. The parameter is set up as a string, multi-value, from query (query above) with a null default value.
Is there a limitation on the number of parameter items in the report drop down? Is there a way to get around this?
Thanks in advance.
February 28, 2014 at 1:35 pm
I don't know what the issue was, but I just created a brand new report that looks like the original one with the exact same parameters and queries and this time it works. I can't see anything that is different.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply