?
Solved

Crystal reports break down by week

Posted on 2013-11-07
2
Medium Priority
?
620 Views
Last Modified: 2013-11-07
I have a couple months worth of data that I want to break down by week?  I know to break it down by month I would use something like this
if totext({ArInvoice.InvoiceDate}, 'MM-dd-yyyy') startswith "01" then "January" else

,but not sure about breaking it down into weeks.
0
Comment
Question by:TomBalla
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39631259
Crystal provides an easy way to do it.

Group on the date field
When you group on a date field you get the option to group on a period.  Just choose WEEK

ANother way is to use DatePart

DatePart ("ww",{DateField})  returns the week number.

You can also use DatePart("m",{DateField}) to get the month

MOnth({DateField}) also returns the month

mlmcc
0
 

Author Closing Comment

by:TomBalla
ID: 39631303
Awesome, Don't know how I didn't know this.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

764 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