Allowing blank date parameters in Crystal reports XI

Posted on 2007-10-08
Last Modified: 2012-05-05
I'm developing a report in Crystal Reports XI  (version  I have created a date range
parameter, but I need to allow the user to leave it  blank if he wants.  The problem is that
Crystal  keeps forcing the user to put something (non-null) in the date range field.  
Is there a workaround for this?  This is a simple report and I am  not using stored procedures or VB.
Here is what I am using for setup values for the Date parameter:
                   List of values:   Static

                  prompt text                                      Enter Starting Date:
                  prompt with description only          False
                  Default value                                  
                  Allow custom values                     True
                  Allow multiple values                     False
                  Allow discrete values                    False
                  Allow range values                       True

Thanks for your help.

Question by:rayshin
    LVL 42

    Accepted Solution

    Crystal is going to always require the parameter.  What you can do is set a default value of some arbitrary date (01/01/1900) and then set your report to handle that date differently - for example in your select expert have a formula like:

    if {?DateParam} = Date(1900,1,1) then
       {Table.Field} = {?DateParam};

    LVL 100

    Expert Comment


    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Expert Comment

    This is a sufficient workaround for my needs.  Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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

    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…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    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.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    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