Hi:
I had resolve the question with this method:
I have 2 formulas in the detail section...
Formula 1 name's - Dt_Nascenca1
Formula 2 name's - Anilha
in the formula 1 I have this code:
Dim date1 As Date
global numbervar as string
date1=CDate ({Relatório_Aves_1Selecao.nascenca})
if CurrentDate <= DateAdd ("d",{?Valor}, date1 ) then
formula = date1 + {?Valor}
numbervar = "true"
else
numbervar = "false"
end if
then:
I had format the field in the formula 1 enabled the option surpress and put this code:
global numbervar as string
if numbervar = "false" then
formula = IsNull ({@data_Nascenca1})
end if
In formula 2 i have this code:
global numbervar as string
if numbervar = "true" then
formula= ({Relatório_Aves_1Selecao.sexo})
end if
and in the format field I had enabled the surpress option too and put this code:
global numbervar as string
if numbervar = "false" then
formula = IsNull ({@Anilha})
end if
I don't know if this is the best way,but work and had resolve the blank fields in the report...
Thanks
IP Logged
