access_time 6 years ago visibility877 comment 0 languageEnglish
more_vert
Create Business Reports using SSRS

Serial: An Introduction to SQL Server Features

Case Scenario

After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service).

The general requirements for in this scenario are:

  • Sales performance in different areas
  • Sales amount for different products
  • Reports can be subscribed and exported to different formats (Excel, PDF, Word, CSV..)
  • Reports are accessible through browsers (IE, Chrome, Firefox…)

Create SSRS Report

1) Create SSRS project ‘SSRS-Sample’

2) Create Shared Data Source ‘SalesDS’

image

Credentials: using the SQL Server Account.

3) Use Report Wizard to create one new report ‘SalesPerformanceDashboard’

Select the Data Source: choose the shared data source ‘SalesDS’

Design the Query: use the following query

SELECT        Areas.AreaName, Products.ProductName, Products.Color, SUM(Sales.Amount) AS Amount
FROM            Areas INNER JOIN
                         Sales ON Areas.AreaId = Sales.AreaId INNER JOIN
                         Products ON Sales.ProductId = Products.ProductId
Group BY   Areas.AreaName, Products.ProductName, Products.Color

Select the Report Type: choose tabular

Design the Table:

image

Choose the Table Layout:

image

Choose the Table Style: choose Corporate

Report Name: input SalesPerformanceDashboard

Then you can preview the report in Visual Studio.

image

4) Add charts into the report.

Add chart form Toolbox into the report design area and name is as ‘Area Sales’. Select the report type Pie.

image

Add another Column chart to show sales by products.

image

Add the third Pie chart to show sales by Color preferences.

The dashboard looks like the following screenshot:

image

SSRS Subscriptions

SSRS supports reporting subscriptions which deliver reports through Email, Shared Folder, SharePoint… It can be configured with schedules and data-driven events.

Find out more at <http://msdn.microsoft.com/en-us/library/ms159762.aspx>.

info Last modified by Raymond at 2 months ago * This page is subject to Site terms.

More from Kontext

Pandas DataFrame Plot - Scatter and Hexbin Chart

local_offer plot local_offer pandas local_offer jupyter-notebook local_offer python

visibility 32
thumb_up 0
access_time 2 months ago

 In this article I'm going to show you some examples about plotting scatter and hexbin chart with Pandas DataFrame. I'm using Jupyter Notebook as IDE/code execution environment.  Hexbin chart &nbs...

open_in_new View open_in_new Code snippets

Pandas DataFrame Plot - Area Chart

local_offer plot local_offer jupyter-notebook local_offer python local_offer pandas

visibility 20
thumb_up 0
access_time 2 months ago

This article provides examples about plotting area chart using  pandas.DataFrame.plot  or  pandas.core.groupby.DataFrameGroupBy.plot   function. ...

open_in_new View open_in_new Code snippets

Pandas DataFrame Plot - Pie Chart

local_offer plot local_offer pandas local_offer jupyter-notebook local_offer python

visibility 438
thumb_up 0
access_time 2 months ago

This article provides examples about plotting pie chart using  pandas.DataFrame.plot  function. Prerequisites The data I'm going to use is the same as the other article  ...

open_in_new View open_in_new Code snippets

Pandas DataFrame Plot - Line Chart

local_offer plot local_offer pandas local_offer jupyter-notebook local_offer python

visibility 65
thumb_up 0
access_time 2 months ago

This article provides examples about plotting line chart using pandas.DataFrame.plot function. Prerequisites The data I'm going to use is the same as the other article  ...

open_in_new View open_in_new Code snippets

info About author

Dark theme mode

Dark theme mode is available on Kontext.

Learn more arrow_forward

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.


Learn more arrow_forward