Number of Multi Value Parameter Values RRS feed

  • Question

  • I have a report with 2 date parameters and 5 multi value parameters.  The number of available values are (39,533,614,19 and 37) about 1240 when all the multi value Parameters are combined.  If I choose just one or two values on the first parameter and then select all on the other parameters and click the view report button, the report starts but stops and is in the state of just before the view report button is pressed.  Clicking the button again has the same results.  If I change one of the other parameters to just one or two values the report runs and completes.  It appears that there is a limit on how many total parameter values the report will accept.  When I run the report in Visual Studio it works correctly.  I am using 2008 R2.  Any ideas?
    Wednesday, June 27, 2012 7:50 PM


All replies