Scheduling issue - new fiscal calendar not based on calendar anymore.

[bessebo]

My company was recently acquired by a much larger company and it just so happens that the acquiring company closes every month on the last Friday of the calendar month. So, as you can imagine, this could cause an issue with scheduling of month-end reports since we previously just ran the reports on the last day of each calendar month. Now I have to run them on the last Friday of every month. We are using Crystal Enteprise 9 and it doesn't look like I have the ability to schedule in this manner. Is there a way in Crystal Enterprise 9 to do this? Is there a way to do this in Business Objects XI Release 2?

Regards,
Bessebo

 

[lbass]

I'm not familiar with CE, so don't know if this would be helpful, but if the issue is partly how to calculate the last Friday of a particular month, then this is a formula to calculate that:

datevar lastday := dateadd("m",1,{table.date}-day({table.date})+1)-1;
datevar lastFri;

if dayofweek(lastday) = 6 then
lastFri := lastday else
if dayofweek(lastday) = 7 then
lastFri := lastday -1 else
if dayofweek(lastday) < 6 then
lastFri := lastday-dayofweek(lastday)-1

-LB

 

[MJRBIM]

You can do it in BOE-XI (R2) by scheduling based on a "Custom Calendar" - don't think that option goes back to CE-9 (maybe CE-10).

 

[bessebo]

OK. That is what I really wanted to hear. So this gives me impetus to get BOE-XI up and running as soon as I can. It is strane because Seagate Info had the custom calendar capability but CE 9 doesn't. Thanks for your help.