Apr 1, 2009 #1 sheely654 IS-IT--Management Joined Jul 9, 2008 Messages 9 Location US 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
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
Apr 1, 2009 #2 CR85user Technical User Joined Jan 18, 2005 Messages 522 Location GB 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}) = '' Click to expand... 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 Upvote 0 Downvote
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}) = '' Click to expand... 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
Apr 1, 2009 Thread starter #3 sheely654 IS-IT--Management Joined Jul 9, 2008 Messages 9 Location US AWESOME!!! I just forgot the parenthesis! Thank you SO much. I'm sure we'll correspond again!!! Upvote 0 Downvote