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
Previous Topic: How to create directly pdf file in reports 6i
Next Topic: If Statement Defining current data to new name
Goto Forum:
  


Current Time: Fri Jul 25 13:45:46 CDT 2014

Total time taken to generate the page: 0.10335 seconds