How to calculate Networkdays in report service

• gissah

  SSCommitted

  Points: 1815

  More actions

  December 27, 2010 at 9:21 am

  #232717

  I am trying to calculate networkdays in report service(VS08). What will be my best approach

  if I don't want to do it in the SSMS 08. Most of the samples I have read about were done in SSMS 05

  or report service 05.(Is there any tutorial on such topic available).

  Thanks

• Henry Treftz

  SSCarpal Tunnel

  Points: 4207

  More actions

  December 27, 2010 at 9:58 am

  #1266484

  Well, do you have a holiday calendar table someplace?

  If not you should be able to calculate the number of Mondays - Fridays in a SQL function. But that will include holidays that fall during those days.

  When you say you don't want to use SSMS or Reporting Services I am guessing you want to do it in T-SQL.

  You might want to take a look at this

  http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/