Solved

Crystal Reports Group by week label

Posted on 2009-07-16
4
307 Views
Last Modified: 2012-06-27
I have a date grouped by week. How do I display the week value. Like 7/12/09 to 7/18/2009?
I tried something like this but it wants a date for the datedadd function.
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,GroupName{Command.SENT_DATE}, "weekly") )

Open in new window

0
Comment
Question by:cobolinx1
  • 2
4 Comments
 
LVL 5

Expert Comment

by:jgbreeden
ID: 24870218
if the group name is a properly formatted date, you could use CDATE(GroupName{Command.SENT_DATE}, "weekly")) inside your DateAdd formula
0
 
LVL 18

Expert Comment

by:UnifiedIS
ID: 24870250
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,CDATE(GroupName{Command.SENT_DATE}, "weekly") ))
0
 

Author Comment

by:cobolinx1
ID: 24871015
It gives me the error "the ) is missing" on {Command.SENT_DATE} in the dateadd function
0
 
LVL 18

Accepted Solution

by:
UnifiedIS earned 500 total points
ID: 24871092
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,CDATE(GroupName({Command.SENT_DATE}, "weekly") ))
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question