Preview Content - log in or Join KEBI Academy

SSRS Create Simple Report

Video

Did you find this video useful? [+2]  |   [-0]
To access members only content log in
or join KEBI Academy and unlock your potential

Just $8/month
Silver Membership
View more
7 Days Free Trial
Subscriptions only
View more
Fast Learning
made easy & affordable
View more
207 fellow members joined KEBI Academy
+48 members in last 30 days

Article

This tutorial shows you how to create a simple report in SSRS.

First we need to create new SSRS Project. Open Business Intelligence Development Studio (BIDS) from start // All programs.

Select File Menu // New // Project…



New project window should appear. Ensure you have Business Intelligence Projects selected on the left side (Project types). Select Report Server Project from templates window.
Type name, select location, Solution Name usually is the same as project name and should be updated when you type project name (name text box). Click ok to create new SSRS project.

 

 

Now that you have new SSRS Project created you should be able to view its content in solution explorer pane which is usually located on the right side (If you displayed than click view on the main menu and click solution explorer).

Next step will show you how to setup Shared Data Source.
Data source contains a connection string which is used to connect to your source of data which in SSRS is usually a SQL Server database. "Shared" just means you can re-use it for different reports.

To set up shared data source in Solution Explorer pane right click "shared data soruce" and click "Add new data source".

See screenshot below.

To access members only content log in
or join KEBI Academy and unlock your potential

Just $8/month
Silver Membership
View more
7 Days Free Trial
Subscriptions only
View more
Fast Learning
made easy & affordable
View more
207 fellow members joined KEBI Academy
+48 members in last 30 days
Did you find this page useful?

+11  |  -0
(11 Votes)