views:

43

answers:

1

I have created an rdlc where i have used dataset taken as a new item in solution explorer for designing my report. After binding my report from that datasource which is named as Dataset1. I have created its object and tried to fill this datasource using coding. Now when i runs the folowing code i am not getting any result.

What can be the issue?

 reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
            LocalReport localReport = reportViewer1.LocalReport;
            localReport.DataSources.Clear();
            localReport.ReportPath = @"E:\Projects\Manojp\AARFID_SSRS_Report\WindowsFormsApplication1\WindowsFormsApplication1\Local Report\rptTest.rdlc";

           // DataSet dataset = new DataSet("AARFID_Report");
            DataSet1 ds = new DataSet1();

            // fill the Data Set from DataBase.
            //ds.Tables.Remove("M_GUEST");
            ds.Tables.Clear();
            GetData(ref ds);

            //
            // Create a report data source for the sales order data

            ReportDataSource rds = new ReportDataSource();
            rds.Name = "AA";
            rds.Value = ds.Tables[0];
            localReport.DataSources.Add(rds); 
           // reportViewer1.LocalReport.DataSources.Add(rds); 


            reportViewer1.RefreshReport();
            localReport.DataSources.Clear();

GetData do this

 connection.Open();
            ad.Fill(ds,"M_GUEST");

            connection.Close();

In thr report view a message is shown as "A data source instance has not been supplied for the data source 'dtaset1_m_guest'"

A: 

Make sure the names of datasets in the rdl file and the report generator match!

The easiest way would be to have a DataSet, DataSource and the instances named "M_GUEST". Also, do not clear the data sources before rendering.

Jaroslav Jandek