Paramter values in a report footer message 1

[reidtw]

Hi,

I am trying to return the from and to dates in a message string when there are no records returned after the user enters the dates to parameter named ?date.

The formula is currently: -

if(isnull(GroupName ({AccountPool.Name}))) then "NO DELETIONS FOR PERIOD FROM " + totext({AuditTrail.TimeChanged},"dd-mm-yyyy") + "TO " + totext({AuditTrail.TimeChanged},"dd-mm-yyyy")

which is rubbish 'cos Crystal obviously does not know which is the from and to date.

I tried using the paramter in the formula but it asks for a valid date field.

Any ideas would be much appreciated.

T

 

[Reebo99]

Is the {?date} a date range parameter? if so, use :

if(isnull(GroupName ({AccountPool.Name}))) then "NO DELETIONS FOR PERIOD FROM " + totext(Minimum({?Date}),"dd-mm-yyyy") + "TO " + totext(Maximum({?Date}),"dd-mm-yyyy")

Otherwise, ensure {?Date} is a date parameter.

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.