CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008ssrs-2008-r2
Aniruddha
Aniruddha

Reputation: 11

How to change date parameter value depends on another date parameter value in SSRS report

I have one date parameter which will be change by user. From that date parameter i have to calculate local timezone show in another date parameter.

I have used second parameter date in data set query to filter data. I am not getting how to reflect change of date from first parameter into second parameter in SSRS report.

enter image description here

Upvotes: 1

Views: 827

Answers (1)

NiveaGM
NiveaGM

Reputation: 259

You can follow the below steps to get the second parameter use the calculation based on first parameter

In the 2nd parameter Properties -->Available values-->Specify values--> ADD -->Click on fx in label and value and from category you will be able to select your parameter--> double click on the 1st date parameter and you can type in the calculation you need for the 2nd parameter.

Upvotes: 1

Related Questions