How to bind report with report viewer programmatically

Question

0.00/5 (No votes)

See more:

Hi Everyone,

In my application I have one report viewer. The report viewer already binded with one [ReportVendor] report. While I'm clicking one button,I need to bind another report[ReportAssetList] with the report viewer. I have given my code below.

C#

private void button1_Click(object sender, EventArgs e)
        {
            reportViewer1.Reset();
            reportViewer1.ProcessingMode = ProcessingMode.Local;
            LocalReport localReport = reportViewer1.LocalReport;
            localReport.ReportPath = "ReportAssetList.rdlc";
            DataSet dataset = new DataSet("DataSetAssetList");

            GetAssetDetail(ref dataset);

            // Create a report data source for the sales order data
            ReportDataSource datasource = new ReportDataSource();
            datasource.Name = "assetsBindingSource";
            datasource.Value = dataset.Tables["Assets"];
            localReport.DataSources.Add(datasource);
            reportViewer1.Refresh();
            MessageBox.Show("Ok");
       }





public void GetAssetDetail(ref DataSet ds)
        {
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT Descriptn,                 AssetType, Location, Model, SerialNumber, Status, AssetCode, Dateofpurchase, WarrantyExpiry, Condition, Profile FROM Assets", con);
            dataAdapter.Fill(ds);
        }

Please help me with this..

Posted 2-Jun-15 1:00am

Sarath kumar.N

Updated 2-Jun-15 1:18am

RajeeshMenoth

v2

Add a Solution

Comments

ZurdoDev 2-Jun-15 14:31pm

What exactly is your question?

Sarath kumar.N 3-Jun-15 1:10am

I have one report viewer, but I have multiple reports. I need change the report as per the client input. For example client click for Assets detail. I need to bind the AssetDetail.rdlc report at runtime. I have written a code for that, but it's not working..

ZurdoDev 3-Jun-15 7:19am

Change the report path. And what do you mean by it is not working?

Sarath kumar.N 3-Jun-15 7:25am

Yeah I changed the path value from ReportVendor.rdlc to ReportAssetList.rdlc, But report viewer showing blank. It showing Nothing.

ZurdoDev 3-Jun-15 7:27am

Is it inside an async update panel or are you somehow doing this with only a partial postback?

Sarath kumar.N 3-Jun-15 7:27am

This is winform application.

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)

Sarath kumar.N · Accepted Answer · 2015-06-04T20:34:00

At last I found the answer form Internet.

C#

OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT Descriptn, AssetType, Location, Model, SerialNumber, Status, AssetCode, Dateofpurchase, WarrantyExpiry, Condition, Profile FROM Assets", con);
            DataSet ds = new DataSet();
            dataAdapter.Fill(ds);
            reportViewer1.Reset();
            this.reportViewer1.LocalReport.DataSources.Clear();
            ReportDataSource reportDataSource = new ReportDataSource();
            reportDataSource.Value = ds.Tables[0];
            reportDataSource.Name = "DataSetAssetList";
            this.reportViewer1.LocalReport.DataSources.Add(reportDataSource);            
            this.reportViewer1.LocalReport.ReportEmbeddedResource = "AssestsManagementSystem.ReportAssetList.rdlc";            
            this.reportViewer1.RefreshReport();