Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can't restrict on a sometimes null field
LB, Yes, I would definitely be interested in the scenario you point out for vehicles that have only one record = safety. This is a big (and helpful) learning experience for me. Please advise. Jeff- TJ1776
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Can't restrict on a sometimes null field
Thank you, LB. I got this formula solution that worked from another site: (if isnull({Table2.inspection}) then true else {TABLE2.inspection} <> "safety") Thanks much for your response. Jeff- TJ1776
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Can't restrict on a sometimes null field
Can't restrict on a sometimes null field Crystal Reports 11 MSSQL 2000 DB Vehicle maintenance database: Attempting to write a two-table report that will show vehicle numbers (from Table1) and a *subset* of vehicle inspections (from Table2). Not all vehicles in Table1 have inspections listed...- TJ1776
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 4 Other topics
