Passing a text box value as a parameter in RDLC report.

Question

0.00/5 (No votes)

See more:

I am working on a desktop application in C#.net and using RDLC Report.
I want to print text box values in report, but after setting parameters in rdlc and passing the values to report in report viewer, my printed report gives this error.
" the "parameter_name" parameter is missing a value ".
I have tried all ways but could not find the solution of this problem.
Kindly help me out.

What I have tried:

Code to add parameter is
ReportParameter[] parms = new ReportParameter[1];
parms[0] = new ReportParameter("[@parameter_name]", Form1.TextBox1.Text);
this.reportViewer1.LocalReport.SetParameters(parms);
this.reportViewer1.RefreshReport();

Posted 19-Aug-16 23:24pm

SalmanQureshi

Updated 13-Dec-17 7:28am

Add a Solution

2 solutions

Solution 3

C#

ReportParameterCollection reportparameter = new ReportParameterCollection();
           reportparameter.Add(new ReportParameter("productType", Globalvariables.username.ToString()));
           reportparameter.Add(new ReportParameter("customername", Globalvariables.username.ToString()));
           reportparameter.Add(new ReportParameter("customeraddress", Globalvariables.username.ToString()));
           this.ReportViewer1.LocalReport.SetParameters(reportparameter);
           this.ReportViewer1.LocalReport.Refresh();

Posted 13-Dec-17 7:26am

Abdulateef

Comments

Richard Deeming 13-Dec-17 14:38pm

Asked, answered, and solved over a year ago.

And your solution simply repeats what the accepted solution says.

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)

Karthik_Mahalingam · Accepted Answer · 2016-08-19T23:39:00

Solution 1

remove the square brackets and try

C#

parms[0] = new ReportParameter("parameter_name", TextBox1.Text);

Posted 19-Aug-16 23:39pm

Karthik_Mahalingam

Updated 19-Aug-16 23:47pm

v2

Comments

SalmanQureshi 20-Aug-16 5:49am

Removed, but still having the same error...

Karthik_Mahalingam 20-Aug-16 6:01am

pass some hardcoded value to it and check
parms[0] = new ReportParameter("parameter_name","abc");

SalmanQureshi 20-Aug-16 6:17am

Already Checked, still having the same problem

Karthik_Mahalingam 20-Aug-16 6:20am

how you have declared the parameter in sql ?

SalmanQureshi 20-Aug-16 7:04am

i am declaring the parameter in C# code, and passing value directly to RDLC report

Karthik_Mahalingam 20-Aug-16 7:09am

post the screenshot of it using
http://imgur.com/

SalmanQureshi 20-Aug-16 7:25am

http://imgur.com/K5yoqPa
http://imgur.com/t8r2zFb

Karthik_Mahalingam 20-Aug-16 7:29am

try this
parms[0] = new ReportParameter("paramname", TextBox1.Text);

SalmanQureshi 20-Aug-16 7:42am

I did it already, but still the same error...

Karthik_Mahalingam 20-Aug-16 8:00am

but your screenshot shows different name

SalmanQureshi 20-Aug-16 8:49am

I have changed it now...

Karthik_Mahalingam 20-Aug-16 8:54am

working?

SalmanQureshi 20-Aug-16 10:56am

No bro, same issue.. also checked the program by using break points... But not resolved

Karthik_Mahalingam 20-Aug-16 11:29am

clean the solution and rebuild and check it.

SalmanQureshi 20-Aug-16 16:10pm

I have found that why it is happening. Text is clearly going from text box, but when i make the object of the form then compiler sets the default value of all the controls on that page that's why text box value is set to empty string and report shows parameter value missing.

Karthik_Mahalingam 21-Aug-16 0:09am

y do you want to make the object, just use the existing control object

SalmanQureshi 20-Aug-16 16:12pm

Now, is there any solution of that? After creating the object I can use the same value of text box the i entered... Kindly help

Karthik_Mahalingam 21-Aug-16 0:10am

just use this.TextBox1.Text

SalmanQureshi 21-Aug-16 2:04am

My report viewer is on another form, and data is coming from another form. I think in c#, we can not access the controls of one form in another form unless we make object of that form and then call that object with the control name. Just like that:
ObjectName.TextBox.text

Karthik_Mahalingam 21-Aug-16 2:21am

you can access. its simple.

SalmanQureshi 21-Aug-16 3:30am

Please tell me the code

Karthik_Mahalingam 21-Aug-16 3:46am

Does both the form being opened ?

SalmanQureshi 21-Aug-16 3:54am

Form1 has a button, when we click it it will take us to Form2 and there is report viewer, both form will ramain open.

Karthik_Mahalingam 21-Aug-16 4:01am

Ok then simple.
When opening the second form pass the text box value in the constructor of the form and access the value in secind form constructor by assigning it to a global variable
And pass the variable to the report.

I am posting from mobile. Power cut :(

SalmanQureshi 21-Aug-16 4:18am

Okay i will try that, but for now i have my report generation by setting all the data and report in the same form... But i will try that also

Karthik_Mahalingam 21-Aug-16 4:18am

Try this
http://imgur.com/a/Iy1cD

SalmanQureshi 21-Aug-16 5:34am

Woww man, you are owsum....high five... :) But now how can i take int value?

Karthik_Mahalingam 21-Aug-16 6:36am

Same like that..
Instead of string use int and caste wheereever needed

SalmanQureshi 22-Aug-16 1:14am

Thank u so much, learned alot from u, ALLAH bless u.

Karthik_Mahalingam 22-Aug-16 4:12am

Thank you so much for the blessing :)

Karthik_Mahalingam 22-Aug-16 9:42am

today my day was good, blessing worked :)