Click here to Skip to main content
15,895,667 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
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:

ASP.NET
<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>


I need to generate a report by clicking the enetr button

What I have tried:

I have tried this but my steps are incorrect as I do not have experience working on this before.
Posted
Updated 2-Nov-16 9:03am

1 solution

As the name suggests, the ReportViewer control is used to view reports.

If you want to create a report, you'll need to use either Visual Studio or Report Builder.
Designing Reports in Report Designer and Report Builder 3.0 (SSRS)[^]
Report Builder Tutorials[^]

If you're deploying the report to a SQL Server Reporting Services (SSRS) instance, then you'll use "remote mode" for the report viewer:
Walkthrough: Using the ReportViewer Control in Remote Mode[^]

If you're going to run it locally, then you'll use "local mode". This type of report can only be created in Visual Studio.
Using the ASP.NET 2.0 ReportViewer in Local Mode[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900