05-04-2012 06:08 AM
I have a cross-tab report, and there are many null values in the figure of cross-tab table. In web report studio, it shows a "." for null value. It is very strange, can I change any setting to change it so that null value shows '0" (zero) rather than ".".
05-05-2012 05:39 AM
when i enter "case when <<t1.f1>> NULL then 0 <<t1.f1>> end" in expression editor of data-item through information map studio. There is error shown:
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IS, LE, LET, LIKE, LT, LTT, NE,NET OR, ^=, }, }}, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
** the data type of the field involved is number
05-05-2012 08:09 PM