SSRS Report Builder Part 10.3 - Default Values for Parameters

By Andrew Gould

Chapters
00:00 Topic List
00:36 Creating the Data Source and Dataset
02:39 Creating a Table
03:31 Creating a Query Parameter
05:40 Adding a Basic Default Value
07:05 Adding More Query Parameters
08:38 Basic Numeric Default Values
10:15 Calculating the Max Value of a Data Type
12:23 Calculating the Min Value of a Data Type
13:16 Attempting to Calculate the Max Value of a Field
16:07 Getting the Max Value from a Dataset
17:48 Getting the Min Value from a Dataset
19:31 Creating Date Parameters
21:20 Entering Specific Default Dates
22:56 Calculating Min and Max Dates in a Query
24:55 The DateTime Data Type in SQL Server and .NET
28:02 Calculating the Current Date

In this video you'll learn how to assign default values to parameters in SSRS Report Builder to save time when viewing your reports. You'll see how to enter specific default values for text, numbers and dates. You'll also learn how to calculate the maximum and minimum values of a data type, as well as the maximum and minimum values of a field in a dataset. Finally, you'll see how to create expressions to set the default values of date parameters relative to the current date.

[JoelNove]

@Andrew wow. After all the hours spent on how to set my date parameters default to the max date or entity list to show correct list you have done it. Thank you for posting, Much appreciated!

[foxybark]

All this many years, you're still posting these helpful videos. Thank goodness. I've been watching these off and on for years. One question that I'm sure you've covered somewhere. How can I set the multivalue parameter to default to "Select All"? In other words, I want all the values selected when the report is initially opened. Thanks in advance.

[mikeb]

Love these videos. Wondering if you have ran into the problem I'm currently having. If I want to use the wildcard character % as a default to select All, I have to use the "LIKE" query command in the dataset query or filters (As you explained in this video). If I want to select multiple values from the parameter I have to use the "IN" query command and make sure to remove the [0] from (As you explained in another video). I'm unable to display all rows by default but then choose to display multiple of the same parameter. Thanks in advance

[phillipk]

Thanks for the earlier reply!. Awesome!. Is there a way to make the Select All to be selected in the Parameters. The query pulls all the values but I like it to show the it to be the Default. It shows but the user have to select it.

[tejamarneni]

Hi. Thank you for amazing videos. Is there a plan to show C# videos?

[pieterretief]

Awesome video, as always. Thank you. I have two date parameters that need to be hidden. When I select a financial month from a drop-down then the start date for that financial month must be populated automatically. When the start date is not hidden then the auto population takes place, but when the start date is hidden then I have to click on "View Report" in order for the next prompted field to be populated. What I am I doing wrong. Where should I start looking?

[nickniccolo]

Really thank you for these life saving videos. I have one question regarding the default dates, is it possible to make the start date change dynamucally when the user enters a different end date?

[jiajiajia]

Hello, how parameters interact with each other?