- <?xml version="1.0" encoding="UTF-8"?>
- <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
- <property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208 Build <2.5.2.v20100210-0630></property>
- <property name="units">in</property>
- <property name="iconFile">/templates/blank_report.gif</property>
- <property name="bidiLayoutOrientation">ltr</property>
- <parameters>
- <scalar-parameter name="since" id="9">
- <text-property name="helpText">ex. 2009-12-15 00:00:00</text-property>
- <text-property name="promptText">Unused since</text-property>
- <property name="valueType">static</property>
- <property name="isRequired">false</property>
- <property name="dataType">string</property>
- <property name="distinct">true</property>
- <simple-property-list name="defaultValue">
- <value type="javascript">var date=new Date(); (date.getFullYear()-1)+"-"+(date.getMonth()+1)+"-"+date.getDate()+" "+date.getHours()+":"+date.getMinutes()+":"+date.getSeconds();</value>
- </simple-property-list>
- <property name="paramType">simple</property>
- <property name="controlType">text-box</property>
- <structure name="format">
- <property name="category">Unformatted</property>
- </structure>
- </scalar-parameter>
- </parameters>
- <data-sources>
- <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
- <list-property name="privateDriverProperties">
- <ex-property>
- <name>contentBidiFormatStr</name>
- <value>ILYNN</value>
- </ex-property>
- <ex-property>
- <name>metadataBidiFormatStr</name>
- <value>ILYNN</value>
- </ex-property>
- </list-property>
- <property name="odaDriverClass">JDBC_DRIVER</property>
- <property name="odaURL">jdbc:uri</property>
- <property name="odaUser">user</property>
- <encrypted-property name="odaPassword" encryptionID="base64">cGFzc3dvcmQ=</encrypted-property>
- </oda-data-source>
- </data-sources>
- <data-sets>
- <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="8">
- <list-property name="columnHints">
- <structure>
- <property name="columnName">owner</property>
- <text-property name="displayName">owner</text-property>
- </structure>
- <structure>
- <property name="columnName">name</property>
- <text-property name="displayName">name</text-property>
- </structure>
- <structure>
- <property name="columnName">access</property>
- <text-property name="displayName">access</text-property>
- </structure>
- <structure>
- <property name="columnName">mount</property>
- <text-property name="displayName">mount</text-property>
- </structure>
- <structure>
- <property name="columnName">desc</property>
- <text-property name="displayName">desc</text-property>
- </structure>
- </list-property>
- <list-property name="parameters">
- <structure>
- <property name="name">Since_date</property>
- <property name="paramName">since</property>
- <property name="dataType">string</property>
- <property name="position">1</property>
- <property name="isInput">true</property>
- <property name="isOutput">false</property>
- </structure>
- </list-property>
- <structure name="cachedMetaData">
- <list-property name="resultSet">
- <structure>
- <property name="position">1</property>
- <property name="name">owner</property>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="position">2</property>
- <property name="name">name</property>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="position">3</property>
- <property name="name">access</property>
- <property name="dataType">date-time</property>
- </structure>
- <structure>
- <property name="position">4</property>
- <property name="name">mount</property>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="position">5</property>
- <property name="name">desc</property>
- <property name="dataType">string</property>
- </structure>
- </list-property>
- </structure>
- <property name="dataSource">Data Source</property>
- <list-property name="resultSet">
- <structure>
- <property name="position">1</property>
- <property name="name">owner</property>
- <property name="nativeName">owner</property>
- <property name="dataType">string</property>
- <property name="nativeDataType">12</property>
- </structure>
- <structure>
- <property name="position">2</property>
- <property name="name">name</property>
- <property name="nativeName">name</property>
- <property name="dataType">string</property>
- <property name="nativeDataType">12</property>
- </structure>
- <structure>
- <property name="position">3</property>
- <property name="name">access</property>
- <property name="nativeName">access</property>
- <property name="dataType">date-time</property>
- <property name="nativeDataType">93</property>
- </structure>
- <structure>
- <property name="position">4</property>
- <property name="name">mount</property>
- <property name="nativeName">mount</property>
- <property name="dataType">string</property>
- <property name="nativeDataType">12</property>
- </structure>
- <structure>
- <property name="position">5</property>
- <property name="name">desc</property>
- <property name="nativeName">desc</property>
- <property name="dataType">string</property>
- <property name="nativeDataType">12</property>
- </structure>
- </list-property>
- <xml-property name="queryText"><![CDATA[select c.owner, c.name, c.access, c.mount, c.desc
- from perforce.clients c
- where c.access < ?]]></xml-property>
- </oda-data-set>
- <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Chart Data Set1" id="68">
- <list-property name="parameters">
- <structure>
- <property name="name">since</property>
- <property name="paramName">since</property>
- <property name="dataType">string</property>
- <property name="position">1</property>
- <property name="isInput">true</property>
- <property name="isOutput">false</property>
- </structure>
- </list-property>
- <structure name="cachedMetaData">
- <list-property name="resultSet">
- <structure>
- <property name="position">1</property>
- <property name="name">owner</property>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="position">2</property>
- <property name="name">cli_count</property>
- <property name="dataType">decimal</property>
- </structure>
- </list-property>
- </structure>
- <property name="dataSource">Data Source</property>
- <list-property name="resultSet">
- <structure>
- <property name="position">1</property>
- <property name="name">owner</property>
- <property name="nativeName">owner</property>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="position">2</property>
- <property name="name">cli_count</property>
- <property name="nativeName">cli_count</property>
- <property name="dataType">decimal</property>
- </structure>
- </list-property>
- <xml-property name="queryText"><![CDATA[select distinct(c.owner), count(c.name) as cli_count
- from perforce.clients c
- where c.access < ?
- group by c.owner
- order by cli_count desc
- limit 10;]]></xml-property>
- </oda-data-set>
- </data-sets>
- <styles>
- <style name="report" id="4">
- <property name="fontFamily">sans-serif</property>
- <property name="fontSize">10pt</property>
- </style>
- <style name="crosstab" id="5">
- <property name="borderBottomColor">#CCCCCC</property>
- <property name="borderBottomStyle">solid</property>
- <property name="borderBottomWidth">1pt</property>
- <property name="borderLeftColor">#CCCCCC</property>
- <property name="borderLeftStyle">solid</property>
- <property name="borderLeftWidth">1pt</property>
- <property name="borderRightColor">#CCCCCC</property>
- <property name="borderRightStyle">solid</property>
- <property name="borderRightWidth">1pt</property>
- <property name="borderTopColor">#CCCCCC</property>
- <property name="borderTopStyle">solid</property>
- <property name="borderTopWidth">1pt</property>
- </style>
- <style name="crosstab-cell" id="6">
- <property name="borderBottomColor">#CCCCCC</property>
- <property name="borderBottomStyle">solid</property>
- <property name="borderBottomWidth">1pt</property>
- <property name="borderLeftColor">#CCCCCC</property>
- <property name="borderLeftStyle">solid</property>
- <property name="borderLeftWidth">1pt</property>
- <property name="borderRightColor">#CCCCCC</property>
- <property name="borderRightStyle">solid</property>
- <property name="borderRightWidth">1pt</property>
- <property name="borderTopColor">#CCCCCC</property>
- <property name="borderTopStyle">solid</property>
- <property name="borderTopWidth">1pt</property>
- </style>
- </styles>
- <page-setup>
- <simple-master-page name="Simple MasterPage" id="2">
- <page-footer>
- <text id="3">
- <property name="contentType">html</property>
- <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
- </text>
- </page-footer>
- </simple-master-page>
- </page-setup>
- <body>
- <text id="60">
- <property name="contentType">html</property>
- <text-property name="content"><![CDATA[<CENTER><B><span style="font-size: larger">
- Clients Not Used
- </B></span><BR>
- <BR><BR>
- Report generated on <VALUE-OF>new Date( )</VALUE-OF>
- </CENTER><BR><BR>]]></text-property>
- </text>
- <grid id="61">
- <column id="62"/>
- <row id="63">
- <cell id="64">
- <extended-item extensionName="Chart" id="67">
- <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">
- <Version>2.5.1</Version>
- <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>true</Visible>
- <Label>
- <Caption>
- <Value>Clients Not Used Count</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>
- <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>564.0</Width>
- <Height>130.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_With_Depth</Dimension>
- <Units>Points</Units>
- <SeriesThickness>10.0</SeriesThickness>
- <ExtendedProperties>
- <Name>enable.area.alt</Name>
- <Value>false</Value>
- </ExtendedProperties>
- <SampleData>
- <BaseSampleData>
- <DataSetRepresentation>A, B, C</DataSetRepresentation>
- </BaseSampleData>
- <OrthogonalSampleData>
- <DataSetRepresentation>5,4,12</DataSetRepresentation>
- <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
- </OrthogonalSampleData>
- </SampleData>
- <Interactivity/>
- <EmptyMessage>
- <Caption>
- <Value>This chart contains no data.</Value>
- <Font>
- <Alignment>
- <horizontalAlignment>Center</horizontalAlignment>
- <verticalAlignment>Center</verticalAlignment>
- </Alignment>
- </Font>
- </Caption>
- <Background xsi:type="attribute:ColorDefinition">
- <Transparency>64</Transparency>
- <Red>127</Red>
- <Green>127</Green>
- <Blue>127</Blue>
- </Background>
- <Outline>
- <Color>
- <Transparency>128</Transparency>
- <Red>127</Red>
- <Green>127</Green>
- <Blue>127</Blue>
- </Color>
- <Visible>true</Visible>
- </Outline>
- <Insets>
- <Top>10.0</Top>
- <Left>10.0</Left>
- <Bottom>10.0</Bottom>
- <Right>10.0</Right>
- </Insets>
- <Visible>false</Visible>
- </EmptyMessage>
- <Axes>
- <Type>Text</Type>
- <Title>
- <Caption>
- <Value>X-Axis Title</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>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>192</Red>
- <Green>192</Green>
- <Blue>192</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>255</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>192</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>7</Red>
- <Green>146</Green>
- <Blue>94</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>128</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>192</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>255</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>128</Green>
- <Blue>192</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>255</Red>
- <Green>0</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>64</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>80</Red>
- <Green>240</Green>
- <Blue>120</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>64</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>0</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>0</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>128</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>128</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>64</Green>
- <Blue>0</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>0</Green>
- <Blue>0</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>255</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</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["cli_count"]</Definition>
- <Grouping>
- <GroupType>Text</GroupType>
- <AggregateExpression>Sum</AggregateExpression>
- </Grouping>
- </DataDefinition>
- <SeriesIdentifier>Series 1</SeriesIdentifier>
- <DataPoint>
- <Components>
- <Type>Orthogonal_Value</Type>
- </Components>
- <Separator>, </Separator>
- </DataPoint>
- <LabelPosition>Outside</LabelPosition>
- <Stacked>false</Stacked>
- <Riser>Rectangle</Riser>
- </Series>
- <Grouping>
- <GroupType>Text</GroupType>
- <AggregateExpression>Sum</AggregateExpression>
- </Grouping>
- </SeriesDefinitions>
- <Orientation>Vertical</Orientation>
- <LineAttributes>
- <Style>Solid</Style>
- <Thickness>1</Thickness>
- <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>
- <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>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>192</Red>
- <Green>192</Green>
- <Blue>192</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>255</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>192</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>7</Red>
- <Green>146</Green>
- <Blue>94</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>128</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>192</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>255</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>128</Green>
- <Blue>192</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>255</Red>
- <Green>0</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>64</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>80</Red>
- <Green>240</Green>
- <Blue>120</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>64</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>0</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>0</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>128</Green>
- <Blue>64</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>128</Red>
- <Green>128</Green>
- <Blue>128</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>128</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>64</Green>
- <Blue>0</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>0</Red>
- <Green>0</Green>
- <Blue>0</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</Red>
- <Green>255</Green>
- <Blue>255</Blue>
- </Entries>
- <Entries xsi:type="attribute:ColorDefinition">
- <Transparency>255</Transparency>
- <Red>255</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["owner"]</Definition>
- </DataDefinition>
- <SeriesIdentifier></SeriesIdentifier>
- <DataPoint>
- <Components>
- <Type>Orthogonal_Value</Type>
- </Components>
- <Separator>, </Separator>
- </DataPoint>
- <LabelPosition>Outside</LabelPosition>
- <Stacked>false</Stacked>
- </Series>
- <Grouping>
- <Enabled>true</Enabled>
- <GroupType>Text</GroupType>
- <AggregateExpression>Sum</AggregateExpression>
- </Grouping>
- </SeriesDefinitions>
- <Orientation>Horizontal</Orientation>
- <LineAttributes>
- <Style>Solid</Style>
- <Thickness>1</Thickness>
- <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>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>
- <property name="inheritColumns">false</property>
- <property name="dataSet">Chart Data Set1</property>
- <property name="height">130pt</property>
- <property name="width">7.833333333333333in</property>
- <list-property name="boundDataColumns">
- <structure>
- <property name="name">owner</property>
- <expression name="expression" type="javascript">dataSetRow["owner"]</expression>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="name">cli_count</property>
- <expression name="expression" type="javascript">dataSetRow["cli_count"]</expression>
- <property name="dataType">decimal</property>
- </structure>
- </list-property>
- </extended-item>
- </cell>
- </row>
- <row id="65">
- <cell id="66">
- <table id="10">
- <property name="width">100%</property>
- <property name="dataSet">Data Set</property>
- <list-property name="boundDataColumns">
- <structure>
- <property name="name">owner</property>
- <expression name="expression">dataSetRow["owner"]</expression>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="name">client</property>
- <text-property name="displayName">client</text-property>
- <expression name="expression" type="javascript">dataSetRow["name"]</expression>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="name">accessed</property>
- <text-property name="displayName">accessed</text-property>
- <expression name="expression" type="javascript">dataSetRow["access"]</expression>
- <property name="dataType">date-time</property>
- </structure>
- <structure>
- <property name="name">root</property>
- <text-property name="displayName">root</text-property>
- <expression name="expression" type="javascript">dataSetRow["mount"]</expression>
- <property name="dataType">string</property>
- </structure>
- <structure>
- <property name="name">description</property>
- <text-property name="displayName">description</text-property>
- <expression name="expression" type="javascript">dataSetRow["desc"]</expression>
- <property name="dataType">string</property>
- </structure>
- </list-property>
- <column id="57">
- <property name="width">7%</property>
- </column>
- <column id="26">
- <property name="width">20%</property>
- </column>
- <column id="27">
- <property name="width">18%</property>
- </column>
- <column id="28">
- <property name="width">37%</property>
- </column>
- <column id="29">
- <property name="width">17%</property>
- </column>
- <header>
- <row id="11">
- <cell id="52">
- <label id="58">
- <property name="backgroundColor">#529EB5</property>
- <property name="fontWeight">bold</property>
- <text-property name="text">Owner</text-property>
- </label>
- </cell>
- <cell id="12">
- <label id="30">
- <property name="backgroundColor">#529EB5</property>
- <property name="fontWeight">bold</property>
- <text-property name="text">Client</text-property>
- </label>
- </cell>
- <cell id="13">
- <label id="34">
- <property name="backgroundColor">#529EB5</property>
- <property name="fontWeight">bold</property>
- <text-property name="text">Access Date</text-property>
- </label>
- </cell>
- <cell id="14">
- <label id="36">
- <property name="backgroundColor">#529EB5</property>
- <property name="fontWeight">bold</property>
- <text-property name="text">Root</text-property>
- </label>
- </cell>
- <cell id="15">
- <label id="38">
- <property name="backgroundColor">#529EB5</property>
- <property name="fontWeight">bold</property>
- <text-property name="text">Description</text-property>
- </label>
- </cell>
- </row>
- </header>
- <group id="40">
- <property name="groupName">Owner</property>
- <property name="interval">none</property>
- <property name="sortDirection">asc</property>
- <expression name="keyExpr" type="javascript">row["owner"]</expression>
- <structure name="toc">
- <expression name="expressionValue" type="javascript">row["owner"]</expression>
- </structure>
- <property name="repeatHeader">true</property>
- <property name="hideDetail">false</property>
- <property name="pageBreakAfter">auto</property>
- <property name="pageBreakBefore">auto</property>
- <property name="pageBreakInside">auto</property>
- <header>
- <row id="41">
- <cell id="53">
- <data id="59">
- <property name="resultSetColumn">owner</property>
- </data>
- </cell>
- <cell id="42"/>
- <cell id="43"/>
- <cell id="44"/>
- <cell id="45"/>
- </row>
- </header>
- <footer>
- <row id="46">
- <cell id="55"/>
- <cell id="47"/>
- <cell id="48"/>
- <cell id="49"/>
- <cell id="50"/>
- </row>
- </footer>
- </group>
- <detail>
- <row id="16">
- <cell id="54"/>
- <cell id="17">
- <data id="31">
- <property name="resultSetColumn">client</property>
- </data>
- </cell>
- <cell id="18">
- <data id="35">
- <property name="resultSetColumn">accessed</property>
- </data>
- </cell>
- <cell id="19">
- <data id="37">
- <property name="resultSetColumn">root</property>
- </data>
- </cell>
- <cell id="20">
- <data id="39">
- <property name="resultSetColumn">description</property>
- </data>
- </cell>
- </row>
- </detail>
- <footer>
- <row id="21">
- <cell id="56"/>
- <cell id="22"/>
- <cell id="23"/>
- <cell id="24"/>
- <cell id="25"/>
- </row>
- </footer>
- </table>
- </cell>
- </row>
- </grid>
- </body>
- </report>
# |
Change |
User |
Description |
Committed |
|
#2
|
7760 |
jkovisto |
Added charts to some reports.
Minor formatting changes in others.
ModsPastWeek reworked... into something perhaps more useful. « |
15 years ago
|
|
#1
|
7575 |
jkovisto |
Initial revision for BIRT report examples |
15 years ago
|
|