Last post Oct 20, 2011 12:18 PM by arwind
Sep 11, 2011 03:19 AM|kfsehgal|LINK
Hi,In my ASP.Net project, I have added a data report and connected with dataset. It works fine but I have two issues:1) I want to load the report after a button on the page carrying MSReportViwer is pressed, say it is Show Report button. At the moment report is loading just at form load.2) I want to pass some parameter values to the sql query generating the report.For example Where Name=@NM and City=@CTvalues of NM and CT shall be given in the text boxes on the same form. After this i press the button 'Show Report' and it should display the report.Please advise how to do it.Thanks
Sep 11, 2011 08:36 AM|konanki|LINK
check below link
if it is not working send u r mail id i will send sample code
Sep 11, 2011 09:10 AM|bilal.qadeer|LINK
use following code.
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue discreteVal1 = new ParameterDiscreteValue();
ParameterField paramField1 = new ParameterField();
paramField1.ParameterFieldName = "desc";
discreteVal1.Value = desc;
and add this code after you provide the source to the report.
also add the parameter withe the name "desc" in report.
Oct 20, 2011 12:18 PM|arwind|LINK
You may interest in this article: