Hi,
I have upgraded the Cognos server version to 7.1 MR2. After upgrade many reports are not running and they are giving Receive Data Error. When I run these reports with Impromptu they give error "syntax error near 'order'. I found one common thing in most of the reports that these have a calculation of following type:
if (?Date? = 1995-01-01) then (trunc-date(sysdate-1)) else (?Date?)
Other columns are summary columns and are grouped on the above calculated column. As the above column is not database column query does not have a group by clause and has only order by clause.
Can someone suggest how can I resolve this error.
Thanks in advance.
I have upgraded the Cognos server version to 7.1 MR2. After upgrade many reports are not running and they are giving Receive Data Error. When I run these reports with Impromptu they give error "syntax error near 'order'. I found one common thing in most of the reports that these have a calculation of following type:
if (?Date? = 1995-01-01) then (trunc-date(sysdate-1)) else (?Date?)
Other columns are summary columns and are grouped on the above calculated column. As the above column is not database column query does not have a group by clause and has only order by clause.
Can someone suggest how can I resolve this error.
Thanks in advance.