ReportViewer (web control) - parameter change refresh

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » ReportViewer (web control) - parameter change...

ReportViewer (web control) - parameter change refresh

Rate Topic

Display Mode

Topic Options

Author

Message

Gunjan

Posted Thursday, May 14, 2009 1:44 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 9:44 AM
Points: 78, Visits: 251

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

Arunkumar S P

Posted Friday, May 15, 2009 5:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:59 PM
Points: 230, 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

Gunjan

Posted Friday, May 15, 2009 6:19 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 9:44 AM
Points: 78, Visits: 251

Yes.

Thanks.

Gunjan.

Post #717793

Arunkumar S P

Posted Friday, May 15, 2009 6:25 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:59 PM
Points: 230, 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

Gunjan

Posted Friday, May 15, 2009 6:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 9:44 AM
Points: 78, Visits: 251

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

james.gallagher 60249

Posted Monday, June 13, 2011 1:50 AM

Forum 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 »

Permissions