I have an SSRS 2005 report (DB = SQL 2005), running on SSRS 2008 report server. There are total 6 datasets (and no stored procedures). I have four parameters, out of which one is a date field, one is a text box and the other two are multi value parameters (@PC, @CT). Out of the 6 datasets, 2 serve as providing the available values for the multi select parameters and other 4 feed the data for the report.
Number of available values for @CT = 480 and that of @PC = 987.
When I select all, the report runs fine in BIDS, but no data in report manager.
I updated the queries populating the available values for parameters as
select 'All' union select column from table.
where ( @PC = 'All'
or M.PC IN (@PC)
and ( @CT = 'All'
or M.CT IN (@CT)
In the drop down, if I select 'All' for @CT and any one or two values for @PC, the report runs fine.
If I select 'All' for @PC, the report doesn't return anything (in the report manager).
Interestingly, if I select upto 967 individual values for @PC from the dropdown, the report runs fine. If I select 968 or anything higher than this, then the report doesn't return anything.
I tried using function, split, join (tired pretty much everything that I found in google). Please help and thanks in advance.