Wednesday, 15 June 2011

Expressions - Following Monday

=DateAdd("d",(8-Weekday(today(),0)),today())

 The above expression will return the following Monday from Todays Date.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Keep SSRS (SSRS2016) report manager awake

When running a report for the first time in report manager it takes a while to run, after this initial run reports run fine.  There are a ...

  • Subscriptions SQL query
    Due to the fact the reporting services allows you to query the tables you can easily write SQL which will allow you to return data from the ...
  • Conditional Page Breaks in SSRS 2008 r2
    I have recently been looking at conditional page breaks in SSRS 2008 r2 and did not know that it is possible to do via an expression. For...
  • Alternate Colors in a Matrix/Pivot Table
    To add alternate colors in a matrix the expression should be as follows for the row group: =IIf( RunningValue (Fields!FIELDNAME.Value, Co...