Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Paginate on Y-Series Group?(Would like to break out pages based on number of grouped results)
Paginate on Y-Series Group? [message #742537] Thu, 20 October 2011 15:31 Go to next message
robinsonjas  is currently offline robinsonjas
Messages: 21
Registered: October 2011
Junior Member
Is there a way in BIRT to create a chart on a new page based on the number of Y-Series grouped results? I have a query that will sometimes have 2 groups and sometimes have 22 groups based on the parameter given. If I have 22 groups the chart (a single page) gets awful crowded. Can I have it break out those 22 into multiple pages so it's easier to read?
Re: Paginate on Y-Series Group? [message #742576 is a reply to message #742537] Thu, 20 October 2011 16:07 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Why not add a table that is grouped on your groups and put a chart in
the group header or footer row (Delete detail rows) and do a page break
on every group?

Jason

On 10/20/2011 11:31 AM, robinsonjas wrote:
> Is there a way in BIRT to create a chart on a new page based on the
> number of Y-Series grouped results? I have a query that will sometimes
> have 2 groups and sometimes have 22 groups based on the parameter given.
> If I have 22 groups the chart (a single page) gets awful crowded. Can I
> have it break out those 22 into multiple pages so it's easier to read?
Re: Paginate on Y-Series Group? [message #742718 is a reply to message #742576] Thu, 20 October 2011 19:10 Go to previous messageGo to next message
robinsonjas  is currently offline robinsonjas
Messages: 21
Registered: October 2011
Junior Member
I'm getting only one group per page, can I change that arbitrarily to any number? I'd like to have up to 8 results per page.
Re: Paginate on Y-Series Group? [message #748266 is a reply to message #742718] Mon, 24 October 2011 15:43 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Have you tried to use group interval? Take a look at the attached
example that groups ordernumber for every four orders.

Jason

On 10/20/2011 3:10 PM, robinsonjas wrote:
> I'm getting only one group per page, can I change that arbitrarily to
> any number? I'd like to have up to 8 results per page.
Re: Paginate on Y-Series Group? [message #750284 is a reply to message #748266] Tue, 25 October 2011 18:16 Go to previous messageGo to next message
robinsonjas  is currently offline robinsonjas
Messages: 21
Registered: October 2011
Junior Member
I'm close, I can create groups...and it breaks up in pages like it's supposed to.
I see my first 6 sets of data in detail but after I page thru the details the chart only draws the first set...
Re: Paginate on Y-Series Group? [message #750405 is a reply to message #750284] Tue, 25 October 2011 19:28 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Are you putting the chart in the group footer?

Jason

On 10/25/2011 2:17 PM, robinsonjas wrote:
> I'm close, I can create groups...and it breaks up in pages like it's
> supposed to.
> I see my first 6 sets of data in detail but after I page thru the
> details the chart only draws the first set...
Re: Paginate on Y-Series Group? [message #750538 is a reply to message #750405] Tue, 25 October 2011 20:47 Go to previous messageGo to next message
robinsonjas  is currently offline robinsonjas
Messages: 21
Registered: October 2011
Junior Member
Yes, Chart in Group Footer...
Here is my XML Source:
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110905-1820></property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">8</property>
</structure>
<structure>
<property name="name">queryTimeOut</property>
<property name="id">8</property>
</structure>
<structure>
<property name="name">rowFetchSize</property>
<property name="id">8</property>
</structure>
</list-property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<scalar-parameter name="RP_lunmask" id="9">
<text-property name="promptText">Enter Lunmask (%sappr3p%):</text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Start" id="10">
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">dateTime</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">General Date</property>
<property name="pattern">General Date</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Finish" id="11">
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">dateTime</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">General Date</property>
<property name="pattern">General Date</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="TPCDB" id="7">
<list-property name="privateDriverProperties">
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
</list-property>
<property name="odaDriverClass">com.ibm.db2.jcc.DB2Driver</property>
<property name="odaURL">jdbc:db2://tpcsrv1:50000/TPCDB</property>
<property name="odaUser">db2inst1</property>
<encrypted-property name="odaPassword" encryptionID="base64">ZGIyaW5zdDE=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="IOPS" id="8">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">SVC_VDISK_ID</property>
<property name="analysis">dimension</property>
<text-property name="displayName">SVC_VDISK_ID</text-property>
<text-property name="heading">SVC_VDISK_ID</text-property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME</property>
<property name="analysis">attribute</property>
<text-property name="displayName">DISPLAY_NAME</text-property>
<text-property name="heading">DISPLAY_NAME</text-property>
</structure>
<structure>
<property name="columnName">READ_IO</property>
<property name="analysis">measure</property>
<text-property name="displayName">READ_IO</text-property>
<text-property name="heading">READ_IO</text-property>
</structure>
<structure>
<property name="columnName">WRITE_IO</property>
<property name="analysis">measure</property>
<text-property name="displayName">WRITE_IO</text-property>
<text-property name="heading">WRITE_IO</text-property>
</structure>
<structure>
<property name="columnName">PRF_TIMESTAMP</property>
<property name="analysis">dimension</property>
<text-property name="displayName">PRF_TIMESTAMP</text-property>
<text-property name="heading">PRF_TIMESTAMP</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">RP_lunmask</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">1</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">Start</property>
<property name="nativeName"></property>
<property name="dataType">dateTime</property>
<property name="nativeDataType">93</property>
<property name="position">2</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">Finish</property>
<property name="nativeName"></property>
<property name="dataType">dateTime</property>
<property name="nativeDataType">93</property>
<property name="position">3</property>
<property name="isOptional">true</property>
<property name="allowNull">true</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">SVC_VDISK_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">READ_IO</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">WRITE_IO</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRF_TIMESTAMP</property>
<property name="dataType">date-time</property>
</structure>
</list-property>
</structure>
<property name="dataSource">TPCDB</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SVC_VDISK_ID</property>
<property name="nativeName">SVC_VDISK_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">READ_IO</property>
<property name="nativeName">READ_IO</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">WRITE_IO</property>
<property name="nativeName">WRITE_IO</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRF_TIMESTAMP</property>
<property name="nativeName">PRF_TIMESTAMP</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT TPCREPORT.PRF_SVC_VDISK.SVC_VDISK_ID,TPCREPORT.STORAGEVOLUME.DISPLAY_NAME, INTEGER(TPCREPORT.PRF_SVC_VDISK.READ_IO)/300 AS READ_IO,
INTEGER(TPCREPORT.PRF_SVC_VDISK.WRITE_IO)/300 AS WRITE_IO,
TPCREPORT.PRF_SVC_VDISK.PRF_TIMESTAMP
FROM TPCREPORT.STORAGEVOLUME, TPCREPORT.PRF_SVC_VDISK
WHERE TPCREPORT.STORAGEVOLUME.DISPLAY_NAME
LIKE ?
AND TPCREPORT.PRF_SVC_VDISK.SVC_VDISK_ID=TPCREPORT.STORAGEVOLUME.STORAGE_VOLUME_ID
AND TPCREPORT.PRF_SVC_VDISK.PRF_TIMESTAMP BETWEEN ? AND ?
]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<DataSetParameters>
<parameter>
<design:ParameterDefinition>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:identifier>
<design:name></design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32672</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:ParameterDefinition>
</parameter>
<parameter>
<design:ParameterDefinition>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:identifier>
<design:name></design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>26</design:precision>
<design:scale>6</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:ParameterDefinition>
</parameter>
<parameter>
<design:ParameterDefinition>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:identifier>
<design:name></design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>26</design:precision>
<design:scale>6</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:ParameterDefinition>
</parameter>
</DataSetParameters>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>DISPLAY_NAME</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>256</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>DISPLAY_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>DISPLAY_NAME</design:label>
<design:formattingHints>
<design:displaySize>256</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>READ_IO</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>READ_IO</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>READ_IO</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>WRITE_IO</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>WRITE_IO</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>WRITE_IO</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>PRF_TIMESTAMP</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>26</design:precision>
<design:scale>6</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRF_TIMESTAMP</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRF_TIMESTAMP</design:label>
<design:formattingHints>
<design:displaySize>26</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></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-cell" 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" 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">
<property name="type">us-legal</property>
<property name="orientation">landscape</property>
<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>
<table id="728">
<property name="dataSet">IOPS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">SVC_VDISK_ID</property>
<text-property name="displayName">SVC_VDISK_ID</text-property>
<expression name="expression" type="javascript">dataSetRow["SVC_VDISK_ID"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">DISPLAY_NAME</property>
<text-property name="displayName">DISPLAY_NAME</text-property>
<expression name="expression" type="javascript">dataSetRow["DISPLAY_NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">READ_IO</property>
<text-property name="displayName">READ_IO</text-property>
<expression name="expression" type="javascript">dataSetRow["READ_IO"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">WRITE_IO</property>
<text-property name="displayName">WRITE_IO</text-property>
<expression name="expression" type="javascript">dataSetRow["WRITE_IO"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRF_TIMESTAMP</property>
<text-property name="displayName">PRF_TIMESTAMP</text-property>
<expression name="expression" type="javascript">dataSetRow["PRF_TIMESTAMP"]</expression>
<property name="dataType">date-time</property>
</structure>
</list-property>
<column id="757"/>
<column id="758"/>
<column id="759"/>
<column id="760"/>
<column id="761"/>
<header>
<row id="729">
<cell id="730">
<label id="731">
<text-property name="text">SVC_VDISK_ID</text-property>
</label>
</cell>
<cell id="732">
<label id="733">
<text-property name="text">DISPLAY_NAME</text-property>
</label>
</cell>
<cell id="734">
<label id="735">
<text-property name="text">READ_IO</text-property>
</label>
</cell>
<cell id="736">
<label id="737">
<text-property name="text">WRITE_IO</text-property>
</label>
</cell>
<cell id="738">
<label id="739">
<text-property name="text">PRF_TIMESTAMP</text-property>
</label>
</cell>
</row>
</header>
<group id="762">
<property name="groupName">NewTableGroup1</property>
<property name="interval">interval</property>
<property name="intervalRange">6.0</property>
<expression name="keyExpr" type="javascript">row["SVC_VDISK_ID"]</expression>
<structure name="toc">
<expression name="expressionValue" type="javascript">row["SVC_VDISK_ID"]</expression>
</structure>
<property name="repeatHeader">false</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">always</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="763">
<cell id="764">
<data id="775">
<property name="resultSetColumn">SVC_VDISK_ID</property>
</data>
</cell>
<cell id="765"/>
<cell id="766"/>
<cell id="767"/>
<cell id="768"/>
</row>
</header>
<footer>
<row id="769">
<property name="height">6.541666666666667in</property>
<cell id="770">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<extended-item extensionName="Chart" id="776">
<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>Line Chart</Type>
<SubType>Overlay</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>Line 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>
<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>Series</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>212.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>
<Visible>true</Visible>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Units>Points</Units>
<SeriesThickness>10.0</SeriesThickness>
<ExtendedProperties>
<Name>enable.area.alt</Name>
<Value>false</Value>
</ExtendedProperties>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>6,4,12,8,10</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>DateTime</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>row[&quot;DISPLAY_NAME&quot;]</Definition>
<Grouping>
<GroupType>Text</GroupType>
</Grouping>
</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=&quo
Re: Paginate on Y-Series Group? [message #752701 is a reply to message #750538] Wed, 26 October 2011 13:39 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you attach the report or email it to me at jasonweathersby at
windstream dot net.

Jason

On 10/25/2011 4:47 PM, robinsonjas wrote:
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905
> Build <3.7.1.v20110905-1820></property>
> <list-property name="propertyBindings">
> <structure>
> <property name="name">queryText</property>
> <property name="id">8</property>
> </structure>
> <structure>
> <property name="name">queryTimeOut</property>
> <property name="id">8</property>
> </structure>
> <structure>
> <property name="name">rowFetchSize</property>
> <property name="id">8</property>
> </structure>
> </list-property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <parameters>
> <scalar-parameter name="RP_lunmask" id="9">
> <text-property name="promptText">Enter Lunmask (%sappr3p%):</text-property>
> <property name="valueType">static</property>
> <property name="isRequired">true</property>
> <property name="dataType">string</property>
> <property name="distinct">true</property>
> <list-property name="selectionList"/>
> <property name="paramType">simple</property>
> <property name="concealValue">false</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Start" id="10">
> <property name="valueType">static</property>
> <property name="isRequired">true</property>
> <property name="dataType">dateTime</property>
> <property name="distinct">true</property>
> <list-property name="selectionList"/>
> <property name="paramType">simple</property>
> <property name="concealValue">false</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">General Date</property>
> <property name="pattern">General Date</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Finish" id="11">
> <property name="valueType">static</property>
> <property name="isRequired">true</property>
> <property name="dataType">dateTime</property>
> <property name="distinct">true</property>
> <list-property name="selectionList"/>
> <property name="paramType">simple</property>
> <property name="concealValue">false</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">General Date</property>
> <property name="pattern">General Date</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="TPCDB" id="7">
> <list-property name="privateDriverProperties">
> <ex-property>
> <name>metadataBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> <ex-property>
> <name>disabledMetadataBidiFormatStr</name>
> </ex-property>
> <ex-property>
> <name>contentBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> <ex-property>
> <name>disabledContentBidiFormatStr</name>
> </ex-property>
> </list-property>
> <property name="odaDriverClass">com.ibm.db2.jcc.DB2Driver</property>
> <property name="odaURL">jdbc:db2://tpcsrv1:50000/TPCDB</property>
> <property name="odaUser">db2inst1</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">ZGIyaW5zdDE=</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> name="IOPS" id="8">
> <property name="nullsOrdering">nulls lowest</property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">SVC_VDISK_ID</property>
> <property name="analysis">dimension</property>
> <text-property name="displayName">SVC_VDISK_ID</text-property>
> <text-property name="heading">SVC_VDISK_ID</text-property>
> </structure>
> <structure>
> <property name="columnName">DISPLAY_NAME</property>
> <property name="analysis">attribute</property>
> <text-property name="displayName">DISPLAY_NAME</text-property>
> <text-property name="heading">DISPLAY_NAME</text-property>
> </structure>
> <structure>
> <property name="columnName">READ_IO</property>
> <property name="analysis">measure</property>
> <text-property name="displayName">READ_IO</text-property>
> <text-property name="heading">READ_IO</text-property>
> </structure>
> <structure>
> <property name="columnName">WRITE_IO</property>
> <property name="analysis">measure</property>
> <text-property name="displayName">WRITE_IO</text-property>
> <text-property name="heading">WRITE_IO</text-property>
> </structure>
> <structure>
> <property name="columnName">PRF_TIMESTAMP</property>
> <property name="analysis">dimension</property>
> <text-property name="displayName">PRF_TIMESTAMP</text-property>
> <text-property name="heading">PRF_TIMESTAMP</text-property>
> </structure>
> </list-property>
> <list-property name="parameters">
> <structure>
> <property name="name">param_1</property>
> <property name="paramName">RP_lunmask</property>
> <property name="nativeName"></property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> <property name="position">1</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param_2</property>
> <property name="paramName">Start</property>
> <property name="nativeName"></property>
> <property name="dataType">dateTime</property>
> <property name="nativeDataType">93</property>
> <property name="position">2</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param_3</property>
> <property name="paramName">Finish</property>
> <property name="nativeName"></property>
> <property name="dataType">dateTime</property>
> <property name="nativeDataType">93</property>
> <property name="position">3</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</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">SVC_VDISK_ID</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">DISPLAY_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">READ_IO</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">WRITE_IO</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PRF_TIMESTAMP</property>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">TPCDB</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">SVC_VDISK_ID</property>
> <property name="nativeName">SVC_VDISK_ID</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">DISPLAY_NAME</property>
> <property name="nativeName">DISPLAY_NAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">READ_IO</property>
> <property name="nativeName">READ_IO</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">WRITE_IO</property>
> <property name="nativeName">WRITE_IO</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PRF_TIMESTAMP</property>
> <property name="nativeName">PRF_TIMESTAMP</property>
> <property name="dataType">date-time</property>
> <property name="nativeDataType">93</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[SELECT
> TPCREPORT.PRF_SVC_VDISK.SVC_VDISK_ID,TPCREPORT.STORAGEVOLUME.DISPLAY_NAME,
> INTEGER(TPCREPORT.PRF_SVC_VDISK.READ_IO)/300 AS READ_IO,
> INTEGER(TPCREPORT.PRF_SVC_VDISK.WRITE_IO)/300 AS WRITE_IO,
> TPCREPORT.PRF_SVC_VDISK.PRF_TIMESTAMP
> FROM TPCREPORT.STORAGEVOLUME, TPCREPORT.PRF_SVC_VDISK
> WHERE TPCREPORT.STORAGEVOLUME.DISPLAY_NAME LIKE ? AND
> TPCREPORT.PRF_SVC_VDISK.SVC_VDISK_ID=TPCREPORT.STORAGEVOLUME.STORAGE_VOLUME_ID
> AND TPCREPORT.PRF_SVC_VDISK.PRF_TIMESTAMP BETWEEN ? AND ?
> ]]></xml-property>
> <xml-property name="designerValues"><![CDATA[<?xml version="1.0"
> encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>2.0</Version>
> <DataSetParameters>
> <parameter>
> <design:ParameterDefinition>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:identifier>
> <design:name></design:name>
> <design:position>1</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>32672</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:ParameterDefinition>
> </parameter>
> <parameter>
> <design:ParameterDefinition>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:identifier>
> <design:name></design:name>
> <design:position>2</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
> <design:precision>26</design:precision>
> <design:scale>6</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:ParameterDefinition>
> </parameter>
> <parameter>
> <design:ParameterDefinition>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:identifier>
> <design:name></design:name>
> <design:position>3</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
> <design:precision>26</design:precision>
> <design:scale>6</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:ParameterDefinition>
> </parameter>
> </DataSetParameters>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>DISPLAY_NAME</design:name>
> <design:position>1</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>256</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>DISPLAY_NAME</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>DISPLAY_NAME</design:label>
> <design:formattingHints>
> <design:displaySize>256</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>READ_IO</design:name>
> <design:position>2</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>READ_IO</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>READ_IO</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>WRITE_IO</design:name>
> <design:position>3</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>WRITE_IO</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>WRITE_IO</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>PRF_TIMESTAMP</design:name>
> <design:position>4</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
> <design:precision>26</design:precision>
> <design:scale>6</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>PRF_TIMESTAMP</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>PRF_TIMESTAMP</design:label>
> <design:formattingHints>
> <design:displaySize>26</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> <design:criteria/>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></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-cell" 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" 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">
> <property name="type">us-legal</property>
> <property name="orientation">landscape</property>
> <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>
> <table id="728">
> <property name="dataSet">IOPS</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">SVC_VDISK_ID</property>
> <text-property name="displayName">SVC_VDISK_ID</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["SVC_VDISK_ID"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">DISPLAY_NAME</property>
> <text-property name="displayName">DISPLAY_NAME</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["DISPLAY_NAME"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">READ_IO</property>
> <text-property name="displayName">READ_IO</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["READ_IO"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">WRITE_IO</property>
> <text-property name="displayName">WRITE_IO</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["WRITE_IO"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRF_TIMESTAMP</property>
> <text-property name="displayName">PRF_TIMESTAMP</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["PRF_TIMESTAMP"]</expression>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> <column id="757"/>
> <column id="758"/>
> <column id="759"/>
> <column id="760"/>
> <column id="761"/>
> <header>
> <row id="729">
> <cell id="730">
> <label id="731">
> <text-property name="text">SVC_VDISK_ID</text-property>
> </label>
> </cell>
> <cell id="732">
> <label id="733">
> <text-property name="text">DISPLAY_NAME</text-property>
> </label>
> </cell>
> <cell id="734">
> <label id="735">
> <text-property name="text">READ_IO</text-property>
> </label>
> </cell>
> <cell id="736">
> <label id="737">
> <text-property name="text">WRITE_IO</text-property>
> </label>
> </cell>
> <cell id="738">
> <label id="739">
> <text-property name="text">PRF_TIMESTAMP</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="762">
> <property name="groupName">NewTableGroup1</property>
> <property name="interval">interval</property>
> <property name="intervalRange">6.0</property>
> <expression name="keyExpr"
> type="javascript">row["SVC_VDISK_ID"]</expression>
> <structure name="toc">
> <expression name="expressionValue"
> type="javascript">row["SVC_VDISK_ID"]</expression>
> </structure>
> <property name="repeatHeader">false</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">always</property>
> <property name="pageBreakInside">auto</property>
> <header>
> <row id="763">
> <cell id="764">
> <data id="775">
> <property name="resultSetColumn">SVC_VDISK_ID</property>
> </data>
> </cell>
> <cell id="765"/>
> <cell id="766"/>
> <cell id="767"/>
> <cell id="768"/>
> </row>
> </header>
> <footer>
> <row id="769">
> <property name="height">6.541666666666667in</property>
> <cell id="770">
> <property name="colSpan">5</property>
> <property name="rowSpan">1</property>
> <extended-item extensionName="Chart" id="776">
> <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>Line Chart</Type>
> <SubType>Overlay</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>Line 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>
> <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>Series</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>212.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>
> <Visible>true</Visible>
> </Block>
> <Dimension>Two_Dimensional</Dimension>
> <Units>Points</Units>
> <SeriesThickness>10.0</SeriesThickness>
> <ExtendedProperties>
> <Name>enable.area.alt</Name>
> <Value>false</Value>
> </ExtendedProperties>
> <SampleData>
> <BaseSampleData>
> <DataSetRepresentation>01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000</DataSetRepresentation>
>
> </BaseSampleData>
> <OrthogonalSampleData>
> <DataSetRepresentation>6,4,12,8,10</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>DateTime</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>row["DISPLAY_NAME"]</Definition>
> <Grouping>
> <GroupType>Text</GroupType>
> </Grouping>
> </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=&qu
Re: Paginate on Y-Series Group? [message #752793 is a reply to message #752701] Wed, 26 October 2011 14:18 Go to previous messageGo to next message
robinsonjas  is currently offline robinsonjas
Messages: 21
Registered: October 2011
Junior Member
Ok, I see what it is doing. First I was getting an error about using an 'Interval' on a string column in my dataset. So I added the ID, but now my ID field makes jumps so my charts are being drawn sporadically. I do have some IDs that are sequential, so those group correctly.
I built another dataset and have a sequential unique ID assigned (RUNNINGCOUNT) for each display_name. Can I have 2 datasets referenced in a Table Group? I'd like to break groups based on my new dataset but the data displayed will need to be from my other 'original' dataset.
Re: Paginate on Y-Series Group? [message #752842 is a reply to message #752793] Wed, 26 October 2011 14:38 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

You can not use 2 datasets in a group definition unless you create a
joint dataset with the 2, but you can use one dataset for grouping and
then nest a second table in the group that is tied to a second datset.

Jason

On 10/26/2011 10:19 AM, robinsonjas wrote:
> Ok, I see what it is doing. First I was getting an error about using an
> 'Interval' on a string column in my dataset. So I added the ID, but now
> my ID field makes jumps so my charts are being drawn sporadically. I do
> have some IDs that are sequential, so those group correctly.
> I built another dataset and have a sequential unique ID assigned
> (RUNNINGCOUNT) for each display_name. Can I have 2 datasets referenced
> in a Table Group? I'd like to break groups based on my new dataset but
> the data displayed will need to be from my other 'original' dataset.
Re: Paginate on Y-Series Group? [message #753225 is a reply to message #752842] Wed, 26 October 2011 17:28 Go to previous message
robinsonjas  is currently offline robinsonjas
Messages: 21
Registered: October 2011
Junior Member
Thanks! - The more I use it the better I like it.
I joined 2 datasets and got it working perfectly.
Previous Topic:Math formulas in a BIRT report
Next Topic:DB2 connections
Goto Forum:
  


Current Time: Tue Sep 16 15:32:05 GMT 2014

Powered by FUDForum. Page generated in 0.05569 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software