ahmed_optom
Registered User.
- Local time
- Today, 12:46
- Joined
- Oct 27, 2016
- Messages
- 93
Hello,
Im trying to create a report, which will detail a history of a client.
Some clients have purchasing history, some we just have their contact details. These are stored in separate tables.
When I make a report that contains anything from a table that the client does not have an entry from, the entire report is blank. Not just the fields that I would expect.
Eg in table clients, we have their contact data. This shows fine if I make a report that only displays information from this table. But if they do not have any entry in purchases table, then their report is completely blank.
Ideally, and what I was expecting , that if they had no purchase history, only those fields would be blank, and the contact information, which we do have, would be displayed.
Any ideas?
Im trying to create a report, which will detail a history of a client.
Some clients have purchasing history, some we just have their contact details. These are stored in separate tables.
When I make a report that contains anything from a table that the client does not have an entry from, the entire report is blank. Not just the fields that I would expect.
Eg in table clients, we have their contact data. This shows fine if I make a report that only displays information from this table. But if they do not have any entry in purchases table, then their report is completely blank.
Ideally, and what I was expecting , that if they had no purchase history, only those fields would be blank, and the contact information, which we do have, would be displayed.
Any ideas?