COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\Gaps_Locosoft_neu\Portal\System\IQD\Serv_Teile\Serviceberater_Rechnung.imr
TITLE,Serviceberater_Rechnung.imr
BEGIN SQL
select distinct T1."invoice_type" as c1,
	   T1."invoice_number" as c2,
	   T1."order_taking_employee_no" as c3,
	   T1."order_delivery_employee_no" as c4,
	   (od_left((cast_numberToString(cast_integer(T1."invoice_type"))),1)) || '_' || (od_left((cast_numberToString(cast_integer(T1."invoice_number"))),6)) as c5,
	   T2."employee_number" as c6,
	   T2."name" as c7,
	   (od_left((cast_numberToString(cast_integer(T2."employee_number"))),3)) || ' - ' || T2."name" as c8
from ("Locosoft"."dbo"."order_positions" T1 left outer join "dbo"."employees" T2 on T1."order_taking_employee_no" = T2."employee_number")
where (T1."invoice_type" BETWEEN 2 AND 6)
order by c5 asc,c2 asc

END SQL
COLUMN,0,Invoice Type
COLUMN,1,Invoice Number
COLUMN,2,Order Taking Employee No
COLUMN,3,Order Delivery Employee No
COLUMN,4,Invoice_Type_Invoice_Number
COLUMN,5,Employee Number_Employees
COLUMN,6,Name_Employees
COLUMN,7,Serviceberater