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?