Skip to Content

Need help with Scheduling Crystal Report with default current date parameter in BI Launch Pad

Scheduling Crystal Report for enterprise 4.1 SP7 with current date parameter in BI Launch Pad.

We need this parameter to give the flexibility to the user to choose a date but it should default to the current date

the report is based on the universe, Relation connection, Oracle 12g

And Prompt is defiend in the universe

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 11, 2018 at 11:01 PM

    I'm not sure whether that version of CRE has the feature to allow for null parameters or not, but here's how I would do it in "classic" Crystal:

    Create a parameter for the date, setting the "Optional Prompt" property to True. Then, in the Select Expert, you would include something like the following formula:

      (not HasValue({?Date Prompt} and {MyTable.DateField} = CurrentDate) or
      (HasValue({?Date Prompt}) and {MyTable.DateField} = {?Date Prompt})

    Note where I've put the parentheses. If you have any other filter conditions in the Select Expert, you need the outer parenthese (top and bottom line) or else it won't work correctly.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.