Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement