I am trying to create a report linking several tables from one database (Maximizer 5.0). I have the 8 necessary tables linked in what would seem to be the appropriate way -using Left-Joins vs. Equal joins to give me the data needed if available for the client I am reporting on.
However, I can only seem to report on one of the left-joined tables at a time. When I try to report on more than one, I only get the the few records where both Left-Joined tables have values while the other values are ignored.
It would seem that the primary table will only recognize one left-joined table without moving to an Equl-like join.
Am I missing a preference somewhere that would allow me to do this?
Please help. Thanks!
However, I can only seem to report on one of the left-joined tables at a time. When I try to report on more than one, I only get the the few records where both Left-Joined tables have values while the other values are ignored.
It would seem that the primary table will only recognize one left-joined table without moving to an Equl-like join.
Am I missing a preference somewhere that would allow me to do this?
Please help. Thanks!