sql - Microsoft Report Builder - Using Parameter in Expression

Question

When you have a report in Microsoft Report Builder that has a FromDate and ToDate for parameters, is there a way to display the current year of one of those parameters? Also, to take the current year from the parameter and subtract 1?

Currently the cells use the expressions:

=year(today())

=year(dateadd(dateinterval.year, -1, today()))

Instead of always looking at the current year and the previous year I want to display the year from the FromDate parameter and the previous year of the FromDate. Is there a way to do this?

question from:https://stackoverflow.com/questions/65603028/microsoft-report-builder-using-parameter-in-expression

Answer 1

Waitting for answers