Crystal Reports 11 using LastFullWeek as record parameter

Posted on 2009-12-28
Last Modified: 2012-05-08
I have a report that needs to include only the last past week.  In reality, the report will run Monday morning reporting from Previous Sunday to Saturday.  I'm using a DateTime field with the attached formula for the record selector, but cannot populated the report.  I know data is present on 12/23/2009 but the report is not returning any data.  Can anyone assist?
{Dialer_History.Call_Date} in LastFullWeek

Open in new window

Question by:OB1Canobie
    LVL 100

    Accepted Solution

    That should work.

    If you run the report without the filter do you get all the data?


    Author Closing Comment

    Thanks for your help.  The issue was for some reason, not all of the data was importing into the table, and the last date was 12/01/09 which was out of the data range.  Fixed the issue and the reports work.  Thanks.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    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…
    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…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 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

    24 Experts available now in Live!

    Get 1:1 Help Now