Как создать отчет с помощью средства просмотра отчетов?..
Hi, I need to create a report using Report viewer. unfortunately, I haven't worked on Report viewer before. My SQL query accepts 3 parameters to fetch the data from SQL server. Query would be: Select col1,col2,col3 from table1 where area='ddlselectedarea' and start_date='01-01-2016' and end_date='31-01-2016' My UI would be:
<section id="content" class="has-btn-bar-btm-fixed"><!-- content --> <form runat="server" class="form-horizontal custom-form row"> <div class="cost-transfer-block"><!-- cost-transfer-block --> <div class="container-fluid"> <div class="row"> <div class="col-md-8 col-lg-10"> <h2>Dump by item</h2> <div class="col-md-6"> <div class="form-group"> <asp:label runat="server" Text="From Site" ID="lblFromSite" class="control-label col-sm-3 col-md-3 col-lg-3" > <div class="col-sm-9"> <div class="input-group"> <select class="form-control"> <asp:DropDownList ID="DdlFromsite" runat="server" > </select> <span class="input-group-addon"><a> </a></span> </div> </div> </div> </div> <div class="col-md-6 cst-brd-left"> <div class="form-group"> <asp:label runat="server" Text="From Date" ID="lblFromDate" class="control-label col-sm-3 col-md-3 col-lg-3" > <div class="col-sm-9 transferdate"> <div class="input-group date"> <input type="date" class="form-control" id="" placeholder="Select Date" > <span class="input-group-addon"><a></a></span> </div> </div> </div> <div class="form-group"> <asp:label runat="server" Text="To Date" ID="lblToDate" class="control-label col-sm-3 col-md-3 col-lg-3" >To Date <div class="col-sm-9 transferdate"> <div class="input-group date"> <input type="date" class="form-control" id="" placeholder="Select Date" > <span class="input-group-addon"><a></a></span> </div> </div> </div> </div> </div> <div class="col-md-4 col-lg-2"> </div> </div> </div> </div> <!-- /cost-transfer-block --> <%--<asp:ScriptManager ID="ScriptManager1" runat="server"> <rsweb:reportviewer id="ReportViewer1" runat="server">--%> <div class="gray-btn-row clearfix"> <div class="btns-group"> <asp:button runat="server" Text="Enter" ID="btnEnter" class="btn btn-dark-blue"> </div> </div> </form> </section>
Мне нужно сгенерировать отчет, нажав кнопку enetr
Что я уже пробовал:
Я пробовал это сделать, но мои шаги неверны, так как у меня нет опыта работы над этим раньше.