Have a report that lists columnar data by the year and quarter. Would like to eliminate the year if the quarter is > 1.

This is what I have but CR does not like it:

whileprintingrecords; if {Command.fldQuarter} > 1 then {Command.fldyear}= 0 else {Command.fldyear};

Essentially, if quarter > 1 then year = "" else year.

This works: whileprintingrecords; whileprintingrecords; if {Command.fldQuarter} > 1 then totext("") else totext({Command.fldyear},0,"")

Formatting came from yggdrasil on another CRbook forum.

Thanks.


Edited by kimt - 24 Mar 2015 at 3:24pm

are you talking about suppressing the value in a row or changing a header? your first formula would not work because you cannot set or alter values from your data set (" then {Command.fldyear}= 0").  The one you found that works does so because it is creating a 'new resulting field value' not trying to update your current field(s).