Home » Developer & Programmer » Reports & Discoverer » Change Line Graph Value Through Oracle Report Parameter (11g r1)
Change Line Graph Value Through Oracle Report Parameter [message #578225] Mon, 25 February 2013 23:54
prowael
Messages: 10
Registered: January 2012
Location: KSA
Junior Member
Dear All, I have one report in 11g R1 with some graphs I want to change the value of :

ReferenceObject association="Y1AXIS" location="RO_FRONT" text="Low" lineValue="1.2"

to be read from oracle report parameter for example:
ReferenceObject association="Y1AXIS" location="RO_FRONT" text="Low" lineValue=":P_LOW_PARAM"

actually this is the value where the line will apear in the graph, ofcourse this is a line graph, the value is dynamic, sould be passed through parameter. please help.....

Here is my graph xml property:



--------------------------------------------------------------------------------
<rw:graph id="CT_1" src="G_chart" groups="distance1" dataValues="iri_avg">
<!--
<?xml version="1.0" ?>
<Graph version="11.1.1.0" markerTooltipType="MTT_VALUES_TEXT" lineDataLineDisplayed="true" markerDisplayed="false" seriesEffect="SE_NONE" seriesObjectCount="30" graphType="LINE_VERT_ABS_2Y">
<Footnote>
<GraphFont size="10" fontColor="#000000"/>
</Footnote>
<LegendArea borderColor="#cccccc" borderTransparent="false"/>
<LegendText>
<GraphFont size="10" fontColor="#000000"/>
</LegendText>
<MarkerText>
<GraphFont size="10" fontColor="#000000" bold="true" italic="false" underline="false"/>
<X1ViewFormat>
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</X1ViewFormat>
<Y1ViewFormat>
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</Y1ViewFormat>
<Y2ViewFormat>
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</Y2ViewFormat>
<ZViewFormat>
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</ZViewFormat>
<StockVolumeViewFormat>
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</StockVolumeViewFormat>
</MarkerText>
<O1Axis lineColor="#000000"/>
<O1MajorTick lineColor="#cccccc"/>
<O1TickLabel textRotation="TR_HORIZ_ROTATE_270" automaticRotation="AR_NO_ROTATE">
<GraphFont size="10" fontColor="#000000"/>
</O1TickLabel>
<O1Title>
<GraphFont size="10" fontColor="#000000" bold="true" italic="false" underline="false"/>
</O1Title>
<PlotArea borderColor="#cccccc"/>
<PieFeeler lineColor="#000000"/>
<QuadrantLine lineColor="#999999"/>
<ReferenceItems>

<ReferenceObject association="Y1AXIS" location="RO_FRONT" text="Low" lineValue="1.2" color="#003300" displayedInLegend="true"/>
<ReferenceObject association="Y1AXIS" location="RO_FRONT" text="Medium" lineValue="1.4" color="#ffcc00" displayedInLegend="true"/>
<ReferenceObject association="Y1AXIS" location="RO_FRONT" text="High" lineValue="1.6" color="#cc0000" displayedInLegend="true"/>

</ReferenceItems>
<SeriesItems defaultLineWidth="1">
<Series id="0" color="#336699" borderTransparent="false"/>
<Series id="1" color="#99ccff" borderTransparent="false"/>
<Series id="2" color="#999933" borderTransparent="false"/>
<Series id="3" color="#666699" borderTransparent="false"/>
<Series id="4" color="#cc9933" borderTransparent="false"/>
<Series id="5" color="#006666" borderTransparent="false"/>
<Series id="6" color="#3399ff" borderTransparent="false"/>
<Series id="7" color="#993300" borderTransparent="false"/>
<Series id="8" color="#cccc99" borderTransparent="false"/>
<Series id="9" color="#666666" borderTransparent="false"/>
<Series id="10" color="#ffcc66" borderTransparent="false"/>
<Series id="11" color="#6699cc" borderTransparent="false"/>
<Series id="12" color="#663366" borderTransparent="false"/>
<Series id="13" color="#9999cc" borderTransparent="false"/>
<Series id="14" color="#cccccc" borderTransparent="false"/>
<Series id="15" color="#669999" borderTransparent="false"/>
<Series id="16" color="#cccc66" borderTransparent="false"/>
<Series id="17" color="#cc6600" borderTransparent="false"/>
<Series id="18" color="#9999ff" borderTransparent="false"/>
<Series id="19" color="#0066cc" borderTransparent="false"/>
<Series id="20" color="#99cccc" borderTransparent="false"/>
<Series id="21" color="#999999" borderTransparent="false"/>
<Series id="22" color="#ffcc00" borderTransparent="false"/>
<Series id="23" color="#009999" borderTransparent="false"/>
<Series id="24" color="#99cc33" borderTransparent="false"/>
<Series id="25" color="#ff9900" borderTransparent="false"/>
<Series id="26" color="#999966" borderTransparent="false"/>
<Series id="27" color="#66cccc" borderTransparent="false"/>
<Series id="28" color="#339966" borderTransparent="false"/>
<Series id="29" color="#cccc33" borderTransparent="false"/>
</SeriesItems>
<SliceLabel>
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</SliceLabel>
<Subtitle>
<GraphFont size="14" fontColor="#336699"/>
</Subtitle>
<Title>
<GraphFont size="17" fontColor="#336699"/>
</Title>
<X1Axis lineColor="#000000">
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</X1Axis>
<X1MajorTick lineColor="#cccccc"/>
<X1TickLabel>
<GraphFont size="10" fontColor="#000000"/>
</X1TickLabel>
<X1Title>
<GraphFont size="10" fontColor="#000000" bold="true" italic="false" underline="false"/>
</X1Title>
<Y1Axis lineColor="#000000" majorTickStepAutomatic="false" majorTickStep="0.2">
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</Y1Axis>
<Y1MajorTick lineColor="#cccccc"/>
<Y1TickLabel>
<GraphFont size="10" fontColor="#000000"/>
</Y1TickLabel>
<Y1Title>
<GraphFont size="10" fontColor="#000000" bold="true" italic="false" underline="false"/>
</Y1Title>
<Y2Axis lineColor="#000000" majorTickStepAutomatic="true">
<ViewFormat currencySymbol="Ñ.Ó.þ"/>
</Y2Axis>
<Y2MajorTick lineColor="#cccccc"/>
<Y2TickLabel>
<GraphFont size="10" fontColor="#000000"/>
</Y2TickLabel>
<Y2Title>
<GraphFont size="10" fontColor="#000000" bold="true" italic="false" underline="false"/>
</Y2Title>
</Graph>

-->
</rw:graph>
  • Attachment: graph.jpg
    (Size: 84.91KB, Downloaded 121 times)

[Updated on: Mon, 25 February 2013 23:56]

Report message to a moderator

Previous Topic: Unable to print report on Thermal printer Model (PRP-085III)
Next Topic: using a cursor
Goto Forum:
  


Current Time: Thu Oct 23 03:06:07 CDT 2014

Total time taken to generate the page: 0.11881 seconds