I created a report in VS2015, please see below
This report was not deployed in a report server. It only resides in the project application. I was able to view it without any parameter. But When I added a parameter, I don't know how to call the report in the backend of my DailySalesReport_ECI. I tried this code but gives me an error.
- protected void btnSearch_Click(object sender, EventArgs e)
- {
- ReportViewer1.Width = 900;
- ReportViewer1.Height = 600;
- ReportViewer1.ProcessingMode = ProcessingMode.Remote;
-
- ReportViewer1.ServerReport.ReportPath = "~/DhipayaAgents/Reports/DailySalesReport_ECI.aspx";
- ReportViewer1.ServerReport.Refresh();
- }
Below is my aspx code:
- <body>
- <form id="form1" runat="server">
- <div>
- <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
- <div>
- <table>
- <tr>
- <td>
- Start date:
- </td>
- <td>
- <asp:TextBox ID="txtStartDate" runat="server"></asp:TextBox>
- </td>
- </tr>
- <tr>
- <td>
- End date:
- </td>
- <td>
- <asp:TextBox ID="txtEndDate" runat="server"></asp:TextBox>
- </td>
- </tr>
- <tr>
- <td colspan="2" style="text-align:center;">
- <asp:Button ID="btnSearch" runat="server" Text="Search" OnClick="btnSearch_Click" />
- </td>
- </tr>
- </table>
-
- </div>
- <br />
- <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="1008px">
- <LocalReport ReportPath="DhipayaAgents\Reports\DailySalesReport_eCI.rdlc">
- <DataSources>
- <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet_eCI_DailyReport" />
- </DataSources>
- </LocalReport>
- </rsweb:ReportViewer>
-
- <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="DhipayaEci.DhipayaAgents.Reports.DSShortTermTableAdapters.DTeciTableAdapter">
- <SelectParameters>
- <asp:ControlParameter ControlID="txtStartDate" Name="StartDate" PropertyName="Text" Type="DateTime" />
- <asp:ControlParameter ControlID="txtEndDate" Name="EndDate" PropertyName="Text" Type="DateTime" />
- </SelectParameters>
- </asp:ObjectDataSource>
-
- </div>
- </form>
- </body>
Hope someone can guide me. Thanks