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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded