Skip to Content
0
Former Member
Jan 27, 2011 at 05:59 PM

iChart type GroupBar

20 Views

I've been struggling to create a GroupBar that will display what I want.

I have an SQL query that returns 3 columns that I care about "Time", "RRate", "TRate" .

I would like 2 different colored bars (RRate and TRate) for each "Time" label. To be clear there will only be two colors, one for TRate and one for RRate.

XML Looks like:

<Rowset>

<Columns>

<Column Description="RTIME" MaxRange="1" MinRange="0" Name="RTIME" SQLDataType="93" SourceColumn="RTIME"/>

<Column Description="Time" MaxRange="1" MinRange="0" Name="Time" SQLDataType="12" SourceColumn="Time"/>

<Column Description="RRATE" MaxRange="1" MinRange="0" Name="RRATE" SQLDataType="2" SourceColumn="RRATE"/>

<Column Description="TRATE" MaxRange="1" MinRange="0" Name="TRATE" SQLDataType="2" SourceColumn="TRATE"/>

</Columns>

<Row>

<RTIME>2011-01-27T10:00:04</RTIME>

<Time>10:00</Time>

<RRATE>110</RRATE>

<TRATE>230</TRATE>

</Row>

<Row>

<RTIME>2011-01-27T10:15:03</RTIME>

<Time>10:15</Time>

<RRATE>115</RRATE>

<TRATE>230</TRATE>

</Row>

<Row>

<RTIME>2011-01-27T10:30:02</RTIME>

<Time>10:30</Time>

<RRATE>95</RRATE>

<TRATE>230</TRATE>

</Row>

<Row>

<RTIME>2011-01-27T10:45:02</RTIME>

<Time>10:45</Time>

<RRATE>175</RRATE>

<TRATE>230</TRATE>

</Row>

<Row>

<RTIME>2011-01-27T11:00:03</RTIME>

<Time>11:00</Time>

<RRATE>180</RRATE>

<TRATE>230</TRATE>

</Row>

</Rowset>

Thanks,

Rod