Cascading parameter SSRS

I am now learning how to make a parameter dependable on another. I mean, without the other parameter he could never give the correct results.

So, I have a batch number that was issued to multiple suppliers. I want to be able to choose any distinct batch number (that will be our first parameter), and then depending on the number I have selected, to again be able to choose any suppliers that do belong to that batch number only. This second Supplier parameter, it is called a cascading parameter since it depends on the first Batch parameter.

So, the correct ingredient for this recipe would be to add a brand new dataset for any cascading parameter you create.

Off to create the new dataset! 🙂

Leave a comment