Click here to Skip to main content
Click here to Skip to main content

Tagged as

Adding Chart Controls to SSRS Report

, 2 Dec 2011
Rate this:
Please Sign up or sign in to vote.
How to add chart control to reports defined in SSRS

Introduction

In this article, I will discuss how to add chart controls to reports defined in SSRS.

To work with this, I will use a sample report which I showcased in my article, Basics of SSRS.

Below is the step by step process to work on this sample:

  1. Generate & define SSRS report
  2. Add Chart Control to report
  3. Set Datasource to Chart Control
  4. Define Fields to be used by Chart Control

Generate & Define SSRS Report

  1. Once you generate & define your report, the report will look similar to that shown below. Here I have generated a report based on my article “Basics of SSRS”.

    Design View

    Preview

Add Chart Control to Report

  1. To add chart control, click on Design tab.
  2. Now go to menu items select View, select Report data:

  3. Select toolbox from “Report Data” as shown below:

  4. Now from Report Items, double click “Chart”, which will show list of charts available. From this list, let’s select first chart control & click ok button.

  5. Now chart control will be added to the report. So now let's align it properly to the right:

Set Datasource to Chart Control

  1. To set datasource, right click chart control, select Chart, select Chart Properties as shown below:

  2. Now this shows up a window as shown below. So let's select / change values accordingly. The datasource that I have selected is DataSet1, as this is the same source used by report (see in ReportData).

  3. After setting the values, click ok button.

Define Fields to be used by Chart Control

  1. To set fields to the chart control, move mouse pointer to “Drop data fields here”, “Drop series fields here” & “Drop category fields here” section.

  2. When you move mouse pointer to the above mentioned sections, a small image is shown in the right corner of sections (see Drop data fields here). Click the image which will show up the fields specific to Dataset which you have assigned in one of our above steps.

  3. In my case, I have added field in “Drop data fields” & “Drop Series fields”. After adding fields, save it & go to “Preview” tab which should show up data similar to below:

Don't forget to rate the article if it helped!

Happy coding, hope this helps!

License

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

Share

About the Author

Bangla Gopal Surya Prakash
Software Developer (Senior)
United States United States
B.Tech graduate in CSE, having experience in .Net related Technologies
 
Microsoft Certified Technical Specialist in .NET Framework 2.0
Microsoft Certified Technical Specialist in .NET Framework 4.0
 
My interests are Coding, reading [technical stuff] and listening to music, playing Cricket, Table Tennis
 
http://bgsuryablog.blogspot.com/

Comments and Discussions

 
QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide PinmemberMember 1069685125-Mar-14 4:23 
Questiondynamic series in SSRS chart Pinmembersaikat Malakar15-Oct-12 23:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140814.1 | Last Updated 2 Dec 2011
Article Copyright 2011 by Bangla Gopal Surya Prakash
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid