have report developed in SSRS 2008. Report is deployed to sharepoint 2010 in dashboard. Report has parameters and have been supplied. Report runs fine locally in my computer. But when we try to run the report in sharepoint by clicking the apply button , it does not run. To test if something was wrong with connection string, I have downloaded the rdl file to my computer and tried running in my computer. Reports runs fine. I am not sure what could be the reason for report not running. It used to run earlier in sharepoint. Could anyone help me in resolving the issue.
I have observed that when all the values in parameter are selected (Select All) report does not run and when some of values in parameters are selected report runs fine in sharepoint. I see the processing symbol fraction of seconds and disappearing when all values in parameters are selected. It does not show any error message when report is not being displayed.
Below is the screenshot of the report from report builder and in sharepoint site.