I will explain the problem as best I can(bad English, sorry)
There are 2 tables in the database, there is 1 field with the same name in both tables.
The report shows information based on this common field witch I use to filter the data.
As soon as the common field is not yet in the second table because the user has not yet placed data there with the common field the reports flips totally blank.
I hope this explanation helps, this problem bugs me for some time and I have to make more reports based on this database structure.
ThanksYou need a left outer join from the first table to the second one.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment