Skip to Content
0
Nov 16, 2012 at 12:59 PM

order collapsed column into MATRIX

34 Views

Hi

I have to set a descendent order in the first collapsed column of a matrix

this is the select:

SELECT T0.[Recontact] as [Data Inizio], T0.[ClgCode] as [Nr Attività],T1.[CardCode] as [Cod. BP], T1.[CardName] as [Ragione Sociale BP], T0.[BeginTime] as [Ora Inizio], T0.[ENDTime] as [Ora Fine], (T2.[firstName]+' '+T2.[lastName]) as Consulente, T0.[Action], T3.[Name],T0.[U_FLDF] as [Da Fatt.], T0.[U_CSTH] as [Cst. H.], T0.[U_ORDF] as [Ore Da Fatt.],(CASE T0.[U_FLDF] WHEN 'S' THEN (T0.[U_ORDF]* T0.[U_CSTH]) ELSE 0 END) AS CST_TOT_DAFATT,(T0.[U_ORDF]* T0.[U_CSTH]) AS CST_TOT,T0.[U_KM] as KM

FROM OCLG T0

LEFT JOIN OCRD T1 ON T0.CardCode = T1.CardCode

LEFT JOIN OHEM T2 ON T0.AttendEmpl = T2.empID

LEFT JOIN OCLT T3 ON T0.CntctType = T3.Code

ORDER BY T0.[Recontact] DESC

if I view it whith CollapseLevel=0 it is ok

if I se CollapseLevel=1 it is ordered in ascendent order

how can I solve this problem?