InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:31:05 GMT20http://www.sqlservercentral.com/Forums/Topic717347-150-1.aspxHi,Did you find the solution for this problem I'm having it also?Thanks,JMon, 13 Jun 2011 01:50:53 GMTjames.gallagher 60249http://www.sqlservercentral.com/Forums/Topic717347-150-1.aspxThanks for the reply.To your point if it executes all the dataset then it should give me the results but to get the result I need to click on ViewReport. Why that is the case if it executes all the dataset by just changing the value of parameter and the reporting viewer result screen becomes blank?Fri, 15 May 2009 06:32:09 GMTGunjanhttp://www.sqlservercentral.com/Forums/Topic717347-150-1.aspxThen as far my knowledge it will get refresh because it will execute all the dataset once again based on selected parameter valueFri, 15 May 2009 06:25:35 GMTArunkumar S Phttp://www.sqlservercentral.com/Forums/Topic717347-150-1.aspxYes.Fri, 15 May 2009 06:19:00 GMTGunjanhttp://www.sqlservercentral.com/Forums/Topic717347-150-1.aspxAre you excuting any query based on the selecting parameter value?.Fri, 15 May 2009 05:49:06 GMTArunkumar S Phttp://www.sqlservercentral.com/Forums/Topic717347-150-1.aspxHi, I have designed parameterized repot. parameter has set of values, so in report viewer a drop down will appear and it shows the available values whichever I have set. Report works fine the only problem is when I change the selection from dropdown, report gets refreshed and it becomes blank. If I click on View report it shows the data for that parameter.How can I avoid this extra refresh??Any idea??ThanksThu, 14 May 2009 13:44:33 GMTGunjan