karencita78
Programmer
hi,experts!, i have a report that was built with this statement:
select nombreanalista, month,month1, year, NROCOLOCACIONES, montoacumulado
from consolidadocolocaciones A,analista B
WHERE MES >= _MESINICIO AND ANIO >= _ANIOINICIO
AND MES <= _MESFIN AND ANIO <= _ANIOFIN
AND CODIGOTIPOREPORTE = 1
AND a.codigopersonaanalista=b.codigopersonaanalista
This report by each (nombreanalista) show (montoacumulado)
I want to show at the end of it a graphic that use month1 and group by month1 but not by nombreanalista the sum of(montoacumulado)
I added a summary column for (montoacumulado) but the graphic show by month1 the column (montoacumulado) by (nombreanalista)
what can I do? Help me, please
select nombreanalista, month,month1, year, NROCOLOCACIONES, montoacumulado
from consolidadocolocaciones A,analista B
WHERE MES >= _MESINICIO AND ANIO >= _ANIOINICIO
AND MES <= _MESFIN AND ANIO <= _ANIOFIN
AND CODIGOTIPOREPORTE = 1
AND a.codigopersonaanalista=b.codigopersonaanalista
This report by each (nombreanalista) show (montoacumulado)
I want to show at the end of it a graphic that use month1 and group by month1 but not by nombreanalista the sum of(montoacumulado)
I added a summary column for (montoacumulado) but the graphic show by month1 the column (montoacumulado) by (nombreanalista)
what can I do? Help me, please