showing empty results

[sheely654]

Newbie here. I need to create a report that shows fname lname and enddate where the result shows all names that have an enddate that is empty

 

[CR85user]

Hi there - We were all new at some point so don't worry too much about it

Could I ask you to please include the following information as a reply?

1) What version of Crystal are you using (Solutions vary a lot from version to version sometimes)

2) Are 'fname','lname' and 'enddate' all fields?


If the above is the case then in your record selection you want your criteria to be as follows:

isnull({table.enddate}) or trim({table.enddate}) = ''

Simply place the first name and last name fields in the report so that it shows the relevant information.

There are a lot of good websites out there to get information for starters - Try reading them or indeed some of the training guides available.

'J

CR8.5 / CRXI - Discovering the impossible

 

[sheely654]

AWESOME!!! I just forgot the parenthesis! Thank you SO much. I'm sure we'll correspond again!!!