ACE reports with null date

Hi, We are experiencing a report problem in Informix. For e.g. using "ace" report writer, if we have a date column in the report, and if the date is null, the columns following the date field(in that row) are printed with random spacing!? Hardcoding the COL positions did not help. It works fine if the date is not null, or even when a non-date datatype is null. We use the following versions: INFORMIX-SQL Version 7.20.UD1 INFORMIX-4GL Version 7.20.UD1 DB-Access Version 7.30.UC2 Any workaround, any help? Thanks very much guru

Are you using a format mask with the date field? Gurumoorthy Muthuswamy wrote in message <36F68F1C.E8921771@uswest.com>... >Hi, >We are experiencing a report problem in Informix. For e.g. using "ace" >report writer, if we have a date column in the report, and if the date >is null, the columns following the date field(in that row) are printed >with random spacing!? Hardcoding the COL positions did not help. It >works fine if the date is not null, or even when a non-date datatype is >null. >We use the following versions: >INFORMIX-SQL Version 7.20.UD1 >INFORMIX-4GL Version 7.20.UD1 >DB-Access Version 7.30.UC2 >Any workaround, any help? >Thanks very much >guru >

Hi, You may want to look into Bug 79901 and 7.20.UD6 to get around this problem. PK. Gurumoorthy Muthuswamy wrote: > Hi, > We are experiencing a report problem in Informix. For e.g. using "ace" > report writer, if we have a date column in the report, and if the date > is null, the columns following the date field(in that row) are printed > with random spacing!? Hardcoding the COL positions did not help. It > works fine if the date is not null, or even when a non-date datatype is > null. > We use the following versions: > INFORMIX-SQL Version 7.20.UD1 > INFORMIX-4GL Version 7.20.UD1 > DB-Access Version 7.30.UC2 > Any workaround, any help? > Thanks very much > guru