Post reply

Datetime Parameter Question

  • April 11, 2014 at 7:48 am

    #292265

    Is it possible to change the value of a datetime parameter depending on the value of another?

    Basically I have a Parameters!FromDate.Value = yesterdays date (EG '2014-04-10')

    I have another parameter called Parameters!WeekStart.Value which equals the start of the current week (EG '2014-04-07').

    When I go to run the report and change FromDate to say '2014-04-02' I want the WeekStart value to change '2014-03-31'.

    Is this possible?

  • April 11, 2014 at 7:54 am

    #1705300

    What you want to do is called Cascading Parameters and if you have a look at this article[/url] it'll explain it better than I can.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • April 11, 2014 at 8:05 am

    #1705306

    Thank you! It was so simple in the end.

  • April 11, 2014 at 8:15 am

    #1705317

    You're welcome. It's not actually something I've got personal experience of using but several of the reports our company run use them. I'm waiting for a chance to try it out myself!

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply