SSRS IN statement size trouble passing parm to query
I have a report which uses an IN statement to generate the groups(Parms)in a SSRS module, Problem is that in VS i can run the report on a population size i know to be around 2500. But when i deploy to a 2008 R2 report server it will not run. stops dead. but if i adjust the parm to bring in a smaller population or select one or two members to report on it will run.
I think this an issue with the size of the IN statement passed to the query and I am trying to find a way around or a different way of using parm as I have had a lot of issues with the "read ahead" and setting the groups in this report as it does call 2 subreports.