Home Forums SQL Server 2005 Business Intelligence set default value of date paramter as getdate()-1 in SSRS report RE: set default value of date paramter as getdate()-1 in SSRS report

  • March 10, 2016 at 1:03 pm

    #1864383

    rcooper 78099 (3/10/2016)

    unfortunately I do not have those options see screen shot attached.

    Luis Cazares (3/10/2016)

    rcooper 78099 (3/10/2016)

    =DateAdd("d",-1,Today())

    I am assuming it would be

    =DateAdd("d",+1,Today())

    or

    =DateAdd("d",1,Today())

    which have both not worked.

    What do you mean by have not worked? How are you assigning the default value?

    I just tested both approaches and they work.

    Can you share more details?

    Now I see, you can't use expressions from the SSRS site. You need to be able to open the report in a designer to be able to use expressions.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2