Reporting Services (SSRS) Part 14 - Cascading Parameters

[@timb9999]

This is the best SSRS 2012 training you can get on line! Very clear and concise. If you want to learn SSRS spend your time here!!

[@Abdikaaf]

I HAVE WATCHED SEVERAL OF YOUR VIDEOS AND I CAN’T THANK YOU ENOUGH FOR YOUR HELP. DEFINITELY YOU DESERVE NOBLE PRIZE..!!!

[@alxvseti]

00:42 What are Cascading Parameters 01:38 Understanding the Database 03:06 Creating the First Dataset and Parameter 05:21 Creating and Filtering the Next Dataset 07:18 Creating the Next Parameter 08:48 Creating the Table of Results

[@marioprinceton1173]

you all prolly dont care but does anybody know of a tool to get back into an instagram account?? I stupidly lost the login password. I would love any assistance you can offer me

[@kaysonjameson6844]

@Mario Princeton instablaster =)

[@marioprinceton1173]

@Kayson Jameson i really appreciate your reply. I got to the site thru google and Im waiting for the hacking stuff now. Seems to take a while so I will reply here later with my results.

[@marioprinceton1173]

@Kayson Jameson It did the trick and I finally got access to my account again. I am so happy! Thank you so much you saved my account !

[@kaysonjameson6844]

@Mario Princeton You are welcome xD

[@mbourgon]

THANK YOU for this - I'd been staring at stackoverflow's answer for 30 minutes trying to get it to work. Got it in one with this. If you're ever in Texas, I owe you a pint!

[@krismaly6300]

Revisited and I liked this video to learn Cascading Parameters. I recommend other to watch. Thanks for educating the community.

[@nuthouse99]

Outstanding - very clearly presented - thank you.

[@waterbitten]

very, very, helpful.. the DB structure was really helpful.

[@pandarikkal]

Really enjoyed. very effective.

[@PhillipLearnTeach]

Is there a way to show or repeat row a Grouped column in Report builder 2022 (same as SSRS). Somehow once grouped it is hard to do so...

[@Andy1Abel]

Thanks! I have a report with cascading parameters, but I'd also like to be able send a URL of that report to someone by specifying the parameters in the URL i.e. URL.... &param1=123 Is there a way to do that for a report that has default values and cascading parameters?

[@abhitri87]

Very nice and well presented...

[@krismaly]

This is an interesting video. I enjoyed. Where can I find movie database for my practice? Thanks a lot

[@amjadzahir]

Thanks for the Tutorial....In the last data set DtsActorRoles when i add two table "tblActor and tblCast there were NO relation between ActorID and CastActorID so i got a prompt that there is no relation between two table and the results would be unexpected....so i just copy the Sql query from you tutorial into my project and it worked but i don't why the relation wasn't there in the first place......

[@plekkchand]

same question here

[@tsevered6535]

For this example, if I were to select multiple directors and have the films drop down contain all of the films from the multiple directors selected, how could I achieve this?

[@danesneider]

Really Helpful, Thanks!

[@ben.reddington]

Your videos are very informative, concise and well scripted with almost no Err's and Hmm's, "Don't know why this isn't working" and such. Free from a professional training website so thanks for that! Back in the day I used to program cascading filters in .NET using two datasets, however, is there a trick to make that work using only one dataset?

[@bliver1023]

Hello. Thank you very much for the informative tutorial on cascading parameters! Is it possible to make each of the parameters searchable by typing values like the dataset? Ex. Type "Steven" and "Steven Spielberg" or any other "Steven" is the only result that appears in the dropdown as a multi-value select. If you could post a video on that, if it's even possible, it would be very helpful.

[@smky765]

Hello , I did the same way as you have mentioned, but I am getting the error saying "Must declare the scalar variable @parametername". Please let me know how to resolve this error. Thank you.

[@foxybark]

Hello. I wonder if there is a way to have one set of parms feed into another automatically? For example, DS1 has a year and month parm, both visible. DS2 has an identical year and month parm, hidden. Is there a way to have the parms from DS1 feed into the parms for DS2 instantly? So when the report is ran both DS1 and DS2 tables are filtered instantaneously?

[@foxybark]

Interestingly enough, there was some movement with your suggestion. The DS2 appeared to give me the desired results. However, it completely jacked up my DS1, which was previously working properly. Hmmm!

[@foxybark]

Were your parameters query parms or report parms?

[@foxybark]

Yep, that's right. I'm just wondering why it worked for you and not for me. Let me keep trying.

[@vinodkv8296]

Hi, How can I pass multiple values to a call report parameters

[@lmadeti]

Hi..ur videos r very helpful. thanks for ur efforts. am trying to practice Cascading Parameters.But when am creating the third dataset for tblCast and getting an error....In the last data set DtsActorRoles when i add two table "tblActor and tblCast there were NO relation between ActorID and CastActorID so i got a prompt that there is no relation between two table and the results would be unexpected....why it is showing there is not relationship btw these two tables...bcoz am using the same database that u r using...for u in the video it shows the relationship..but for me...no...I tried many ways...plz help me am stuck here.

[@ahmadbahrami9437]

Just copy this in the query box in dataset properties: SELECT tblCast.CastCharacterName, tblActor.ActorName, tblCast.CastFilmID FROM tblActor INNER JOIN tblCast ON tblActor.ActorID = tblCast.CastActorID

[@emiliovega3602]

I have 2 cascading parameters: Category and Subcategory to show a details list of products. Some products not fit in any category and subcategory. How can I show them?

[@emiliovega3602]

Thank you, I will try, but depend of amount of product this could be very tedious.

[@devidodge]

Thanks for this vid, really helps! Quick question, how do I enable cascading parameters for data that is all present in one 'denormalised' table? ie say if all the columns were available in 1 table so there's no need to reference different tables through ID's etc? Any small clue would help. BTW Thanks for all of the vids so far, please keep em coming!

[@devidodge]

***** ahhh, that was so obvious it was just 2 clicks and done and working. Thanks for the quick reply, and also thanks for all your tuts mate. big fan!!!!!

[@emiliovega3602]

Thank you good idea. I was thinking in doing something at dataset level

[@MrBenix181]

Perfect example

[@dianestillwell-dhume194]

Is this possible? I would like to have a parameter that accepts a unique value and the report is generated based on this value. However, if the user doesn't know the unique value, I would like to use cascading parameters to filter down to the unique value. How can I make the unique value parameter independent from the cascading parameters? Does this make sense?

[@dianestillwell-dhume194]

Nevermind responding to this question. I am trying a different approach...linked reports. :-)

[@dianestillwell-dhume194]

I watched the video after I posted the question and it became clear to me! Thank you for your videos. They have been tremendously helpful!

[@jhtrico1850]

Cool :) What if they know the film but not the director though?

[@tanmoyhalder7397]

Hey! Nice tutorial. Thanks Wise Owl. Can u provide me a back up file of the Data Base?

[@DarkShadowAy]

Ditto! Thank you!

[@superfreiheit1]

sample data download?

[@DharmYogi]

thank you

[@mokhot]

good video but the volume is a bit low

[@aravindv3927]

very Informative Thanks for sharing