Error: a data source instance has not been supplied for the datasource 'dataset1'.

See more:

VB

ASP.NET

T-SQL

I am trying to display same number of columns but with different data in my rdlc report. My solution is to create two reportviewer and each of them has their own sqldatasource which I used stored procedures but with different parameters.

Here are my codes..

1st SqlDataSource for my ReportViewer1 link to the Report1.rdlc I have created:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
   ConnectionString="<%$ ConnectionStrings:AntiIllegalLoggingConnectionString %>"
   SelectCommand="DamnProc" SelectCommandType="StoredProcedure">
   <SelectParameters>
       <asp:ControlParameter ControlID="txtFrom" Name="dateFrom" PropertyName="Text" Type="String" />
       <asp:ControlParameter ControlID="txtTo" Name="dateTo" PropertyName="Text" Type="String" />
   </SelectParameters>
</asp:SqlDataSource>

2nd SqlDataSource for my ReportViewer2 link to the Report1.rdlc I have created:

<asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:AntiIllegalLoggingConnectionString %>"
         SelectCommand="summaryByRegion"
         SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="txtParam" Name="strRegion" PropertyName="Text" Type="String" />
            <asp:Parameter DefaultValue="01/01/2014" Name="dateFrom" Type="String" />
            <asp:Parameter DefaultValue="12/30/2099" Name="dateTo" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

Here are my reportviewers:

<rsweb:ReportViewer ID="ReportViewer1"  runat="server" ZoomMode="Percent" Height="1300px" Width="1050px" ZoomPercent="95">
        <LocalReport ReportPath="Account\ActiveUser\Report1.rdlc">
            <DataSources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
            </DataSources>
        </LocalReport>
    </rsweb:ReportViewer>

    <rsweb:ReportViewer ID="ReportViewer2"  runat="server">
        <LocalReport ReportPath="Account\ActiveUser\Report1.rdlc">
            <DataSources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource3" Name="DataSet1" />
            </DataSources>
        </LocalReport>
    </rsweb:ReportViewer>

I got an error :( Hope you can help me with this. Thank you!