Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Discover what you really want, by looking at what you envy in others
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

14
February

How Do I Display the Week No in Crystal Reports

Recently a new client contacted me asking "How do I display my weekly report by week number?


Solution:

This is a relatively easy solution, one just needs to use Crystal Reports DatePart function:

DatePart( Interval Type, Fieldname, 1st Day of the Week, 1st Week of the Year)

To return the week number, for a company whose working day start on Monday:

DatePart( "ww",  {Tablename.Fieldname}, crMonday)




If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
1

Joolz

21
April
This is really useful

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

71 + 46 =