pass parameters to reportviewer using mysql

Question

0.00/5 (No votes)

See more:

VS2010

hi all,
i want to know generate the reports using reportviewer vs2010 with mysql database.while i generate the reports with single table means(dataset,report.rdlc and reportviewer).when i use join query and pass parameters,its not working.Tell me how to pass parameters in reportviewer vs2010

i tryed with this code,but iam not get any o/p

C#

this.ReportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";
ReportParameter rps = new ReportParameter("course_code",);
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rps });
this.ReportViewer1.LocalReport.Refresh();

Posted 9-Oct-11 22:38pm

srujitharam

Updated 10-Oct-11 0:05am

DaveAuld

v4

Add a Solution

Comments

André Kraak 10-Oct-11 6:06am

Your parameter creation seems to be missing a second parameter: ReportParameter rps = new ReportParameter(“course_code”,);

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

luisnike19 · Answer 1 · 2011-10-10T03:52:00

Solution 1

this.ReportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";
ReportParameter rps = new ReportParameter("course_code","ABC");
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rps });
this.ReportViewer1.LocalReport.Refresh();

Check this
http://www.gotreportviewer.com/localmodeparameters/index.html[^]

Posted 10-Oct-11 3:52am

luisnike19

Comments

srujitharam 11-Oct-11 1:59am

hi,
thanks for your solution.its better than before,now report is loading after execution, but it doesn't show any o/p.

Regards

srujitharam 18-Oct-11 5:34am

"ABC" is static value,but i want to pass multiple values,and i replace "ABc" with parameter but is not working.

luisnike19 18-Oct-11 9:35am

luisnike19 - 1 sec ago
I do not understand what's the problem here. Any exception?
are u using a rdlc file? Did you add the DataSource to the report?

I hope this helps you
http://forums.asp.net/t/1240076.aspx/1

srujitharam 18-Oct-11 10:15am

iam working with ssrs 2005 using mysql database.iam trying to pass multi value parameters.In filters i wrote like IN(?),parameter is passed, and i double click on dataset i wrote in parameters like
=JOIN(Parameters!course_code.Value,","),but it generates only single value. i want to generate multi value parameters,could you tell the solution for this.i dont know mysql is supported or not to ssrs