Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
A wise person learns by the experience of others. An ordinary persons learns by his or her own experience. A fool learns by nobody's experience
 
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!!!!

08
May

How Do I Return All the Records upto the Previous Friday in Crystal Reports?

During a recent Crystal Reports XI training session, a delegate asked how does one return of the records upto the previous Friday?

Solution:

Crystal Reports XI has a array function LastFullWeek, which includes all dates from the previous week from Sunday to Saturday.

So by manipulating this function it is possible to return the required dataset.

To Return the all the records upto the previous Friday:
  1. From the Report Menu Select the Selection Formulas -> Record
  2. In the Formula Workshop, enter the following formula:

  3. {Tablename.Fieldname}  <= Maximum(LastFullWeek) - 1

  4. Press the Save and Close button


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

MAKE A COMMENT

Name *

Email Address *

Comment *