Create Chart in SSRS(RDLC) Report

Introduction

Asp.Net provides a wonderful reporting tool using which we can create different kinds of charts like Line chart, bar chart,pie chart etc. in addition to tabular reports.

Objective
To create a column chart to show category-wise total sale made.

// 1. Procedure to fetch product-wise sales amount                                                                  create procedure spProductDetails
as
Begin
select Categories.CategoryName ,Total=sum((Quantity *
 [Order Details].UnitPrice-Discount ) )from [Order Details] ,Products,Categories 
where products.ProductID=[Order Details].ProductID and Categories .CategoryID=Products .CategoryID 
group by Categories.CategoryName   
End                                                                                   

// 2.Add Chart Control to RDLC                                                         
Add an appropriate chart control to the Rdlc file, in this article i have added a column chart.Then drag the categoryname field to the category axis and total to value box as shown in the diagram below and save the file

//3.Add a Report Viewer to the ASPX page from the toolbox                            <form id="form1" runat="server">
    <div>
    
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
            Font-Size="8pt" Height="400px" Width="674px">
            <LocalReport ReportPath="Report.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" 
                        Name="DataSet3_spProductDetails" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
            OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" 
            TypeName="DataSet3TableAdapters.spProductDetailsTableAdapter">
        </asp:ObjectDataSource>
    
    </div>
    </form>                                

If you like this article, subscribe to our RSS Feed. You can also subscribe via email to our Interview Questions, Codes and Forums section.