Oy!
CR 10
SQL Server 2005
I inherited someone elses report and in the process of discovery I found a weird IF statement:
@Agecolumn1
Numbervar vDaysbetween := {@wAgedate} - {pjinvdet.source_trx_date} ;
If if {pjinvdet.li_type} <> 'D' and {pjinvdet.bill_status} <> 'B' then(vDaysbetween >= {@wAge1from} and vDaysbetween <= {@wAge1to}) Then
{pjinvdet.amount}
Else
0
;
Can someone tell me what the purpose of the double if's might be?
CR 10
SQL Server 2005
I inherited someone elses report and in the process of discovery I found a weird IF statement:
@Agecolumn1
Numbervar vDaysbetween := {@wAgedate} - {pjinvdet.source_trx_date} ;
If if {pjinvdet.li_type} <> 'D' and {pjinvdet.bill_status} <> 'B' then(vDaysbetween >= {@wAge1from} and vDaysbetween <= {@wAge1to}) Then
{pjinvdet.amount}
Else
0
;
Can someone tell me what the purpose of the double if's might be?