Initialize a variable

[ajith.devendra]

Dear 

I have a sum variable with  below properties

Name = TotalPieces 

Calculation = Sum

Expression =$F{LinePieces}

Increment Type = None

Reset type = Report

 

I need to initialize the TotalPieces value to zero if the value of the TotalPieces are more than 100 .. Would appreciate if you can help me on this 

 

Ajith 

 

 

 

 

[hozawa]

Just add the condition to the Expression and set Calculation to "No Calculation Function"

(($V{TotalPieces} + $F{LinePieces}) > 100) ? 0 : $V{TotalPieces} + $F{LinePieces}

[ajith.devendra]

Thanks Hozawa,

 

Thanks for your quick response .It worked perfectly .

 

Best Regards

 

Ajith

 

[ajith.devendra]

Dear Hozawa,

I just need to hide the  TotalPieces Variable while printing .. Would appreciate  your advice ..

In Crystal Reports we have supress checkBox .. Do we have similar way to hide the variable 

 

rgds

Ajith