General information
Category:
Reports & Report designer
I haven't worked with general fields, so I don't know if this will help, but you could try.
In the SQL, put NVL(genfield,""). If the "" doesn't work for a general field, maybe something else will. The general idea is to eliminate the null values as you run the SQL.
Michelle
>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
Previous
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