Problem with report (Closed)

[divined]

Hello everybody

I`ve created a report wich gets its recordset from a rather intricate SQL statement, which I will not mention. The thing is that there exist two fields in every record, of which only one has a value and the other is null, or vice versa. In the report I`ve created an unbounded string field which should take on the value of the field which is not NULL. For this purpose some code has been written :

If Not (IsNull({Epis_Mhxanhma.Kwd_Etairias})) And IsNull({Epis_Mhxanhma.Kwd_Texnikou}) Then
  {Etairia.Epwnymia}
Else
  {Texnikos.Onomatepwnymo}

This code does not work even for a single recordset (If part asserted). But if I use the following code :

If Not (IsNull({Epis_Mhxanhma.Kwd_Etairias})) And IsNull({Epis_Mhxanhma.Kwd_Texnikou}) Then
  {Etairia.Epwnymia}

Then I get all the records satisfying the IF statement but none of the others. Why is this so? Can I somehow restate what I`m trying to do?

thx, in advance

George Papadopoulos