General information
Category:
Reports & Report designer
I have 2 tables; the first table is employee table, and the second table has a General field which holds photo. I want to run a report. I decided to join the tables using left join because there isn't always an entry in the photo table to match with the employee table. Where there isn't an entry in the photo table, it shows a .Null. value in the field. My problem is every time I hit a record .Null. value, I get an error "FIELD MUST BE A GENERAL FIELD" in the report. I tried several ways to get around this. Print when photo<>.NULL. Another way Print when type('photo')="G".
Does anyone have any suggestions?
TIA
Jim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only