COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_Navision
DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\serv_teile\Monteure_fuer_Anzeige.imr
TITLE,Monteure_fuer_Anzeige.imr
BEGIN SQL
select distinct c1 as c1,
	   c2 as c2,
	   c3 as c3,
	   c4 as c4,
	   c5 as c5,
	   c6 as c6,
	   XRANK(c6 for c1) as c7
from 
(select T1."Order No_" as c1,
	   T1."Type" as c2,
	   T1."No_" as c3,
	   T2."Last Name" as c4,
	   T1."Entry No_" as c5,
	   (cast_float(T1."Qty_ Evaluated")) as c6,
	   XRANK(((cast_float(T1."Qty_ Evaluated"))) for T1."Order No_") as c8
from ("NAVISION"."import"."Service_Ledger_Entry" T1 left outer join "NAVISION"."import"."Employee" T2 on (T2."No_" = T1."No_") and (T2."Client_DB" = T1."Client_DB"))
where (((((extract(DAY FROM (now()) - T1."Posting Date")) <= 90) and (T1."Order No_" LIKE 'WAU%')) and (T1."Type" = 2)) and (((cast_float(T1."Qty_ Evaluated"))) <> 0))
) D1
where (c8 = 1)
order by c1 asc

END SQL
COLUMN,0,Order No
COLUMN,1,Type
COLUMN,2,No
COLUMN,3,Last Name
COLUMN,4,Entry No
COLUMN,5,Qty Evaluated
COLUMN,6,RANG  (  Qty Evaluated  )