Attachment 47602 Details for Bug 147101 – Report to run against 1million rows

Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Report to run against 1million rows

DrillSiteSummary1000.rptdesign (text/plain), 61.87 KB, created by Sachin Dharmapurikar

on 2006-08-09 07:03:51 EDT

(hide)

Description:

Filename:

MIME Type:

Creator: Sachin Dharmapurikar

Created: 2006-08-09 07:03:51 EDT

Size: 61.87 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8"?>
>
><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2" id="1">
>    <property name="createdBy">Eclipse BIRT Designer Version 2.1.0.N20060628-1351 Build &lt;20060628-1537></property>
>    <property name="units">in</property>
>    <property name="comments">Copyright (c) 2006 &lt;&lt;Your Company Name here>></property>
>    <list-property name="propertyBindings">
>        <structure>
>            <property name="name">queryText</property>
>            <property name="id">48</property>
>        </structure>
>        <structure>
>            <property name="name">queryTimeOut</property>
>            <property name="id">48</property>
>            <expression name="value">30</expression>
>        </structure>
>    </list-property>
>    <data-sources>
>        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="vigilant" id="11">
>            <text-property name="displayName">vigilant</text-property>
>            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
>            <property name="odaURL">jdbc:mysql://localhost/vigilant</property>
>            <property name="odaUser">root</property>
>            <encrypted-property name="odaPassword">cmVkaGF0</encrypted-property>
>        </oda-data-source>
>    </data-sources>
>    <data-sets>
>        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="SiteDetail" id="48">
>            <text-property name="displayName">SiteDetail</text-property>
>            <list-property name="parameters">
>                <structure>
>                    <property name="name">site</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">1</property>
>                    <property name="position">1</property>
>                    <expression name="defaultValue">'BOSTON'</expression>
>                    <property name="isOptional">false</property>
>                    <property name="isInput">true</property>
>                </structure>
>            </list-property>
>            <structure name="cachedMetaData">
>                <list-property name="resultSet">
>                    <structure>
>                        <property name="position">1</property>
>                        <property name="name">v_sysid</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">2</property>
>                        <property name="name">count(*)</property>
>                        <property name="dataType">decimal</property>
>                    </structure>
>                </list-property>
>            </structure>
>            <property name="dataSource">vigilant</property>
>            <property name="queryText">select v_sysid,count(*)
>from iis_d where v_site=? group by v_sysid</property>
>        </oda-data-set>
>        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="SiteSummary" id="104">
>            <text-property name="displayName">SiteSummary</text-property>
>            <list-property name="resultSet">
>                <structure>
>                    <property name="position">1</property>
>                    <property name="name">v_site</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">2</property>
>                    <property name="name">count(*)</property>
>                    <property name="dataType">decimal</property>
>                    <property name="nativeDataType">-5</property>
>                </structure>
>            </list-property>
>            <structure name="cachedMetaData">
>                <list-property name="resultSet">
>                    <structure>
>                        <property name="position">1</property>
>                        <property name="name">v_site</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">2</property>
>                        <property name="name">count(*)</property>
>                        <property name="dataType">decimal</property>
>                    </structure>
>                </list-property>
>            </structure>
>            <property name="dataSource">vigilant</property>
>            <property name="queryText">select v_site, count(*) from iis_d
>group by v_site</property>
>        </oda-data-set>
>    </data-sets>
>    <page-setup>
>        <simple-master-page name="SiteSummary" id="2">
>            <property name="type">a4</property>
>            <property name="topMargin">0.75in</property>
>            <property name="leftMargin">1in</property>
>            <property name="bottomMargin">1in</property>
>            <property name="rightMargin">0.75in</property>
>            <property name="showHeaderOnFirst">false</property>
>            <property name="headerHeight">0.75in</property>
>            <property name="footerHeight">0.75in</property>
>        </simple-master-page>
>    </page-setup>
>    <body>
>        <text id="161">
>            <property name="fontFamily">"Arial"</property>
>            <expression name="bookmark">"Main Chart"</expression>
>            <expression name="toc">"Summary"</expression>
>            <property name="contentType">html</property>
>            <text-property name="content"><![CDATA[<center>
><H3>Sitewise Traffic Summary</H3>
><br>
>Created on <value-of>new Date()</value-of>
></center>
><br>]]></text-property>
>        </text>
>        <grid id="4">
>            <property name="textAlign">center</property>
>            <property name="width">100%</property>
>            <column id="5"/>
>            <row id="7">
>                <property name="height">2.781in</property>
>                <cell id="8">
>                    <extended-item extensionName="Chart" id="13">
>                        <property name="height">350px</property>
>                        <property name="width">500px</property>
>                        <property name="dataSet">SiteSummary</property>
>                        <list-property name="boundDataColumns">
>                            <structure>
>                                <property name="name">v_site</property>
>                                <expression name="expression">dataSetRow["v_site"]</expression>
>                                <property name="dataType">string</property>
>                            </structure>
>                            <structure>
>                                <property name="name">count(*)</property>
>                                <expression name="expression">dataSetRow["count(*)"]</expression>
>                                <property name="dataType">decimal</property>
>                            </structure>
>                        </list-property>
>                        <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithoutAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
>  <Type>Pie Chart</Type>
>  <SubType>Standard Pie Chart</SubType>
>  <Description>
>    <Value></Value>
>    <Font>
>      <Alignment/>
>    </Font>
>  </Description>
>  <Block>
>    <Children xsi:type="layout:TitleBlock">
>      <Bounds>
>        <Left>0.0</Left>
>        <Top>0.0</Top>
>        <Width>0.0</Width>
>        <Height>0.0</Height>
>      </Bounds>
>      <Insets>
>        <Top>3.0</Top>
>        <Left>3.0</Left>
>        <Bottom>3.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Row>-1</Row>
>      <Column>-1</Column>
>      <Rowspan>-1</Rowspan>
>      <Columnspan>-1</Columnspan>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </Outline>
>      <Visible>false</Visible>
>      <Label>
>        <Caption>
>          <Value>Sitewise Traffic Summary</Value>
>          <Font>
>            <Size>16.0</Size>
>            <Bold>true</Bold>
>            <Alignment>
>              <horizontalAlignment>Center</horizontalAlignment>
>              <verticalAlignment>Center</verticalAlignment>
>            </Alignment>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>true</Visible>
>      </Label>
>    </Children>
>    <Children xsi:type="layout:Plot">
>      <Bounds>
>        <Left>0.0</Left>
>        <Top>0.0</Top>
>        <Width>0.0</Width>
>        <Height>0.0</Height>
>      </Bounds>
>      <Anchor>North</Anchor>
>      <Insets>
>        <Top>3.0</Top>
>        <Left>3.0</Left>
>        <Bottom>3.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Row>-1</Row>
>      <Column>-1</Column>
>      <Rowspan>-1</Rowspan>
>      <Columnspan>-1</Columnspan>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>102</Red>
>          <Green>102</Green>
>          <Blue>153</Blue>
>        </Color>
>        <Visible>true</Visible>
>      </Outline>
>      <Background xsi:type="attribute:ColorDefinition">
>        <Transparency>88</Transparency>
>        <Red>153</Red>
>        <Green>204</Green>
>        <Blue>254</Blue>
>      </Background>
>      <Visible>true</Visible>
>      <HorizontalSpacing>5</HorizontalSpacing>
>      <VerticalSpacing>5</VerticalSpacing>
>      <ClientArea>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>0</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <ShadowColor>
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </ShadowColor>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>0.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>0.0</Right>
>        </Insets>
>      </ClientArea>
>    </Children>
>    <Children xsi:type="layout:Legend">
>      <Bounds>
>        <Left>0.0</Left>
>        <Top>0.0</Top>
>        <Width>0.0</Width>
>        <Height>0.0</Height>
>      </Bounds>
>      <Stretch>Horizontal</Stretch>
>      <Insets>
>        <Top>3.0</Top>
>        <Left>3.0</Left>
>        <Bottom>3.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Row>-1</Row>
>      <Column>-1</Column>
>      <Rowspan>-1</Rowspan>
>      <Columnspan>-1</Columnspan>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </Outline>
>      <Visible>true</Visible>
>      <Triggers>
>        <Condition>onclick</Condition>
>        <Action>
>          <Type>URL_Redirect</Type>
>          <Value xsi:type="attribute:URLValue">
>            <BaseUrl>&lt;structure name=&quot;action&quot;>&#xD;
>    &lt;property name=&quot;linkType&quot;>bookmark-link&lt;/property>&#xD;
>    &lt;expression name=&quot;targetBookmark&quot;>row[&quot;v_site&quot;]&lt;/expression>&#xD;
>&lt;/structure>&#xD;
></BaseUrl>
>            <BaseParameterName></BaseParameterName>
>            <ValueParameterName></ValueParameterName>
>            <SeriesParameterName></SeriesParameterName>
>          </Value>
>        </Action>
>      </Triggers>
>      <ClientArea>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>0</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <Insets>
>          <Top>1.5</Top>
>          <Left>1.5</Left>
>          <Bottom>1.5</Bottom>
>          <Right>1.5</Right>
>        </Insets>
>      </ClientArea>
>      <Text>
>        <Value></Value>
>        <Font>
>          <Name>Arial</Name>
>          <Size>10.0</Size>
>          <Alignment/>
>        </Font>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>      </Text>
>      <Orientation>Vertical</Orientation>
>      <Direction>Top_Bottom</Direction>
>      <Separator>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>true</Visible>
>      </Separator>
>      <Position>Outside</Position>
>      <ItemType>Categories</ItemType>
>      <Title>
>        <Caption>
>          <Value>Sites</Value>
>          <Font>
>            <Name>Arial</Name>
>            <Size>10.0</Size>
>            <Bold>true</Bold>
>            <Alignment/>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>true</Visible>
>      </Title>
>      <TitlePosition>Above</TitlePosition>
>    </Children>
>    <Bounds>
>      <Left>0.0</Left>
>      <Top>0.0</Top>
>      <Width>375.0</Width>
>      <Height>262.5</Height>
>    </Bounds>
>    <Insets>
>      <Top>3.0</Top>
>      <Left>3.0</Left>
>      <Bottom>3.0</Bottom>
>      <Right>3.0</Right>
>    </Insets>
>    <Row>-1</Row>
>    <Column>-1</Column>
>    <Rowspan>-1</Rowspan>
>    <Columnspan>-1</Columnspan>
>    <Outline>
>      <Style>Solid</Style>
>      <Thickness>1</Thickness>
>      <Color>
>        <Transparency>255</Transparency>
>        <Red>0</Red>
>        <Green>0</Green>
>        <Blue>0</Blue>
>      </Color>
>      <Visible>false</Visible>
>    </Outline>
>    <Background xsi:type="attribute:ColorDefinition">
>      <Transparency>255</Transparency>
>      <Red>255</Red>
>      <Green>255</Green>
>      <Blue>255</Blue>
>    </Background>
>    <Visible>true</Visible>
>  </Block>
>  <Dimension>Two_Dimensional_With_Depth</Dimension>
>  <Units>Pixels</Units>
>  <SeriesThickness>3.75</SeriesThickness>
>  <GridColumnCount>1</GridColumnCount>
>  <SampleData>
>    <BaseSampleData>
>      <DataSetRepresentation>'8.0','8.0','8.0'</DataSetRepresentation>
>    </BaseSampleData>
>    <OrthogonalSampleData>
>      <DataSetRepresentation>0.0,0.0,2.0</DataSetRepresentation>
>      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>    </OrthogonalSampleData>
>  </SampleData>
>  <Interactivity>
>    <Enable>true</Enable>
>    <LegendBehavior>None</LegendBehavior>
>  </Interactivity>
>  <SeriesDefinitions>
>    <Query>
>      <Definition></Definition>
>    </Query>
>    <SeriesPalette>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>80</Red>
>        <Green>166</Green>
>        <Blue>218</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>242</Red>
>        <Green>88</Green>
>        <Blue>106</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>232</Red>
>        <Green>172</Green>
>        <Blue>57</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>128</Red>
>        <Green>255</Green>
>        <Blue>128</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>64</Red>
>        <Green>128</Green>
>        <Blue>128</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>128</Red>
>        <Green>128</Green>
>        <Blue>192</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>170</Red>
>        <Green>85</Green>
>        <Blue>85</Blue>
>      </Entries>
>      <Entries xsi:type="attribute:ColorDefinition">
>        <Transparency>255</Transparency>
>        <Red>128</Red>
>        <Green>128</Green>
>        <Blue>0</Blue>
>      </Entries>
>    </SeriesPalette>
>    <SeriesDefinitions>
>      <Query>
>        <Definition></Definition>
>      </Query>
>      <SeriesPalette>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>80</Red>
>          <Green>166</Green>
>          <Blue>218</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>242</Red>
>          <Green>88</Green>
>          <Blue>106</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>232</Red>
>          <Green>172</Green>
>          <Blue>57</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>128</Red>
>          <Green>255</Green>
>          <Blue>128</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>64</Red>
>          <Green>128</Green>
>          <Blue>128</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>128</Red>
>          <Green>128</Green>
>          <Blue>192</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>170</Red>
>          <Green>85</Green>
>          <Blue>85</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>128</Red>
>          <Green>128</Green>
>          <Blue>0</Blue>
>        </Entries>
>      </SeriesPalette>
>      <Series xsi:type="type:PieSeries">
>        <Visible>true</Visible>
>        <Label>
>          <Caption>
>            <Value></Value>
>            <Font>
>              <Name>Arial</Name>
>              <Size>9.0</Size>
>              <Alignment/>
>            </Font>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>0</Green>
>              <Blue>128</Blue>
>            </Color>
>          </Caption>
>          <Background xsi:type="attribute:ColorDefinition">
>            <Transparency>0</Transparency>
>            <Red>255</Red>
>            <Green>255</Green>
>            <Blue>255</Blue>
>          </Background>
>          <Outline>
>            <Style>Solid</Style>
>            <Thickness>1</Thickness>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>0</Green>
>              <Blue>0</Blue>
>            </Color>
>            <Visible>false</Visible>
>          </Outline>
>          <ShadowColor>
>            <Transparency>0</Transparency>
>            <Red>255</Red>
>            <Green>255</Green>
>            <Blue>255</Blue>
>          </ShadowColor>
>          <Insets>
>            <Top>0.0</Top>
>            <Left>2.0</Left>
>            <Bottom>0.0</Bottom>
>            <Right>3.0</Right>
>          </Insets>
>          <Visible>true</Visible>
>        </Label>
>        <DataDefinition>
>          <Definition>row[&quot;count(*)&quot;]</Definition>
>        </DataDefinition>
>        <SeriesIdentifier>Hits</SeriesIdentifier>
>        <DataPoint>
>          <Components>
>            <Type>Orthogonal_Value</Type>
>          </Components>
>          <Separator>, </Separator>
>        </DataPoint>
>        <LabelPosition>Outside</LabelPosition>
>        <Stacked>false</Stacked>
>        <Triggers>
>          <Condition>onclick</Condition>
>          <Action>
>            <Type>URL_Redirect</Type>
>            <Value xsi:type="attribute:URLValue">
>              <BaseUrl>&lt;structure name=&quot;action&quot;>&#xD;
>    &lt;property name=&quot;linkType&quot;>bookmark-link&lt;/property>&#xD;
>    &lt;expression name=&quot;targetBookmark&quot;>row[&quot;v_site&quot;]&lt;/expression>&#xD;
>&lt;/structure>&#xD;
></BaseUrl>
>              <BaseParameterName></BaseParameterName>
>              <ValueParameterName></ValueParameterName>
>              <SeriesParameterName></SeriesParameterName>
>            </Value>
>          </Action>
>        </Triggers>
>        <Translucent>false</Translucent>
>        <Explosion>0</Explosion>
>        <ExplosionExpression></ExplosionExpression>
>        <Title>
>          <Caption>
>            <Value></Value>
>            <Font>
>              <Size>16.0</Size>
>              <Bold>true</Bold>
>              <Alignment/>
>            </Font>
>          </Caption>
>          <Background xsi:type="attribute:ColorDefinition">
>            <Transparency>0</Transparency>
>            <Red>255</Red>
>            <Green>255</Green>
>            <Blue>255</Blue>
>          </Background>
>          <Outline>
>            <Style>Solid</Style>
>            <Thickness>1</Thickness>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>0</Green>
>              <Blue>0</Blue>
>            </Color>
>          </Outline>
>          <Insets>
>            <Top>0.0</Top>
>            <Left>2.0</Left>
>            <Bottom>0.0</Bottom>
>            <Right>3.0</Right>
>          </Insets>
>          <Visible>true</Visible>
>        </Title>
>        <TitlePosition>Below</TitlePosition>
>        <LeaderLineAttributes>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>true</Visible>
>        </LeaderLineAttributes>
>        <LeaderLineStyle>Stretch_To_Side</LeaderLineStyle>
>        <LeaderLineLength>40.0</LeaderLineLength>
>      </Series>
>      <Grouping>
>        <Enabled>false</Enabled>
>        <GroupingInterval>2</GroupingInterval>
>        <GroupType>Text</GroupType>
>        <AggregateExpression>Sum</AggregateExpression>
>      </Grouping>
>    </SeriesDefinitions>
>    <Series>
>      <Visible>true</Visible>
>      <Label>
>        <Caption>
>          <Value></Value>
>          <Font>
>            <Alignment/>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>false</Visible>
>      </Label>
>      <DataDefinition>
>        <Definition>row[&quot;v_site&quot;]</Definition>
>      </DataDefinition>
>      <SeriesIdentifier>Sites</SeriesIdentifier>
>      <DataPoint>
>        <Components>
>          <Type>Orthogonal_Value</Type>
>        </Components>
>        <Separator>, </Separator>
>      </DataPoint>
>      <LabelPosition>Outside</LabelPosition>
>      <Stacked>false</Stacked>
>    </Series>
>    <Grouping>
>      <Enabled>false</Enabled>
>      <GroupingInterval>2</GroupingInterval>
>      <GroupType>Text</GroupType>
>      <AggregateExpression>Sum</AggregateExpression>
>    </Grouping>
>  </SeriesDefinitions>
>  <MinSlicePercent>false</MinSlicePercent>
></model:ChartWithoutAxes>
>]]></xml-property>
>                        <property name="outputFormat">PNG</property>
>                    </extended-item>
>                </cell>
>            </row>
>            <row id="30">
>                <property name="height">2.781in</property>
>                <cell id="31">
>                    <list id="105">
>                        <property name="masterPage">SiteSummary</property>
>                        <property name="pageBreakBefore">always</property>
>                        <property name="dataSet">SiteSummary</property>
>                        <list-property name="boundDataColumns">
>                            <structure>
>                                <property name="name">v_site</property>
>                                <expression name="expression">dataSetRow["v_site"]</expression>
>                                <property name="dataType">string</property>
>                            </structure>
>                            <structure>
>                                <property name="name">count(*)</property>
>                                <expression name="expression">dataSetRow["count(*)"]</expression>
>                                <property name="dataType">decimal</property>
>                            </structure>
>                            <structure>
>                                <property name="name">Site</property>
>                                <expression name="expression">dataSetRow["v_site"]</expression>
>                            </structure>
>                        </list-property>
>                        <detail>
>                            <data id="106">
>                                <property name="backgroundColor">#C0C0C0</property>
>                                <property name="fontFamily">"Arial"</property>
>                                <property name="fontSize">large</property>
>                                <property name="fontWeight">bold</property>
>                                <property name="textAlign">left</property>
>                                <property name="pageBreakAfter">auto</property>
>                                <property name="pageBreakBefore">auto</property>
>                                <expression name="bookmark">row["v_site"]</expression>
>                                <expression name="toc">row["v_site"]</expression>
>                                <property name="resultSetColumn">v_site</property>
>                            </data>
>                            <label id="162">
>                                <property name="color">blue</property>
>                                <property name="textUnderline">underline</property>
>                                <property name="textAlign">left</property>
>                                <text-property name="text">(Top)</text-property>
>                                <structure name="action">
>                                    <property name="linkType">bookmark-link</property>
>                                    <expression name="targetBookmark">"Main Chart"</expression>
>                                </structure>
>                            </label>
>                            <extended-item extensionName="Chart" id="160">
>                                <property name="height">150pt</property>
>                                <property name="width">450pt</property>
>                                <property name="dataSet">SiteDetail</property>
>                                <list-property name="paramBindings">
>                                    <structure>
>                                        <property name="paramName">site</property>
>                                        <expression name="expression">row["Site"]</expression>
>                                    </structure>
>                                </list-property>
>                                <list-property name="boundDataColumns">
>                                    <structure>
>                                        <property name="name">v_sysid</property>
>                                        <expression name="expression">dataSetRow["v_sysid"]</expression>
>                                        <property name="dataType">string</property>
>                                    </structure>
>                                    <structure>
>                                        <property name="name">count(*)_1</property>
>                                        <expression name="expression">dataSetRow["count(*)"]</expression>
>                                        <property name="dataType">decimal</property>
>                                    </structure>
>                                </list-property>
>                                <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:data="http://www.birt.eclipse.org/ChartModelData" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
>  <Type>Bar Chart</Type>
>  <SubType>Side-by-side</SubType>
>  <Block>
>    <Children xsi:type="layout:TitleBlock">
>      <Bounds>
>        <Left>0.0</Left>
>        <Top>0.0</Top>
>        <Width>0.0</Width>
>        <Height>0.0</Height>
>      </Bounds>
>      <Insets>
>        <Top>3.0</Top>
>        <Left>3.0</Left>
>        <Bottom>3.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Row>-1</Row>
>      <Column>-1</Column>
>      <Rowspan>-1</Rowspan>
>      <Columnspan>-1</Columnspan>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </Outline>
>      <Visible>false</Visible>
>      <Label>
>        <Caption>
>          <Value>Bar Chart Title</Value>
>          <Font>
>            <Size>16.0</Size>
>            <Bold>true</Bold>
>            <Alignment>
>              <horizontalAlignment>Center</horizontalAlignment>
>              <verticalAlignment>Center</verticalAlignment>
>            </Alignment>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>true</Visible>
>      </Label>
>    </Children>
>    <Children xsi:type="layout:Plot">
>      <Bounds>
>        <Left>0.0</Left>
>        <Top>0.0</Top>
>        <Width>0.0</Width>
>        <Height>0.0</Height>
>      </Bounds>
>      <Insets>
>        <Top>3.0</Top>
>        <Left>3.0</Left>
>        <Bottom>3.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Row>-1</Row>
>      <Column>-1</Column>
>      <Rowspan>-1</Rowspan>
>      <Columnspan>-1</Columnspan>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </Outline>
>      <Background xsi:type="attribute:ColorDefinition">
>        <Transparency>0</Transparency>
>        <Red>255</Red>
>        <Green>255</Green>
>        <Blue>255</Blue>
>      </Background>
>      <Visible>true</Visible>
>      <HorizontalSpacing>5</HorizontalSpacing>
>      <VerticalSpacing>5</VerticalSpacing>
>      <ClientArea>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>0</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>0.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>0.0</Right>
>        </Insets>
>      </ClientArea>
>    </Children>
>    <Children xsi:type="layout:Legend">
>      <Bounds>
>        <Left>0.0</Left>
>        <Top>0.0</Top>
>        <Width>0.0</Width>
>        <Height>0.0</Height>
>      </Bounds>
>      <Insets>
>        <Top>3.0</Top>
>        <Left>3.0</Left>
>        <Bottom>3.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Row>-1</Row>
>      <Column>-1</Column>
>      <Rowspan>-1</Rowspan>
>      <Columnspan>-1</Columnspan>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </Outline>
>      <Visible>true</Visible>
>      <ClientArea>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>0</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <Insets>
>          <Top>2.0</Top>
>          <Left>2.0</Left>
>          <Bottom>2.0</Bottom>
>          <Right>2.0</Right>
>        </Insets>
>      </ClientArea>
>      <Text>
>        <Value></Value>
>        <Font>
>          <Alignment/>
>        </Font>
>      </Text>
>      <Orientation>Vertical</Orientation>
>      <Direction>Top_Bottom</Direction>
>      <Separator>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>true</Visible>
>      </Separator>
>      <Position>Right</Position>
>      <ItemType>Categories</ItemType>
>      <Title>
>        <Caption>
>          <Value></Value>
>          <Font>
>            <Alignment/>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>false</Visible>
>      </Title>
>      <TitlePosition>Above</TitlePosition>
>    </Children>
>    <Bounds>
>      <Left>0.0</Left>
>      <Top>0.0</Top>
>      <Width>450.0</Width>
>      <Height>150.0</Height>
>    </Bounds>
>    <Insets>
>      <Top>3.0</Top>
>      <Left>3.0</Left>
>      <Bottom>3.0</Bottom>
>      <Right>3.0</Right>
>    </Insets>
>    <Row>-1</Row>
>    <Column>-1</Column>
>    <Rowspan>-1</Rowspan>
>    <Columnspan>-1</Columnspan>
>    <Outline>
>      <Style>Solid</Style>
>      <Thickness>1</Thickness>
>      <Color>
>        <Transparency>255</Transparency>
>        <Red>0</Red>
>        <Green>0</Green>
>        <Blue>0</Blue>
>      </Color>
>      <Visible>false</Visible>
>    </Outline>
>    <Background xsi:type="attribute:ColorDefinition">
>      <Transparency>255</Transparency>
>      <Red>255</Red>
>      <Green>255</Green>
>      <Blue>255</Blue>
>    </Background>
>    <Visible>true</Visible>
>  </Block>
>  <Dimension>Two_Dimensional</Dimension>
>  <Units>Points</Units>
>  <SeriesThickness>10.0</SeriesThickness>
>  <SampleData>
>    <BaseSampleData>
>      <DataSetRepresentation>A, B, C</DataSetRepresentation>
>    </BaseSampleData>
>    <OrthogonalSampleData>
>      <DataSetRepresentation>5,4,12</DataSetRepresentation>
>      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>    </OrthogonalSampleData>
>  </SampleData>
>  <Interactivity>
>    <Enable>false</Enable>
>    <LegendBehavior>HighlightSerie</LegendBehavior>
>  </Interactivity>
>  <Axes>
>    <Type>Text</Type>
>    <Title>
>      <Caption>
>        <Value></Value>
>        <Font>
>          <Size>14.0</Size>
>          <Bold>true</Bold>
>          <Alignment>
>            <horizontalAlignment>Center</horizontalAlignment>
>            <verticalAlignment>Center</verticalAlignment>
>          </Alignment>
>        </Font>
>      </Caption>
>      <Background xsi:type="attribute:ColorDefinition">
>        <Transparency>0</Transparency>
>        <Red>255</Red>
>        <Green>255</Green>
>        <Blue>255</Blue>
>      </Background>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>      </Outline>
>      <Insets>
>        <Top>0.0</Top>
>        <Left>2.0</Left>
>        <Bottom>0.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Visible>false</Visible>
>    </Title>
>    <TitlePosition>Below</TitlePosition>
>    <AssociatedAxes>
>      <Type>Linear</Type>
>      <Title>
>        <Caption>
>          <Value>Y-Axis Title</Value>
>          <Font>
>            <Size>14.0</Size>
>            <Bold>true</Bold>
>            <Alignment>
>              <horizontalAlignment>Center</horizontalAlignment>
>              <verticalAlignment>Center</verticalAlignment>
>            </Alignment>
>            <Rotation>90.0</Rotation>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>false</Visible>
>      </Title>
>      <TitlePosition>Left</TitlePosition>
>      <SeriesDefinitions>
>        <Query>
>          <Definition></Definition>
>        </Query>
>        <SeriesPalette>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>80</Red>
>            <Green>166</Green>
>            <Blue>218</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>242</Red>
>            <Green>88</Green>
>            <Blue>106</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>232</Red>
>            <Green>172</Green>
>            <Blue>57</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>128</Red>
>            <Green>255</Green>
>            <Blue>128</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>64</Red>
>            <Green>128</Green>
>            <Blue>128</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>128</Red>
>            <Green>128</Green>
>            <Blue>192</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>170</Red>
>            <Green>85</Green>
>            <Blue>85</Blue>
>          </Entries>
>          <Entries xsi:type="attribute:ColorDefinition">
>            <Transparency>255</Transparency>
>            <Red>128</Red>
>            <Green>128</Green>
>            <Blue>0</Blue>
>          </Entries>
>        </SeriesPalette>
>        <Series xsi:type="type:BarSeries">
>          <Visible>true</Visible>
>          <Label>
>            <Caption>
>              <Value></Value>
>              <Font>
>                <Alignment/>
>              </Font>
>            </Caption>
>            <Background xsi:type="attribute:ColorDefinition">
>              <Transparency>0</Transparency>
>              <Red>255</Red>
>              <Green>255</Green>
>              <Blue>255</Blue>
>            </Background>
>            <Outline>
>              <Style>Solid</Style>
>              <Thickness>1</Thickness>
>              <Color>
>                <Transparency>255</Transparency>
>                <Red>0</Red>
>                <Green>0</Green>
>                <Blue>0</Blue>
>              </Color>
>              <Visible>false</Visible>
>            </Outline>
>            <Insets>
>              <Top>0.0</Top>
>              <Left>2.0</Left>
>              <Bottom>0.0</Bottom>
>              <Right>3.0</Right>
>            </Insets>
>            <Visible>false</Visible>
>          </Label>
>          <DataDefinition>
>            <Definition>row[&quot;count(*)_1&quot;]</Definition>
>          </DataDefinition>
>          <SeriesIdentifier>Hits</SeriesIdentifier>
>          <DataPoint>
>            <Components>
>              <Type>Orthogonal_Value</Type>
>            </Components>
>            <Prefix></Prefix>
>            <Separator>, </Separator>
>          </DataPoint>
>          <LabelPosition>Outside</LabelPosition>
>          <Stacked>false</Stacked>
>          <Translucent>true</Translucent>
>          <Riser>Rectangle</Riser>
>        </Series>
>        <Grouping>
>          <Enabled>false</Enabled>
>          <GroupingInterval>2</GroupingInterval>
>          <GroupType>Text</GroupType>
>          <AggregateExpression>Sum</AggregateExpression>
>        </Grouping>
>      </SeriesDefinitions>
>      <Orientation>Vertical</Orientation>
>      <LineAttributes>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>        <Visible>true</Visible>
>      </LineAttributes>
>      <Label>
>        <Caption>
>          <Value></Value>
>          <Font>
>            <Alignment/>
>          </Font>
>        </Caption>
>        <Background xsi:type="attribute:ColorDefinition">
>          <Transparency>0</Transparency>
>          <Red>255</Red>
>          <Green>255</Green>
>          <Blue>255</Blue>
>        </Background>
>        <Outline>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>        </Outline>
>        <Insets>
>          <Top>0.0</Top>
>          <Left>2.0</Left>
>          <Bottom>0.0</Bottom>
>          <Right>3.0</Right>
>        </Insets>
>        <Visible>true</Visible>
>      </Label>
>      <LabelPosition>Left</LabelPosition>
>      <MarkerLines>
>        <LineAttributes>
>          <Style>Dashed</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>255</Red>
>            <Green>0</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>true</Visible>
>        </LineAttributes>
>        <Value xsi:type="data:NumberDataElement">
>          <Value>10000.0</Value>
>        </Value>
>        <Label>
>          <Caption>
>            <Value>10000</Value>
>            <Font>
>              <Name>Arial</Name>
>              <Size>10.0</Size>
>              <Bold>true</Bold>
>              <Alignment/>
>            </Font>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>254</Red>
>              <Green>0</Green>
>              <Blue>0</Blue>
>            </Color>
>          </Caption>
>          <Background xsi:type="attribute:ColorDefinition">
>            <Transparency>0</Transparency>
>            <Red>255</Red>
>            <Green>255</Green>
>            <Blue>255</Blue>
>          </Background>
>          <Outline>
>            <Style>Solid</Style>
>            <Thickness>1</Thickness>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>0</Green>
>              <Blue>0</Blue>
>            </Color>
>          </Outline>
>          <Insets>
>            <Top>0.0</Top>
>            <Left>2.0</Left>
>            <Bottom>0.0</Bottom>
>            <Right>3.0</Right>
>          </Insets>
>          <Visible>true</Visible>
>        </Label>
>        <LabelAnchor>North_East</LabelAnchor>
>      </MarkerLines>
>      <MarkerLines>
>        <LineAttributes>
>          <Style>Dashed</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>0</Red>
>            <Green>128</Green>
>            <Blue>0</Blue>
>          </Color>
>          <Visible>true</Visible>
>        </LineAttributes>
>        <Value xsi:type="data:NumberDataElement">
>          <Value>7000.0</Value>
>        </Value>
>        <Label>
>          <Caption>
>            <Value>7000</Value>
>            <Font>
>              <Name>Arial</Name>
>              <Size>10.0</Size>
>              <Bold>true</Bold>
>              <Alignment/>
>            </Font>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>128</Green>
>              <Blue>0</Blue>
>            </Color>
>          </Caption>
>          <Background xsi:type="attribute:ColorDefinition">
>            <Transparency>0</Transparency>
>            <Red>255</Red>
>            <Green>255</Green>
>            <Blue>255</Blue>
>          </Background>
>          <Outline>
>            <Style>Solid</Style>
>            <Thickness>1</Thickness>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>0</Green>
>              <Blue>0</Blue>
>            </Color>
>          </Outline>
>          <Insets>
>            <Top>0.0</Top>
>            <Left>2.0</Left>
>            <Bottom>0.0</Bottom>
>            <Right>3.0</Right>
>          </Insets>
>          <Visible>true</Visible>
>        </Label>
>        <LabelAnchor>North_East</LabelAnchor>
>      </MarkerLines>
>      <MajorGrid>
>        <LineAttributes>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>196</Red>
>            <Green>196</Green>
>            <Blue>196</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </LineAttributes>
>        <TickStyle>Across</TickStyle>
>        <TickAttributes>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>196</Red>
>            <Green>196</Green>
>            <Blue>196</Blue>
>          </Color>
>          <Visible>true</Visible>
>        </TickAttributes>
>      </MajorGrid>
>      <MinorGrid>
>        <LineAttributes>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>225</Red>
>            <Green>225</Green>
>            <Blue>225</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </LineAttributes>
>        <TickStyle>Across</TickStyle>
>        <TickAttributes>
>          <Style>Solid</Style>
>          <Thickness>1</Thickness>
>          <Color>
>            <Transparency>255</Transparency>
>            <Red>225</Red>
>            <Green>225</Green>
>            <Blue>225</Blue>
>          </Color>
>          <Visible>false</Visible>
>        </TickAttributes>
>      </MinorGrid>
>      <Scale>
>        <MinorGridsPerUnit>5</MinorGridsPerUnit>
>      </Scale>
>      <Origin>
>        <Type>Min</Type>
>        <Value xsi:type="data:NumberDataElement">
>          <Value>0.0</Value>
>        </Value>
>      </Origin>
>      <PrimaryAxis>true</PrimaryAxis>
>      <Percent>false</Percent>
>    </AssociatedAxes>
>    <SeriesDefinitions>
>      <Query>
>        <Definition></Definition>
>      </Query>
>      <SeriesPalette>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>80</Red>
>          <Green>166</Green>
>          <Blue>218</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>242</Red>
>          <Green>88</Green>
>          <Blue>106</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>232</Red>
>          <Green>172</Green>
>          <Blue>57</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>128</Red>
>          <Green>255</Green>
>          <Blue>128</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>64</Red>
>          <Green>128</Green>
>          <Blue>128</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>128</Red>
>          <Green>128</Green>
>          <Blue>192</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>170</Red>
>          <Green>85</Green>
>          <Blue>85</Blue>
>        </Entries>
>        <Entries xsi:type="attribute:ColorDefinition">
>          <Transparency>255</Transparency>
>          <Red>128</Red>
>          <Green>128</Green>
>          <Blue>0</Blue>
>        </Entries>
>      </SeriesPalette>
>      <Series>
>        <Visible>true</Visible>
>        <Label>
>          <Caption>
>            <Value></Value>
>            <Font>
>              <Alignment/>
>            </Font>
>          </Caption>
>          <Background xsi:type="attribute:ColorDefinition">
>            <Transparency>0</Transparency>
>            <Red>255</Red>
>            <Green>255</Green>
>            <Blue>255</Blue>
>          </Background>
>          <Outline>
>            <Style>Solid</Style>
>            <Thickness>1</Thickness>
>            <Color>
>              <Transparency>255</Transparency>
>              <Red>0</Red>
>              <Green>0</Green>
>              <Blue>0</Blue>
>            </Color>
>            <Visible>false</Visible>
>          </Outline>
>          <Insets>
>            <Top>0.0</Top>
>            <Left>2.0</Left>
>            <Bottom>0.0</Bottom>
>            <Right>3.0</Right>
>          </Insets>
>          <Visible>false</Visible>
>        </Label>
>        <DataDefinition>
>          <Definition>row[&quot;v_sysid&quot;]</Definition>
>        </DataDefinition>
>        <SeriesIdentifier></SeriesIdentifier>
>        <DataPoint>
>          <Components>
>            <Type>Orthogonal_Value</Type>
>          </Components>
>          <Separator>, </Separator>
>        </DataPoint>
>        <LabelPosition>Outside</LabelPosition>
>        <Stacked>false</Stacked>
>      </Series>
>      <Grouping>
>        <Enabled>false</Enabled>
>        <GroupingInterval>2</GroupingInterval>
>        <GroupType>Text</GroupType>
>        <AggregateExpression>Sum</AggregateExpression>
>      </Grouping>
>    </SeriesDefinitions>
>    <Orientation>Horizontal</Orientation>
>    <LineAttributes>
>      <Style>Solid</Style>
>      <Thickness>1</Thickness>
>      <Color>
>        <Transparency>255</Transparency>
>        <Red>0</Red>
>        <Green>0</Green>
>        <Blue>0</Blue>
>      </Color>
>      <Visible>true</Visible>
>    </LineAttributes>
>    <Label>
>      <Caption>
>        <Value></Value>
>        <Font>
>          <Alignment/>
>          <Rotation>90.0</Rotation>
>        </Font>
>      </Caption>
>      <Background xsi:type="attribute:ColorDefinition">
>        <Transparency>0</Transparency>
>        <Red>255</Red>
>        <Green>255</Green>
>        <Blue>255</Blue>
>      </Background>
>      <Outline>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>0</Red>
>          <Green>0</Green>
>          <Blue>0</Blue>
>        </Color>
>      </Outline>
>      <Insets>
>        <Top>0.0</Top>
>        <Left>2.0</Left>
>        <Bottom>0.0</Bottom>
>        <Right>3.0</Right>
>      </Insets>
>      <Visible>true</Visible>
>    </Label>
>    <LabelPosition>Below</LabelPosition>
>    <MajorGrid>
>      <LineAttributes>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>196</Red>
>          <Green>196</Green>
>          <Blue>196</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </LineAttributes>
>      <TickStyle>Across</TickStyle>
>      <TickAttributes>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>196</Red>
>          <Green>196</Green>
>          <Blue>196</Blue>
>        </Color>
>        <Visible>true</Visible>
>      </TickAttributes>
>    </MajorGrid>
>    <MinorGrid>
>      <LineAttributes>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>225</Red>
>          <Green>225</Green>
>          <Blue>225</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </LineAttributes>
>      <TickStyle>Across</TickStyle>
>      <TickAttributes>
>        <Style>Solid</Style>
>        <Thickness>1</Thickness>
>        <Color>
>          <Transparency>255</Transparency>
>          <Red>225</Red>
>          <Green>225</Green>
>          <Blue>225</Blue>
>        </Color>
>        <Visible>false</Visible>
>      </TickAttributes>
>    </MinorGrid>
>    <Scale>
>      <MinorGridsPerUnit>5</MinorGridsPerUnit>
>    </Scale>
>    <Origin>
>      <Type>Min</Type>
>      <Value xsi:type="data:NumberDataElement">
>        <Value>0.0</Value>
>      </Value>
>    </Origin>
>    <PrimaryAxis>true</PrimaryAxis>
>    <CategoryAxis>true</CategoryAxis>
>    <Percent>false</Percent>
>  </Axes>
>  <Orientation>Vertical</Orientation>
>  <UnitSpacing>50.0</UnitSpacing>
>  <Rotation/>
></model:ChartWithAxes>
>]]></xml-property>
>                                <property name="outputFormat">SVG</property>
>                            </extended-item>
>                            <table id="144">
>                                <property name="fontFamily">"Arial"</property>
>                                <property name="width">100%</property>
>                                <property name="dataSet">SiteDetail</property>
>                                <list-property name="paramBindings">
>                                    <structure>
>                                        <property name="paramName">site</property>
>                                        <expression name="expression">row["Site"]</expression>
>                                    </structure>
>                                </list-property>
>                                <list-property name="boundDataColumns">
>                                    <structure>
>                                        <property name="name">v_sysid</property>
>                                        <expression name="expression">dataSetRow["v_sysid"]</expression>
>                                        <property name="dataType">string</property>
>                                    </structure>
>                                    <structure>
>                                        <property name="name">count(*)</property>
>                                        <expression name="expression">dataSetRow["count(*)"]</expression>
>                                        <property name="dataType">decimal</property>
>                                    </structure>
>                                </list-property>
>                                <column id="158"/>
>                                <column id="159"/>
>                                <header>
>                                    <row id="145">
>                                        <property name="backgroundColor">#FF8040</property>
>                                        <property name="fontFamily">"Arial"</property>
>                                        <property name="fontWeight">bold</property>
>                                        <cell id="146">
>                                            <label id="147">
>                                                <property name="fontFamily">"Arial"</property>
>                                                <property name="fontSize">large</property>
>                                                <text-property name="text">Server</text-property>
>                                            </label>
>                                        </cell>
>                                        <cell id="148">
>                                            <label id="149">
>                                                <text-property name="text">Hits</text-property>
>                                            </label>
>                                        </cell>
>                                    </row>
>                                </header>
>                                <detail>
>                                    <row id="150">
>                                        <cell id="151">
>                                            <data id="152">
>                                                <property name="resultSetColumn">v_sysid</property>
>                                            </data>
>                                        </cell>
>                                        <cell id="153">
>                                            <data id="154">
>                                                <property name="resultSetColumn">count(*)</property>
>                                            </data>
>                                        </cell>
>                                    </row>
>                                </detail>
>                            </table>
>                            <grid id="109">
>                                <property name="fontFamily">"Arial"</property>
>                                <property name="fontWeight">bold</property>
>                                <property name="width">100%</property>
>                                <column id="110"/>
>                                <column id="111"/>
>                                <row id="112">
>                                    <property name="backgroundColor">#C0C0C0</property>
>                                    <cell id="113">
>                                        <label id="107">
>                                            <property name="pageBreakAfter">always</property>
>                                            <text-property name="text">Total Hits</text-property>
>                                        </label>
>                                    </cell>
>                                    <cell id="114">
>                                        <data id="115">
>                                            <property name="resultSetColumn">count(*)</property>
>                                        </data>
>                                    </cell>
>                                </row>
>                            </grid>
>                        </detail>
>                    </list>
>                </cell>
>            </row>
>        </grid>
>    </body>
></report>

Actions: View

Attachments on bug 147101: 47602 | 75177