SQL Server Reporting Services - SSRS (online)

• Visual Studio and SQL Server Data Tools
• Solutions and projects
• The Visual Studio environment

• Authoring a report
• Using report items
• Selecting and formatting report items
• Number formats

• Shared data sources
• Shared versus embedded datasets
• Using Query Designer

• Structure of a table
• Formatting tables
• Inserting rows
• Interactive sorting
• Repeating page headers

• Using the grouping panes
• Row and column groups
• Displaying subtotals
• Outlining

• Calculated fields
• The ReportItems collection
• Using built-in fields
• Conditional formatting using expressions

• Page headers and footers
• Pagination between groups
• Header and footer expressions

• Using query parameters
• Creating drop lists
• Multi-value drop lists
• Formatting using parameters

• Creating indicators
• Changing the symbols displayed
• Stopping indicators stretching

• Creating and formatting gauges
• Gauge panels
• Pointers, scales and ranges

• Areas of a matrix
• Sorting and grouping matrices
• Creating and formatting subtotals

• The areas of a chart
• Creating charts
• Formatting charts

• Need for a grouped row
• Creating data bars
• Creating sparklines

• Creating and formatting lists
• Grouping using lists
• Using rectangles in lists

If time

• Creating a child report
• Creating the main report
• Creating and formatting subreports

• Parent and child reports
• Creating actions
• Passing values to a child report

If time

• ESRI shapefiles / SQL spatial data
• Linking to datasets
• Map layers
• Center points and point layers

• Setting the target server
• Deploying an entire project
• Deploying single reports

• Browsing to the web portal
• Viewing reports
• Managing reports

If time

• Creating a KPI
• Installing Mobile Report Publisher
• Creating a mobile report

If time

• How subscriptions work
• Creating a new subscription
• Managing subscriptions