SSRS Report Builder Part 10.1 - Report Parameters and Filters

By Andrew Gould

Chapters
00:00 Topic List
00:35 The Example
02:58 Creating a Basic Table
04:08 Creating a Report Parameter
07:28 Referencing a Parameter in a Filter
09:50 Showing the Parameter Value in a Text Box
12:03 Dealing with No Rows
15:50 Using Date Parameters
20:51 Showing Date Parameters in a Text Box
22:52 Text Parameters and Wildcards
26:47 Concatenating Wildcard Characters
29:08 Formatting Dates in the No Rows Message

This video shows you how to create basic report parameters to filter tables in a report. You'll learn how to create numeric, date and text parameters, including how to use wildcard characters. You'll also see how to display parameter values in the report so that they will be included if the user chooses to export the report results, and how to display a message when the user input doesn't return any results for a table to display.

[CarlosFlores-kdrn]

Great tutorial, I am writing a report for my employer and needed a way to connect the parameters to the field values and return the result or a message for empty sets. This video showed me everything.

[amadeeyo]

Best learning channel in YouTube. Well done mate 👏 keep the up good work.

[emperatrizstredel]

Excellent. I like it a lot. The explanation is very clear and useful

[mathieudager]

Top-notch quality content @WiseOwl. Not exactly new to SSRS therefore Report Builder and/ or SQL. Nevertheless learning a ton. You have a new subscriber. Many thanks and Merry Xmas.

[wisherb]

The apology for The twilight movies being in the data @28:43 had me laughing.

[lemonlearner]

Hey, Your videos are quite amazing, i'm having a problem. I started to learning this and i don't really know how to do next thing, i have 2 parameters, StartDate and EndDate, What should I do if I want to know the information of a specific day? I mean, if i put the same date on StartDate and EndDate, The report isn't showing anything but there is data on that date.

[scotolivera]

Thank you sir, are considering creating a tutorial for c# or VSTO in the near future like the one created for VBA ?

[EVERSON_IAT]

Hi, thank u for this playlist, this change work results. I have a problem when use list selector, because the column is from same dataset that report. How can i solve it ?

[bhargavtej]

How to download RDL template form server and use in report builder??

[simonliebig]

I've already seen a lot of your videos. they are really great! However, I have a problem that I did not find in the videos. I have a table and two datasets. I display content via a lookup. now I want to filter the lookup using a parameter in the table after the second dataset. it is a value about open items. is an invoice paid, i.e. €0.00 or not paid. is it possible to filter by a lookup or are there other ways? many thanks for everything!

[broadenmymind]

- Firstly, I really appreciate your efforts, your videos are amazing, they help me a lot! Thank you!
- In additional to that, I'm facing a problem:
I want to calculate the difference of energy consumption between 2 particular months which are specified by PARAMETER. For instance, energy consumption in March is 30kWh and that in August is 50kWh so the result would be 50-30=20kWh. (I'm using stored procedure for data set)
- If you're interested in this matter, could you please give me a hint for this issue? Thank you once again!

[ylyrein]

Very nice tutorial although im having a hard time finding how to do the NOT like operator... I tried building some expressions and what not but always get an error :/ would appreciate your help mate

[BenjaminKohler-nqrm]

Have you ever tried filtering data out at the tablix/page level? I'm trying to filter out a list of string values that I'd like to have those rows excluded from that page's data.

[shubhamkupade]

if i want to see data without select pick start date and pick end date or not providing any default value for date is it Possible ?

[NurulFitriMYusoff]

Hi I trying to use the same method but unfortunately I keep received this (as per below) error for all my report. Appreciates if anyone can assists me on this

The report parameter 'QuotaRefNo' has a DefaultValue or a ValidValue that depends on the report parameter "QuotaRefNo". Forward dependencies are not valid.

The definition of the report '' is invalid.

An error occurred during local report processing.

[gsrinivas]

How can we pass a parameter value from main report to sub


Could you please help me with this

[michaelputnam]

Does this cover sorting the parameter list alphabetically? I have my parameters built, but the list is out of alphabetical order... sorry if this is a dumb question.

[ImiChitterman]

Only 5 minutes into your video and i just realised how much time i waste on other useless captions and vids.