SSRS Report Builder Part 10.4 - Optional Report Parameters

preview_player
Показать описание
By Andrew Gould

Chapters
00:00 Topic List
00:38 Creating the Data Source and Dataset
02:43 Creating a Table
03:44 Creating a Report Parameter and Filter
05:41 Allowing Blank and Null Values
07:43 Checking if a Parameter Is Null
11:09 Displaying the Filter Value in the Report
13:38 Creating More Parameters
15:36 Optional Numeric Parameters
16:25 Substituting the Minimum Filter Value
19:12 Calculating the Max Value of a Data Type
23:24 Editing the Placeholders
24:43 Creating Date Parameters
26:40 Entering a Specific Date Value
29:14 Using the Correct Date Format
31:32 Calculating the Current Date
34:28 Calculating a Date Relative to Today

This video explains how to create optional report parameters in SSRS Report Builder reports. You'll learn how to allow null values for report parameters and how to substitute the nulls with meaningful values in your filters. You'll also learn how to calculate the minimum and maximum values of a data type and how to calculate dates relative to the current date.

Рекомендации по теме
Комментарии
Автор

Unsure if Andrew is still around but just wanted to say a massive thankyou for your tutorials. They have helped me so much and often made my job less challenging and given me a sense of accomplishment when learning a new skill in SQL. You deserve all the success and praise that comes your way. Hope you are enjoying whatever life holds for you at present.

JC-KeepSmiling
Автор

Thanks Andrew, one of the best videos for Report Builder on YouTube. Can't thank you enough for your hard work and effort.

I am struggling to create a report with multi value parameters and pass a blank and null value. Can you please do a video as above on Allowing Blank and Null Values with Allow Multiple Values' option

johnburn
Автор

Thank you very much for these great videos. I am just wondering, what is the stored procedure would look like in SQL?

si
Автор

Amazing Mr. “Out of this world”👍🏼☺️. BTW, is it possible to substitute NULL word with a local language word (term). As you know normal people who are supposed to use reports don’t have an idea about such expressions, same thing goes for “View report” button caption.
Thank you again 🙏🙏.

abdullahquhtani
Автор

Hi, Is it possible to use single (parameter contains values from multiple columns like name, ID etc ) to filter the report, using report level parameters ? If possible how ?

srinivasbestha
Автор

Hi Andrew. Are you able to show row level security. How we can set filters depend of logged user?

lujimed