Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: MonthToDate: looking for WeekToDate Post Reply Post New Topic
Author Message
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Topic: MonthToDate: looking for WeekToDate
    Posted: 21 May 2007 at 12:56am
Hello again,
 
1) For the Select Expert the function "MonthToDate" works nicely.
However, I need the same kind of function like "WeekToDate".
It doesn't seem to exist. "Last7Days" exist, but that is not the same obviously :)
 
2) Weekdays start at Monday here. CR XI defaults to Sunday.
I made two groups: per week en per day. Per weeks should start at Mondays: how do I do that?
 
 
IP IP Logged
ajoyp2
Newbie
Newbie
Avatar

Joined: 19 Feb 2007
Location: India
Online Status: Offline
Posts: 3
Quote ajoyp2 Replybullet Posted: 23 May 2007 at 7:33pm
As for your first question you can use WeekofYear formula to get the Report for current week .You need to download the ufl file (Ufldate.exe)  from BO ( http://technicalsupport.businessobjects.com) .After than you can create a formula using WeekofYear to extract Current Week's data but again it 'll start from Sunday as its a Crystal function.
IP IP Logged
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Posted: 01 Oct 2007 at 2:55am
Thank you.
 
But how do I let Crystal Reports start the week with Monday instead of Sunday? In a basic cross table for example.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.012 seconds.