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!
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
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
@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.
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?
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.... ¶m1=123 Is there a way to do that for a report that has default values and cascading parameters?
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.
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......
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?
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!
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.
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!
***** 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!!!!!
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?
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?
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.
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
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?
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!!
I HAVE WATCHED SEVERAL OF YOUR VIDEOS AND I CAN’T THANK YOU ENOUGH FOR YOUR HELP. DEFINITELY YOU DESERVE NOBLE PRIZE..!!!
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!
Revisited and I liked this video to learn Cascading Parameters. I recommend other to watch. Thanks for educating the community.
Outstanding - very clearly presented - thank you.
very, very, helpful.. the DB structure was really helpful.
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
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
@Mario Princeton instablaster =)
@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.
@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 !
@Mario Princeton You are welcome xD
Very nice and well presented...
Really enjoyed. very effective.
Perfect example
Really Helpful, Thanks!
Thank you good idea. I was thinking in doing something at dataset level
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?
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...
thank you
Ditto! Thank you!
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.... ¶m1=123
Is there a way to do that for a report that has default values and cascading parameters?
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.
This is an interesting video. I enjoyed. Where can I find movie database for my practice?
Thanks a lot
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......
same question here
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?
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!
Were your parameters query parms or report parms?
Yep, that's right. I'm just wondering why it worked for you and not for me. Let me keep trying.
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.
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!
***** 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!!!!!
Hi, How can I pass multiple values to a call report parameters
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?
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?
Thank you,
I will try, but depend of amount of product this could be very tedious.
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.
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
very Informative Thanks for sharing
Hey! Nice tutorial. Thanks Wise Owl. Can u provide me a back up file of the Data Base?
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?
Nevermind responding to this question. I am trying a different approach...linked reports. :-)
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!
Cool :) What if they know the film but not the director though?
sample data download?
good video but the volume is a bit low