How to create a dynamic data parameter

See more:

SSRS

Hello, I am developing a report in SSRS which has the 3 parameters listed below

1) Report Period

2) Startdate

3) Enddate

My finalreport should be looking this way when the user selects the report period the startdate and end date should automatically take the parameters based on the period selected.


My report period contatins this items and start date and enddate are different for each period selected. So when a user select the differenct items the remainng 2 parameters should get changed automatically. For this i have created a data set for the time period, startdate and enddate separately. But after that i am totally struck without having the idea how to connect the report period to startdate and enddate parameters. If any would suggest it would be of real help. And for the last row custom date when user selectd that report period i should show them a calendar prompt where they can select the custom date according to their choice.

Please suggest with a solution.



Appreciated your help!!



THANKS IN ADVANCESmile | :)

What I have tried:

In MICROSOFT BI SSRS i need to give the cascading parameters in runtime based on user inputs on which the 2nd and 3rd parameter are dependant on 1st parameter