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!
-
One to Many relationship where the one may not exist
What I'd like to see is this (in columns): Route # location Weight VIN State Lic No. Division.. The route number is what is located in field 3 of the EDFLDVALS table. I would like one line per vehicle. At this point whenever touch the EDFLDVALS table, with or without a formula, I...- lnusbaum
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
One to Many relationship where the one may not exist
I was mistaken I am currently using a Left Outer join, not the right. And your right as well, the field does exist on every record however its either populated or null/blank. I did try using an if then statement, however it evaluates every entry in the child table and that causes duplicate...- lnusbaum
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
One to Many relationship where the one may not exist
Hello; I'm trying to write a report (a vehicle inventory for our fleet) and I think the answer to this question lies along the lines similar to thread 767-284371. However in my case I only want to see what resides in the EFLDVALS.FLDVALUE field refereneced by a EFLDVALS.FLDNO field in the same...- lnusbaum
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
