Calculate previous business day based on Holiday table

[sajisher]

Hi,

There is a 'Holiday' table in SQL Server with holiday list for 2010.

In CR9 report, have to show AsOfDate as a previous business day which will be excluding holidays from this table and weekends.

This AsOfDate is placed in GH1 in report.

Should I create a subreport only with this Calendar table to calculate the previous business day and pass it to main report or use a stored procedure.

In any case, what will be the steps involved please. I am also looking elsewhere.

thanks

 

[Madawc]

A method for finding business days is set out at faq149-4466. From this, adjust for your holiday days.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[sajisher]

Thanks Madawc,

The link shows calculating number of business days between 2 dates.

I need to loop the holidays in the holiday table. Is there a ways I can do it crystal.

 

[Madawc]

Sorry, that makes no sense to me. Can anyone else help?

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP