SSRS Evaluating an expression used to set default parameter value

Question

I have this expression to set the parameter default values - how can I evaluate it without running the report?

=DateAdd(DateInterval.Month, -1, DateSerial(Year(Date.Now), Month(Date.Now), 1))

Answer 1

Hi,

For this expression :
=DateAdd(DateInterval.Month, -1, DateSerial(Year(Date.Now), Month(Date.Now), 1))

Since it doesnot evolve any data fields, I think you could directly run it in any Visual Basic test environment.

You could put this expression in a textbox in the report builder or visual studio report , then run the report to see the value.

Regards,
Lukas

Answer 2

I don't believe you can run expressions outside of a report. If I ever have to test a complex default expression I create a temporary test report with just the parameters I need then drag those parameters onto the report canvas so I can see their values.

Answer 3

Thanks Darren - that makes sense.