Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Excellence can be obtained if you care more than others think is wise, risk more than others think is safe, dream more than others think is practical, expect more than others think is possible
 
Unknown
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:

76 + 98 =