Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems with Graphic

Status
Not open for further replies.

karencita78

Programmer
Dec 18, 2003
2
PE
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 >= :p_MESINICIO AND ANIO >= :p_ANIOINICIO
AND MES <= :p_MESFIN AND ANIO <= :p_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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top