Solved

Crystal Reports Group by week label

Posted on 2009-07-16
4
302 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
Comment Utility
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
Comment Utility
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,CDATE(GroupName{Command.SENT_DATE}, "weekly") ))
0
 

Author Comment

by:cobolinx1
Comment Utility
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
Comment Utility
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,CDATE(GroupName({Command.SENT_DATE}, "weekly") ))
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now