I'm trying to calcucate duration between 2 date sets using paramters.
1. I do have a stored procedure with 2 filter sets. End date and duration.
2. Created SSRS report with 2 filter sets. End Date and Duration. It worked fine.
3. Customer wants to use Start date and End Date as filter. (I cannot modify stored procedure)
4. I created a dummy parameter for Start Date.
5. Duration default expression as
6. This works as I expected but when they change any date or other parameters, duration calculation does NOT update.
Why it is not updated?
View Complete Post