Report Formula Works Fine In 8.5 But Not In Enterprise

[Sange]

I have designed a report which allows the end user to select all years or just one. To do this, I created a formula which converted the date field into a year ie year({date_field}). I then created a parameter field and imported a text document which listed a range of years and the word "ALL". In my select statement I typed the following code:

if {?Year} <> &quot;ALL&quot; then (TOTEXT({@Year})) = {?Year} else true

Why does this report run in 8.5 without any difficulty? However as soon as I load it on Enterprise and select a year in the parameter box I get null data but the &quot;ALL&quot; option will work and I get all records returned.

Help please.

 

[Naith]

If you drop the fields TOTEXT({@Year}) and {?Year} on your report display area, and run it from CE, you will probably see that the fields return looking different. e.g. &quot;1995.00&quot; compared to &quot;1995&quot;.

Format your ToText argument (e.g. ToText({@Year},'')) so that it matches {?Year} and then check the impact.

Naith