Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Learn SSRS in 28 Days

by suresh

SQL Server Reporting Services, shortly called as SSRS is one of a trending reporting tool in the market. Although it is the most powerful reporting tool, you can quickly learn SSRS in 28 days (Maximum).

Prerequisite: You cannot learn SSRS by merely reading this blog. You have to practice every chart or report by yourself. If you practice multiple times, you can master this reporting tool. So first, Download and install BIDS, or SQL Data Tools. Next, Download and attach the AdventureWorks and AdventureWorksDW database.

How to Learn SSRS in 28 Days!

SSRS is all about Data Sources, Datasets, and Reports. This article shows you how to learn SSRS step by step.

Learn SSRS Data Sources, and Datasets

The first day, Learn everything about the Data Sources and Datasets.

  1. New Project
  2. New Report
  3. Shared Data Source
  4. Shared Dataset
  5. Embedded Data Source
  6. Embedded Dataset
  7. Combine Two Datasets

Learn SSRS Basic Reports

The next two days concentrate on creating Basic Reports.

  1. Table Report
  2. Matrix Report
  3. Create a Report using SQL Views
  4. Create a Report using SQL Stored Procedure
  5. Display Image in Report
  6. Add Text Box to Report
  7. Rectangle in a Report
  8. List Report

Learn SSRS Report Formatting

Learn about the formatting options in the next four days.

  1. Grouping in Table Report
  2. Row Groups & Column Groups in Matrix Report
  3. Add Totals, and Subtotals to Reports
  4. Add, Or Remove Headers and Footers on Reports
  5. Global Variables to Report
  6. Export Reports to PDF, XML, Excel, Word
  7. Format Table Report
  8. Change Font and Background Color of a Text Box
  9. Format Numbers in a Text Box
  10. Format Date and Time in a Report
  11. Repeat Headers on Each Page
  12. Headers Visible While Scrolling
  13. Filters at Tablix Level
  14. Filters at Dataset Level
  15. Sorting Data at Tablix Level
  16. Interactive Sorting
  17. Add Alternative Row Color to Report
  18. Add Row Numbers to Report

Learn SSRS Charts

Next, eight days is all about Charts. I don’t think; you need seven days to understand the charts.

  1. Area Chart
  2. Bubble Chart
  3. Column Chart
  4. Format Column Chart
  5. Data Bars
  6. Data Bars in Matrix Report
  7. Formatting Data Bars
  8. Funnel Chart
  9. Radial Gauges
  10. Linear Gauges
  11. Format Gauges
  1. Indicators
  2. Format Indicators
  3. Line Chart
  4. Pie Chart
  5. Format Pie Chart
  6. Pyramid Chart
  7. Radar Chart
  8. Range Chart
  9. Scatter Plot
  10. Sparklines
  11. Stacked Bar Chart

By the 16th day, you know everything about Data Sources, Datasets, Basic Reports, and Charts.

Learn SSRS Advanced Reports

From 16th to 21st, concentrate on Advanced reports, and Parameter reports.

  1. Add Custom Code inside a Report
  2. Calculated Fields
  3. Dashboards
  4. Document Map
  5. Drill Down Reports
  6. Drill Through Action
  7. Matrix Drill Down
  8. Go to URL Action
  1. Lookup
  2. Page Breaks
  3. Subreports
  4. Report parameters
  5. Drop down list Parameters
  6. Multi Value parameters
  7. Multiple Parameters
  8. Cascading Parameters

Learn SQL Server Report Manager & Deployment

Spend the next five days (22 to 26) to learn SSRS Report Manager and about the deployment process.

  1. SQL Server Reporting Services Configuration Manager
  2. Change Report Manager Title
  3. Deploy Reports using BIDS
  4. Deploy Reports using Report Manager
  5. Create Shared Data Source in Report Manager
  6. Cached Reports
  7. Linked Reports
  8. Report Parts
  9. Report Snapshot
  10. SQL Report History Snapshots
  11. Security
  12. Subscriptions
  13. Upload Text, PDF, and Image to Report Manager

Learn SSRS Report Builder

Use those extra two days to learn SSRS Report Builder.

  1. Install Report Builder 3.0
  2. Create a New Dataset using Report Builder
  3. New Table, or Matrix Report using Wizard
  4. Table Report Without Wizard
  5. Pie Chart using Wizard
  6. Bar Chart without a Wizard

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy