How to pass textbox value to reportviewer textfield

Question

0.00/5 (No votes)

See more:

I have a parameter named InvoiceNumber, I linked this parameter to my report text field.

How do I pass my textbox1 value to my taxt field using this parameter.

I'm using C# ReportViewer, windows form and SQL in my project

I have tried the following

C#

this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report2.rdlc";
ReportParameter rp = new ReportParameter("InvoiceNumber", this.textBox2.Text);
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
           
this.reportViewer1.RefreshReport();

I have also added correct namespace and now the program runs, but as soon as i press the generate button it gives error at

this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });

an error occured during local processing

Posted 18-Sep-12 6:10am

GoggatjieLiesl

Updated 18-Sep-12 20:46pm

v5

Add a Solution

Comments

Sandeep Mewara 18-Sep-12 12:35pm

Crystal or SSRS?

GoggatjieLiesl 18-Sep-12 12:37pm

Hey Its the normal reportviewer that comes with c#

i have tried the following

this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report2.rdlc";
ReportParameter rp = new ReportParameter("InvoiceNumber", this.textBox2.Text);
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });

this.reportViewer1.RefreshReport();

now i get error missing namespace or a assembly reference?
How do i fix this

[no name] 18-Sep-12 13:19pm

It would be better to improve your question instead of adding lines of code in a comment.

GoggatjieLiesl 18-Sep-12 13:45pm

Thanks

1 solution

Add a Solution

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

sahabiswarup · Answer 1 · 2012-09-19T21:28:00

Here is an example...
I've sent datatable value from a form to a report viewer..

string sqlQuery1 = "SELECT * from table";
                        adp = new SqlDataAdapter(sqlQuery1, conn);
                        DataTable dt1 = new DataTable();
                        adp.Fill(dt1);
CRViewerAll cvphall = new CRViewerAll();
                        cvphall.dt = dt1;
                        cvphall.Show();

CRViewerAll page code

C#

public partial class CRViewerAll : Form
    {
        public CRViewerAll()
        {
            InitializeComponent();
        }
        public DataTable dt = new DataTable();
    }

How to pass textbox value to reportviewer textfield

1 solution

Solution 1

Add your solution here

Preview 0

How to pass textbox value to reportviewer textfield

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us