SSRS Report Builder Part 13.3 - Indicators in a Matrix

Показать описание

In this video you'll learn how to add indicators to a matrix. You'll see how to choose a set of icons, understand how Report Builder calculates the bands used to display each icon, learn how to control the numeric bands and create indicators for row and column total cells.

Chapters
00:00 Topic List
00:33 The Example
01:34 Creating a Data Source and Dataset
02:50 Creating a Basic Matrix
05:46 Inserting a Column Inside a Group
06:48 Adding an Indicator to a Matrix
07:39 Assigning a Field to an Indicator
08:48 How Report Builder Decides Which Icon to Use
10:20 Setting Numeric Bands for Indicators
12:11 Choosing Colours and Icons
13:17 Adding a Total Column to the Matrix
13:56 Creating an Indicator for the Total Column
15:10 Creating a Total Row
15:54 Adding an Overall Average
16:49 Formatting Cell Borders
17:54 Formatting the Total Column and Row

Рекомендации по теме

Комментарии

Very informative. Thank you for this wonderful video.

RohithKK-uhpp

I know report builder and visual studio are similar, is it possible to follow this playlist but using visual studio and I understand there are slight differences between the two. Thanks for the video, best sql online resource.

Alex-hntx

Hi Andrew, thank you for the amazing videos. I have a quick question, are there any new SQL videos coming up? If so, can you make one video about Windows Functions such as Rank, DENSE_RANK and ROW_NUMBER ?

tejamarneni

And I v got something to add. I tried to do that with data which start lay between 0.0 and 1.0, like 0.567; 0.899. I tried to use numeric interval for indicator. And 'd like to tell that it doesn't work. It began work than I multiply by 100 and rounded, so than the border became 10 instead 0.1

Roman-txqv

then u managing matrix, why first put genreid and then replace with genre... could it be easier simply put genre alone?

Roman-txqv

Do you know any free version online of SQL database?

shinrafahell

SSRS Report Builder Part 13.3 - Indicators in a Matrix

Reporting Services (SSRS) Part 13 - Null Values in Parameters

Indicators In Power BI Paginated Report or SSRS - TAIK18 (13-3) Power BI

SSRS Report Builder Part 11.3 - Multi Value Parameters

SSRS Using Group By Part 13

Calculated Fields in SSRS - Part 13

SSRS Report Builder Part 7.12 - Lookup, LookupSet and MultiLookup Functions

SSRS Report Builder Part 10.3 - Default Values for Parameters

SSRS Report Builder Part 6.8 - Creating a Basic Matrix

SSRS Report Builder Part 10.4 - Optional Report Parameters

SQL Report Builder 3.0 Gauges in SSRS 2008 R2

SSRS 13 Charts By Bhaskar Reddy Baddam

SSRS Report Builder Part 11.4 - Multi Value Parameters and Null Values

SSRS Tutorial 13 - Use Query Builder Features in Report Wizard to create SQL Query for Report

SSRS in Amharic Part 3-Creating Basic Reports

SSRS Report Builder Part 7.10 - Calculating First, Last and Middle Names

SSRS (13) Gauge and Indicator | MSBI - SSRS - Gauge and Indicator Reports

SSRS Report Builder Part 10.4b - Optional Report Parameters Alternative Approach

Report Builder 3.0 for SQL Server 2012 Part 9A: Create your first dashboard

SSRS - Creating Your First Report using Report Builder - Part 2

SSRS Part 5 Demo1 - Configuring Report Caching.mp4

SSRS Tutorial Part 119.3 - How to create Map Reports in SSRS (ESRI Shapefile)

Control Row Height in SSRS - Part 11

Fundamentals of Report Builder Part 5 - Sub-Reports

SSRS Report Builder Part 4.7 - Entering and Copying Data into a Report