1 Reply Latest reply on Dec 1, 2012 6:09 AM by 883038

    chart graph problem

      hi all i have developed xml chart graph report .
      in which i have 5 columns
      2.No of reports
      3.avg time
      4.tot time.
      for each date am displaying 3 bars in chart (no of reports,avg time,tot time ) and i got the out put .
      but my problem is i want to display
      range on yaxis for columns (no of reports,tot_time)
      and on opposite side of y axis i want to print range in numbers
      range for AVG TIME column
      and on o axis displaying Dates column

      i have written code as below
      <Graph depthAngle="50" depthRadius="8" seriesEffect="SE_AUTO_GRADIENT">
      <Title text="Visaka Concurrent Performance Report" visible="true"
      <X1Title text=" Number Of Reports and Time in Minutes" visible="true"/>
      <Y1Title text="Seconds Per report" visible="true"/>
      <O1Title text="DATES " visible="true"/>
      <LocalGridData colCount="{count(//G_DATES)}" rowCount="3">
      <Label>No Of Reports </Label>
      <Label>Total Time(minutes)</Label>
      <Label>Avg Time(Seconds)</Label>
      <xsl:for-each select="//G_DATES">
      <xsl:value-of select=" DATES"/>
      <xsl:for-each select="//G_DATES">
      <xsl:value-of select="NOS"/>
      <xsl:for-each select="//G_DATES">
      <xsl:value-of select="TOT_TIME"/>
      <xsl:for-each select="//G_DATES">
      <xsl:value-of select="AVG_TIME"/>
      my xml file is like below 
      <?xml version="1.0"?>
      <!-- Generated by Oracle Reports version -->
      <TOT_TIME>1616.92</TOT_TIME> <AVG_TIME>13.19</AVG_TIME> </G_DATES>-<G_DATES> <DATES>27-NOV-12</DATES> <NOS>8359</NOS> <TOT_TIME>1828.7</TOT_TIME> <AVG_TIME>13.13</AVG_TIME> </G_DATES>-<G_DATES> <DATES>28-NOV-12</DATES> <NOS>8670</NOS> <TOT_TIME>1969.37</TOT_TIME> <AVG_TIME>13.63</AVG_TIME> </G_DATES>-<G_DATES> <DATES>29-NOV-12</DATES> <NOS>9318</NOS> <TOT_TIME>2286</TOT_TIME> <AVG_TIME>14.72</AVG_TIME> </G_DATES></LIST_G_DATES></T04304032>
      Kindly help on this how to display range on both either sides ( Y-Axis ,OPPOSITE TO Y-Axis(not O Axis)
      thanks for all in advance

      Edited by: maddy on Nov 30, 2012 6:44 AM