Atribute value of type NMToken

[2004 IR Help]

By: fowlerd - fowlerd

Atribute value of type NMToken

2005-10-30 18:33

Hi,

 

I've been trying to use the content of an Oracle stored procedure in the Report Query to build the report. The query returns field names howver when I compile I get the error mentioned in the subject. The offending line which follows is seen as an attribute. I don't see why the query returns field names etc yet will not compile.

 

SUM(IS_IN_RANGE(ROUND(ABS(pmv.Current_Age - f_std_res_time(pmv.mtr_cd))),0,10)),

 

The fiull script is..

select pmv.Matter_Category,

kpi.standard_resolution_time,

SUM(IS_IN_RANGE(ROUND(ABS(pmv.Current_Age - f_std_res_time(pmv.mtr_cd))),0,10)),

SUM(IS_IN_RANGE(ROUND(ABS(pmv.Current_Age - f_std_res_time(pmv.mtr_cd))),11,20)),

SUM(IS_IN_RANGE(ROUND(ABS(pmv.Current_Age - f_std_res_time(pmv.mtr_cd))),21,50)),

SUM(IS_IN_RANGE(ROUND(ABS(pmv.Current_Age - f_std_res_time(pmv.mtr_cd))),51,100)),

SUM(IS_IN_RANGE(ROUND(ABS(pmv.Current_Age - f_std_res_time(pmv.mtr_cd))),101,999999)),

null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, NULL

from pending_matters_view pmv, kpi_paramaters kpi

where kpi.mtr_matter_cd = pmv.mtr_cd

group by pmv.Matter_Category,kpi.standard_resolution_time

 

Any help would be appreciated.

David