Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ReportViewer (web control) - parameter change refresh Expand / Collapse
Author
Message
Posted Thursday, May 14, 2009 1:44 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 2:37 PM
Points: 78, Visits: 284
Hi,

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??
Thanks


Thanks.

Gunjan.
Post #717347
Posted Friday, May 15, 2009 5:49 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, Visits: 870
Are you excuting any query based on the selecting parameter value?.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Post #717772
Posted Friday, May 15, 2009 6:19 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 2:37 PM
Points: 78, Visits: 284
Yes.

Thanks.

Gunjan.
Post #717793
Posted Friday, May 15, 2009 6:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, Visits: 870
Then as far my knowledge it will get refresh because it will execute all the dataset once again based on selected parameter value

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Post #717802
Posted Friday, May 15, 2009 6:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 2:37 PM
Points: 78, Visits: 284
Thanks 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?


Thanks.

Gunjan.
Post #717813
Posted Monday, June 13, 2011 1:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 13, 2011 1:50 AM
Points: 1, Visits: 1
Hi,

Did you find the solution for this problem I'm having it also?

Thanks,
J
Post #1124080
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse