Home » Developer & Programmer » Reports & Discoverer » Matrix Graph Report
Matrix Graph Report [message #562568] Thu, 02 August 2012 05:55
elsy
Messages: 40
Registered: August 2006
Location: Kuwait
Member
I want to create a line graph which shows the monthwise sales of each location in a single graph.The query is like this

select to_char(inv_dt,'YYMM'),to_char(inv_dt,'MON-RR'),location,sum(amount) from invoice
group by to_char(inv_dt,'YYMM'),to_char(inv_dt,'MON-RR'),location

In the line graph,each line for different location

Do anyone know how to create the graph.
Thanks
Elsy

Report message to a moderator

Previous Topic: How to create directly pdf file in reports 6i
Next Topic: If Statement Defining current data to new name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 10:02:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.