How to add any chart to a report in SSRS?
A chart can be added by the following approaches:
- Create a report and then define the dataset value for it.
- Under the “Insert” tab, click on “Chart”. The drop-down list will appear, from where select the “Insert Chart” option.
- On the design surface, click on the upper left corner of the chart and drag it as per your desired size of the chart.
- Once you release the mouse, the “Select Chart Type” pop-up box appears.
- From the list, you can select the type of chart of your choice.
- Click on “OK”
- To view the “Chart Data” pane, click on the chart
- Under the “Values” area, add fields as per our choice
- From hereon, you can add the “Category Groups” area. Once you click on this field, a grouping field will automatically be created. Each and every group represents its data point in the series.
- If you want to summarize the data by its category, one needs to the right click on the Data field and then from the options, select the “Series Properties”. From the drop-down list of the Category box, select the category field. Then click on the “OK” button.
- Click on the “Run” option to see the report rendered by it from the “Home” tab.
- Click on the “Design” option to proceed with working on your report from the “Run” tab.
BY Best Interview Question ON 07 Jul 2020