Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Don't fear failure so much that you refuse to try new things. The saddest summary of life contains three descriptions: could have, might have, and should have
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!!!!


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?


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


Name *

Email Address *

Comment *