A data source instance has not been supplied for the data source 'DataSet1'.

Question

User989035446 posted

Hi,

I have a rdlc report but it is not working. It show me this error at run time.

Below is my code:

Client side
-----------------------
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
        Font-Size="8pt" InteractiveDeviceInfos="(Collection)" 
        WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
        <LocalReport ReportPath="Report\Report1.rdlc">
        </LocalReport>
    </rsweb:ReportViewer>



Server Side
------------------------
 dsMRDtl = SearchMRDtl("EMR9");
 ReportDataSource datasource = new ReportDataSource("DataSet1_MRRpt", dsMRDtl.Tables[0]);
 ReportViewer1.LocalReport.DataSources.Add(datasource);
 ReportViewer1.LocalReport.Refresh();

Below is the screen on how the dataset is created.

What is missing out actually?

I have tried the whole morning but still do not find out solution for this

Answer 1

User522486851 posted

did you fill the DataSet1 before calling the

 

ReportDataSource datasource = new ReportDataSource("DataSet1_MRRpt", dsMRDtl.Tables[0]);

?

Answer 2

User989035446 posted

Hi Sankalpa,

Yes i have filled the dataset before calling. I am sure that there are 4 records in the dataset. ^^

Answer 3

User143067745 posted

johnsonlim026

Server Side
------------------------
 dsMRDtl = SearchMRDtl("EMR9");
 ReportDataSource datasource = new ReportDataSource("DataSet1_MRRpt", dsMRDtl.Tables[0]);
 ReportViewer1.LocalReport.DataSources.Add(datasource);
 ReportViewer1.LocalReport.Refresh();

Rather than using this code you can take an ObjectDataSource control(located at Data in Toolbox of VS)  and configure it for the dataset and then you can assign it as datasource to ReportViewer, You can do all these in design mode so it is more easy as well.

Answer 4

User522486851 posted

Cauld you please post your full server side code?

Answer 5

User989035446 posted

Hi Sankalpa,

This is all my code.CAn you help?

--Client Side

    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" ScriptMode="Release">
        </asp:ScriptManager>
    <div>
    
  

    
    </div>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
        Font-Size="8pt" InteractiveDeviceInfos="(Collection)" 
        WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
        <LocalReport ReportPath="Report\Report1.rdlc">
        </LocalReport>
    </rsweb:ReportViewer>
 
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server">
    </asp:ObjectDataSource>
 
    </form>

----Server Side

 protected void Page_Load(object sender, EventArgs e)
    {

        try {

            DataSet dsMRDtl = new DataSet();

            ViewState["MRNo"] = "EMR9";
            ViewState["MRNo"] = Request.QueryString["MRNo"];
            dsMRDtl = SearchMRDtl("EMR9");



            ReportDataSource datasource = new ReportDataSource("DataSet1_MRRpt", dsMRDtl.Tables[0]);
            ReportViewer1.LocalReport.DataSources.Add(datasource);
            ReportViewer1.LocalReport.Refresh();


           




        }
        catch (Exception ex) {
            throw ex;
        }


    }

Answer 6

User989035446 posted

Hi mishra,

I have try with Data source, but nothing coming out, not even error message.Do you have any ide how to configure?

Do you have any idea which Object i need to choose? Dataset1?DataSet1 + MRRptDataTable<Table i created in Solution Explorer> and also which data methods i need to user?

Attached is the picture

Help Please!!