Mastering SQL Server Reporting Services (SSRS) From Scratch

Learn to build reports with the list data region in SSRS from scratch, using a free-flow layout, shared datasets, and page breaks for invoice-like paging.

Master mail merging in SSRS using the List data region to generate customer letters from a shared dataset, including name, address, city, postal code, country, phone, and fax.

Learn to use the image control in SSRS by embedding a logo into the report header, storing image data in the RDL, and displaying it across pages.

Discover how to work with external images in SSRS by configuring image sources from web or file URLs, and compare with embedded images for reliable rendering.

Display product information with data bound images in SSRS by joining product and photo tables via a shared data source, rendering thumbnail and large photos.

Create expressions in SSRS to build computed columns like total price and discount from the adventure works product dataset and filter where list price and standard cost are not zero.

Learn to use the IIF function in SSRS to display price-based comments, showing 'expensive product' when the list price is above 100 and 'affordable' otherwise.

Learn to use the switch function in SSRS to evaluate multiple conditions based on list price, replacing nested ifs with clear statuses like good, excellent, and poor.

learn to write and call custom vb.net functions in ssrs by adding code in report properties, enabling complex calculations like a sales tax on list price.

Create a grouped SSRS report with subtotals using the wizard, displaying data from the Northwind employees table grouped by country, region, and city in a tabular layout.

Demonstrates manual grouping in SSRS by building a tablix with country, region, and city groups and adding country, region, and city subtotals using COUNT of employee IDs, with styling.

Learn to create running totals for each order ID in SSRS by using the running value function with the Sales Order ID group, showing per-group totals and the grand total.

Explore built-in fields in ssrs to display page numbers, total pages, and group-specific counts in report footers, and reset page numbers per group with the color as the page name.

Create a parameterized SSRS report using the AdventureWorks Production.Product table, adding a dataset and a color parameter @color to dynamically filter results by product color.

Create a drop-down parameter by adding a distinct colors dataset from the products table, then bind it to the color parameter to populate the dropdown and filter the report.

Learn to create multi-valued parameters in ssrs by enabling multiple values, binding available colors from dataset, and updating the query to color in (@colors) to show products across selected colors.

Create an unbound parameter in ssrs to let users enter a tax percentage and dynamically calculate tax on total due, unlike bound parameters that affect the select statement.

Learn to implement parameterized sorting in ssrs by using an unbound parameter to choose the sort column at runtime and a dynamic expression driven by a dropdown.

Learn how to implement parameterized sorting in SSRS by adding a sort order parameter and building a dynamic query that sorts by a chosen column in ascending or descending order.

Create a sql server reporting services report using cascading parameters with three linked drop-downs for country, region, and city; build datasets and test filtering in northwind.

Learn how to create and use boolean parameters in SSRS by building a parameterized report that filters the Production.Product make flag with true or false radio buttons, showing dynamic results.

Learn to implement interactive sorting in SSRS by enabling text box properties for Country, Region, and City, allowing users to sort at runtime in the report preview.

Enable interactive sorting and grouping in ssrs reports by configuring text boxes and nested tablix regions across country, region, city, and employees.

Learn to implement drill-down reports by grouping country, region, and city in a tablix and toggling visibility to expand details from the Northwind employees dataset.

Demonstrates dynamic column visibility in ssrs by using unbound boolean parameters to show or hide first name and last name columns in a tablix.

Learn to apply conditional formatting in ssrs by using an expression to color rows based on list price in a tablix, highlighting values above 1000 with blue.

Explore how to repeat and freeze column headers in SSRS tablix reports: set Repeat on new page to true and Fixed Data to true via the static column group properties.

Learn how to create and use bookmark actions in SSRS to navigate a report, add subtotals for each sales order, and link text boxes to bookmarked locations.

Master the go to URL action in SSRS to navigate to an external website from a report by clicking a linked text box.

Create a matrix report in SSRS from scratch using the wizard, join six tables to compute total sales (unit price times quantity), and group by employee and year, with preview.

Create a matrix report from scratch with multiple row and column groups, add subtotals and grand totals, and work with an embedded dataset and Northwind data source.

Learn how to create multiple column groups in SSRS reports, arranging year-wise and category-wise sales in a matrix, adding subtotals and grand totals, and customizing with colors.

Learn to build SSRS report with a matrix data region showing multiple columns in data cells, row and column groups, totals, and headings for sales by employee, year, and category.

Illustrate building a matrix report in ssrs with embedded data, then implement a gauge control to display a date- and category-wise sales KPI as a linear indicator.

Use the kpi indicator control to display stoplight indicators for subcategory sales and sum of sales, with states 0-33, 33-66, 66-100, synchronized across the tablix data region.

Assemble a data bar and spark line in a SSRS report, drag and drop tools, show data labels, and preview indicators that communicate sales trends clearly.