Crystal Novice here,
Using Crystal Reports 10, have created a report and want to alter the record selection formula to add a text message if no value is found.
The current formula is:
{Change_Request.Start Date} = CurrentDate-1
In the report this returns Change Requests from the previous day, however if there are no Change Requests from the previous day a blank filed is displayed.I want to add to this formula to return a text meassage if this is the case.
I tried some if thens and isnull but havn't stumbled across the right solution.
Any ideas?
Thanks!