Cross Tab - Changing week

Posted on 2012-09-14
Last Modified: 2012-09-25
Using CR 2008

I have a cross tab, with the column as date for each week

The week runs from Sunday to Saturday and the date printed in the column heading is the first day of the week Sunday i.e. this week 9th Sep

Our week runs from Monday to Sunday, which is how I want the cross tab to work.

Is there a formula I can use to implement Monday to Sunday instead of Sunday to Saturday?

Question by:halifaxman
    LVL 77

    Expert Comment

    Where does the start of week date come from currently?
    LVL 19

    Accepted Solution

    Create a formula

    {YourDateField} - (DayOfWeek ({YourDateField},crMonday))

    use this formula in your crosstab instead of your current date field and set to evaluate for every day

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    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…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now