iReport variable syntax

[DSJain]

Hello,

 

I am new to iReport so do not know much.

I have to migrate MS Access Reports to iReports. Hence, I am designing the templates in iReport same as in MS Access.

There are few conditions in MS Access for which I need an quivalant syntax in iReport variable.

The conditions in MS Access are as followed.

 

=IIf(Max(

)=Min([Code BS]),[Code BS],'')

=IIf(IsNull(Sum([HT])),0,Sum([HT]))

 

I do not know what to write for Min, Max, Sum etc.

 

Can any one plz help me. Any help would be appreciated.

 

TIA.