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!

Register Log in
  • Congratulations Mike Lewis 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

karencita78

Programmer
Dec 18, 2003
2
0
0
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.

Similar threads

deo1
  • Locked
  • Question
Please help with forms6i ole2 ms word
Replies
0
Views
69
deo1
deo1
Advocate
  • Locked
  • Question
Problems with csv output &amp; DESFORMAT
Replies
0
Views
63
Advocate
Advocate
kss444
  • Locked
  • Question
problems with different date formats in same field.
Replies
2
Views
52
carp
carp
taqmeena
  • Locked
  • Question
Using Crystal Reports with Form 6i
Replies
0
Views
56
taqmeena
taqmeena
gleeb
  • Locked
  • Question
Bind Variable with Null value
Replies
1
Views
64
BJCooperIT
BJCooperIT

Part and Inventory Search

Sponsor

Back
Top