Display SSRS Report based on winform parameters.

Posted by Rajanarayanan under Sql Server on 5/3/2013 | Points: 10 | Views : 3750 | Status : [Member] | Replies : 1

I need to display report in winform based on winform parameters.

I'm ve in SSRS report via URL, I deployed in Reportviewer in winform . Now I need to display that report based on my win form parameters i.e., I'm ve in textbox and button.

I ve to enter related item in textbox and when I press the button the report should be viewed based on this values. Remember I'm calling report via URL.

How I'll do this... Plzz help me out.....

code :

in btn click event :

rptViewer.ServerReport.ReportServerUrl = new Uri(@"http://localhost/ReportServer");
rptViewer.ServerReport.ReportPath = "/Custom Report/Custom Tempalte1";
rptViewer.ProcessingMode = ProcessingMode.Remote;
ReportParameter[] reportParameterCollection = new ReportParameter[1];
reportParameterCollection[0] = new ReportParameter("EmployeeGroup", textBox1.Text);
rptViewer.ShowParameterPrompts = false;
rptViewer.ShowPromptAreaButton = false;

In report designer i am using 'EmployeeGroup' same parameter in query also.

Thanks & Regards


Thanks & Regards
Narayanan P


Posted by: Niladri.Biswas on: 5/6/2013 [Member] Platinum | Points: 25

This should help you


Best Regards,
Niladri Biswas

Rajanarayanan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response