SSRS Smooth Area Graph

This SSRS article shows how to create a standard and 3D Smooth Area Graph and format the fonts and colors with an example. To demonstrate this example, right-click on the Datasets folder to create a new DataSet.

Writing the below code inside the SSMS shows the data set that we use for this example.

The Sql query that we used in this SSRS example is:

SELECT Fact.[OrderDate],Fact.[ShipDate],Fact.DueDate,
SUM(Fact.TotalProductCost) AS ProductCost, SUM(Fact.SalesAmount) AS Sales
FROM FactInternetSales AS Fact
GROUP BY Fact.[OrderDate], Fact.[ShipDate],Fact.DueDate

SSRS Smooth Area Graph

To add a smooth Area graph, right-click the report area, choose Insert, and then the chart option from the context menu. Otherwise, drag and drop the chart from the toolbox to the report area.

Choose Insert Chart Option

Select the Smooth Area Graph from the window and click OK to add to the report area.

Choose the SSRS Smooth Area Graph

Use the Plus button or drag the fields to the Values and Category Groups section. Here, we added the Sales column to the Values and Order Date column in the Category Groups section.

Add Columns to Values and Category Groups

Preview the SSRS Smooth Area Graph report.

SSRS Smooth Area Graph Preview

Under the Category Groups section, click the down arrow beside the OrderDate column and select the Category Group Properties option. 

Next, click the ƒx button beside the OrderDate Group on. It helps to change the group by column. Here, we used the Month function to extract the Month from the Order Date.

Add group On Expression in Category Groups

Click the preview button to see the SSRS Smooth Area Graph showing monthly sales.

Report Preview

The Second Approach

Double-click the DataSet, and under the fields tab, click the add calculated field. Assign Month as the column name and click ƒx button to write the below expression that extracts the Month from the Order Date.

Add Group On Expression

Let me add that Month field to the Series Groups section.

Change the category Groups Value

Now, the SSRS Smooth Area Graph assigns a different color to each month.

SSRS Smooth Area Graph Preview

To compare multiple measure values area, let me add the Product Cost column to the Values section and replace Order Date with the Month column. Next, right-click on the area to show Data Labels. 

Add Multiple Measures to Values

Click the preview button to see the SSRS Smooth Area Graph comparing two measures and Data Labels.

Report with Multiple Measures

SSRS 3D Smooth Area Chart

Right-click on the chart and choose the Change Chart Type option. Next, select the 3-D Smooth Area Chart from the window.

Select 3D version

Preview the report.

SSRS 3D Smooth Area Graph Preview