Composite (stacked) charts

<< Click to Display Table of Contents >>

Navigation:  Delphi HTML Report Library > Charts >

Composite (stacked) charts

Vertical and horizontal charts could be stacked. Example:

 

<CHART width="750" height="400">
 <SERIES>
  <S type="vbar" x="lastname" y="sales" stack="syear"/>
 </SERIES>
 <SQL>
  select first 80 * from (
   select e.firstname, e.lastname, extract(year from saledate) syear,      
    sum(o.itemstotal) sales
   from customer c 
    join orders o on o.custno=c.custno
    join employee e on e.empno=o.empno
   group by 1, 2,3
   order by 1,2,3
  )
 </SQL>
</CHART>

 

Result:

 

DELPHI~1_img14