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
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 a comment