How do I add a reportparameter to a localreport and then reference it in a rdlc report(textbox)

Question

0.00/5 (No votes)

See more:

C#

using (LocalReport reportEngine = reportViewer1.LocalReport)                
                {       this.Instrument_ReadingsTableAdapter.Fill(this.LiveDataSetFromActualDB.Instrument_Readings);                 
                    reportEngine.ReportPath = Application.StartupPath + "\\Report1.rdlc";
                    //reportEngine.ReportPath = Application.StartupPath + "\\Report2.rdlc";
                    
                    // -- NEW CODE ADDED HERE
                    //ReportDataSource rds = new ReportDataSource();
                    //rds.Name = "Datasettest";
                    //rds

                    var dt_min = this.Instrument_ReadingsTableAdapter.Min();
                    var dt_max = this.Instrument_ReadingsTableAdapter.Max();

                    if (!dt_min.HasValue || !dt_max.HasValue)
                    {
                        return;
                    }

                    var diff = (dt_max.Value - dt_min.Value).TotalMinutes;

                    this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";

                    ReportParameter rp = new ReportParameter("Time_Span", diff.ToString());
                    reportEngine.SetParameters(new ReportParameter[] { rp });
                    this.reportViewer1.RefreshReport();

What I have tried:

I recieve an error
"Microsoft.reporting.WinForms.LocalReport.InternalGetReportParameters(CatalogItemContextBase reportContext, NameValueCollection userSpecifiedValues, ParameterInfoCollection baseLineParameters, DatasourceCredentialsCollection credentials, ReportRuntimeSetup reportRuntimeSetup at Microsoft.Reporting.Winforms.LocalReport.SetParameters(IEnumerable1 parameters)
at
Live_AM_Report.Form1.Form1_Load(Object sender, EventArgs e)
... line 255 , which = reportEngine.SetParameters(new ReportParameter[] { rp });

On the design side of the rdlc

I have added a parameter called Timespan in the "Report data"
I also added the textbox that refers to the parameter, now its a simple case of setting the value in that parameter, and the textbox should call it.
The Textbox's Value field = [@Time_Span] (The parameter i added)

I have struggled with this for a few days now, and its really frustrating, any help would be greatly appreciated.

Posted 14-Jul-16 2:33am

Real Revendell

Updated 14-Jul-16 22:21pm

Add a Solution

Comments

Richard Deeming 14-Jul-16 9:59am

What you've given us is part of the stack trace of the error. You've missed out the important part - the actual error message.

Click "Improve question" and update your question with the full details of the exception.

Also, you say you've created a parameter called "Timespan", but your code is trying to set a parameter called "Time_Span" - is that a typo in your question?

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)

Nitin_Bharekar · Answer 1 · 2016-07-14T22:21:00

To Add Parameter to RDLC report.
1. Open report in Visual Studio.
2. Press CRL + ALT + D
3. "Report Data" tab gets open.
4. Select "Parameter" and right click to add parameter.

In Set parameter

C#

ReportParameter[] rptParams = new ReportParameter[]
            {
                new ReportParameter("param1",txtParam1.Text),
                new ReportParameter("param2",txtParam2.Text)
};
rptInvoiceTC.LocalReport.SetParameters(rptParams);