With the latest upgrade (version n. 9) in the summary the group field wihich are “null” disapperar, this brings to an important lost di useful informations
while they are displayed in the grid group-by.
I’ve this query and in the summary all the clients are not displayed that haven’t done an purchase from the researched date.
QUERY:
SELECT sc.Citta,sc.Codice AS codsito,m1.DataMov,m1.CodProdotto,ISNULL(m1.Quantita,0) AS qt,m.Codice AS codmagaz,td.CodFamigliaDistributore1,z.Codice AS codzona,(p.QtaDecCaffe+p.QtaDecAcqua) AS resa,m.FlgProprieta,m.FlgInattivo,
m.CodTipologiaMacchina
FROM Magaz m
LEFT JOIN TipDis td ON td.Codice=m.CodTipologiaMacchina
LEFT JOIN SitCli sc ON sc.Codice=m.CodSito
LEFT JOIN Movim m1 ON m1.CodMagazzinoArrivo=m.Codice AND m1.CodSito=m.CodSito AND m1.DataMov>=’[dalladatamov_205]’ AND m1.CodProdotto IN(SELECT p2.Codice FROM Prodotti p2 WHERE (p2.QtaDecCaffe + p2.QtaDecAcqua)>0)
LEFT JOIN Prodotti p ON p.Codice=m1.CodProdotto
LEFT JOIN Zone z ON z.Codice=sc.CodZona
WHERE sc.CodCliente>0 AND m.CodSito=3791
[ATTACH=CONFIG]n77353[/ATTACH]
[ATTACH=CONFIG]n77354[/ATTACH]
