Home » Archived » BIRT » [Fwd: Binding chart parameter to list does not work]
| [Fwd: Binding chart parameter to list does not work] [message #175269] |
Wed, 05 July 2006 10:18  |
Eclipse User |
|
|
|
Originally posted by: lingtai.earthlink.net
This is a multi-part message in MIME format.
--------------030900060501090602010104
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
I have downloaded latest BIRT 2.1 release and tried again. I am getting
the exact same error. Being able to bind chart parameter to list is key
to my reports, is this capability supported in BIRT 2.1? Is this a bug?
Can someone help me?
Many thanks,
Ling
--------------030900060501090602010104
Content-Type: message/rfc822;
name="Binding chart parameter to list does not work"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="Binding chart parameter to list does not work"
Path: utils.eclipse.org!not-for-mail
From: Ling Tai <lingtai@earthlink.net>
Newsgroups: eclipse.birt
Subject: Binding chart parameter to list does not work
Date: Thu, 29 Jun 2006 15:14:02 -0400
Organization: EclipseCorner
Message-ID: <e818pv$ukd$1@utils.eclipse.org>
NNTP-Posting-Host: bi01p1.nc.us.ibm.com
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: utils.eclipse.org 1151608447 31373 129.33.49.251 (29 Jun 2006 19:14:07 GMT)
X-Complaints-To: news@utils.eclipse.org
NNTP-Posting-Date: Thu, 29 Jun 2006 19:14:07 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
Xref: utils.eclipse.org eclipse.birt:11218
I am using BIRT 2.1 RC4 and I have encountered the same problem. I have
a side-by-side chart listing, one side of the report is a listing and
the other side is a chart. The chart bound to a dataset that takes the
value of list as a parameter.
Neither row["LABEL_X"] nor row._outer["LABEL_X"]work.
I get following error message:
NO-RB$ Result iterator has no current row. It either has not started or
has ended.
What do I do wrong? Can anyone help me?
Thank you very much.
--------------030900060501090602010104--
|
|
| |
| Re: Binding chart parameter to list does not work] [message #175612 is a reply to message #175335] |
Thu, 06 July 2006 10:46  |
| Eclipse User |
|
|
|
Originally posted by: lingtai.earthlink.net
Hi David:
My report contains a table which is grouped by RFC numbers. Each detail
row of the table has two columns: a grid column and a chart column. The
grid has multi-rows and each row has two columns: a label and a dynamic
text, i.e. [LABEL_X]. The chart has two parameters. When I am trying
to bind those two parameters to one of the row in the Grid via either
row["LABEL_X"] or row._outer{"LABEL_X"], I will get the following error:
$NO-RB$ Result iterator has no current row. It either has not started or
has ended.
Below is my design file, any suggestion or comments will be highly
appreciated. Thank you very much for your help.
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Written by Eclipse BIRT 2.0 -->
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2" id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.1.0.N20060531-1258 Build <20060531-1258></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2006 Actuate Corporation.</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="TaddmCmdb" id="4">
> <property name="odaDriverClass">com.ibm.db2.jcc.DB2Driver</property >
> <property name="odaURL">jdbc:db2://localhost:50000/CMDB</property>
> <property name="odaUser">lingtai</property>
> <encrypted-property name="odaPassword">YTVzNWQ1ZmY=</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="getCiWithEvents" id="91">
> <list-property name="computedColumns">
> <structure>
> <property name="name">implDate</property>
> <expression name="expression">new Date(row["CLOSEDATE_X"])</expression>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">RFCNUMBER_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CLOSEDATE_X</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">FQDN_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">MANUFACTURER_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ARCHITECTURE_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">MODEL_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">TYPE_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">ROMVERSION_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">MEMORYSIZE_X</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">SOURCETOKEN_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">LABEL_X</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">implDate</property>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">TaddmCmdb</property>
> <property name="queryText">select rfc.rfcnumber_x, rfc.closedate_x, cs.fqdn_x, cs.manufacturer_x, cs.architecture_x,
> cs.model_x, cs.type_x, cs.romversion_x, cs.memorysize_x, cs.sourcetoken_x, cs.label_x
>
> from lingtai.rfcproxy rfc,
> lingtai.relation rel,
> lingtai.compsys cs,
>
> table (select hostname, AVG(eventstats.eventcount) as eventavg, STDDEV(eventstats.eventcount) as eventstd
> from table (select hostname, FLOOR(date_reception/86400) as eventdate, DECIMAL(COUNT(*)) as eventcount
> from lingtai.tec_t_evt_rep
> where hostname > ''
> group by hostname, FLOOR(date_reception/86400)) as eventstats
> group by hostname ) as eventdist,
>
> table (select hostname, FLOOR(date_reception/86400) as eventdate, DECIMAL(COUNT(*)) as eventcount
> from lingtai.tec_t_evt_rep
> where hostname > ''
> group by hostname, FLOOR(date_reception/86400)) as eventsummary
>
> where rfc.guid_x = rel.source_x
> and rel.target_x = cs.guid_x
> and cs.label_x = eventsummary.hostname
> and eventsummary.hostname = eventdist.hostname
>
> and eventsummary.eventcount > eventdist.eventavg + eventdist.eventstd
> and eventsummary.eventdate between FLOOR(rfc.closedate_x/86400000) and
> FLOOR(rfc.closedate_x/86400000) + (3*86400)
>
> order by rfc.rfcnumber_x, cs.label_x, eventsummary.eventdate</property>
> </oda-data-set>
> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="getEventGraph" id="298">
> <text-property name="displayName">getEventGraph</text-property>
> <list-property name="parameters">
> <structure>
> <property name="name">param1</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> <property name="position">1</property>
> <expression name="defaultValue">'RTP-CS5'</expression>
> <property name="isOptional">false</property>
> <property name="isInput">true</property>
> </structure>
> <structure>
> <property name="name">param2</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> <property name="position">2</property>
> <expression name="defaultValue">'RTP-CS5'</expression>
> <property name="isOptional">false</property>
> <property name="isInput">true</property>
> </structure>
> </list-property>
> <list-property name="computedColumns">
> <structure>
> <property name="name">eventDate</property>
> <expression name="expression">new Date (row["EVENTDATE"] * 86400000)</expression>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">HOSTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">EVENTDATE</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">EVENTCOUNT</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">EVENTAVG</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">EVENTSTD</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">eventDate</property>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">TaddmCmdb</property>
> <property name="queryText"> select eventsummary.hostname, eventsummary.eventdate, eventsummary.eventcount, eventdist.eventavg, eventdist.eventstd
>
> from table (select hostname, avg(eventstats.eventcount) as eventavg, stddev(eventstats.eventcount) as eventstd
> from table (select hostname, FLOOR(date_reception/86400) as eventdate, decimal(count(*)) as eventcount
> from lingtai.tec_t_evt_rep
> where hostname = ?
> group by hostname, FLOOR(date_reception/86400)) as eventstats
> group by hostname ) as eventdist,
>
> table (select hostname, FLOOR(date_reception/86400) as eventdate, decimal(count(*)) as eventcount
> from lingtai.tec_t_evt_rep
> where hostname = ?
> group by hostname, FLOOR(date_reception/86400)) as eventsummary
>
> where eventsummary.hostname = eventdist.hostname
> and eventsummary.eventdate between (1149667200/86400 - 6 ) and (1149667200/86400 + 1)
>
> order by eventsummary.hostname, eventsummary.eventdate</property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="header" id="69">
> <property name="backgroundColor">#DEE3EB</property>
> <property name="fontSize">large</property>
> <property name="fontWeight">bold</property>
> <property name="fontStyle">italic</property>
> <property name="color">#0000FF</property>
> <property name="borderBottomStyle">none</property>
> <property name="borderTopStyle">none</property>
> <property name="paddingBottom">10pt</property>
> </style>
> <style name="footer" id="82">
> <property name="color">#0000FF</property>
> </style>
> <style name="NewStyle" id="182">
> <property name="fontSize">larger</property>
> <property name="fontWeight">bold</property>
> <property name="fontStyle">italic</property>
> </style>
> <style name="normal" id="295"/>
> <style name="GridBorder" id="375">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderRightWidth">medium</property>
> </style>
> <style name="GridBorderThick" id="376">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thick</property>
> </style>
> <style name="GridBorderTop" id="377">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopWidth">thick</property>
> </style>
> <style name="title" id="413">
> <property name="fontFamily">SansSerif</property>
> <property name="fontSize">larger</property>
> <property name="fontWeight">bold</property>
> <property name="color">#030BBD</property>
> </style>
> <style name="RFCline" id="420">
> <property name="fontFamily">Arial Black</property>
> <property name="fontSize">large</property>
> <property name="fontWeight">bold</property>
> <property name="color">#8080C0</property>
> <property name="borderBottomColor">#0080C0</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</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>
> <table id="299">
> <property name="backgroundColor">#D5E3E6</property>
> <property name="width">100%</property>
> <property name="dataSet">getCiWithEvents</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">RFCNUMBER_X</property>
> <expression name="expression">dataSetRow["RFCNUMBER_X"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">FQDN_X</property>
> <expression name="expression">dataSetRow["FQDN_X"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">MANUFACTURER_X</property>
> <expression name="expression">dataSetRow["MANUFACTURER_X"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">SOURCETOKEN_X</property>
> <expression name="expression">dataSetRow["SOURCETOKEN_X"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">MODEL_X</property>
> <expression name="expression">dataSetRow["MODEL_X"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">TYPE_X</property>
> <expression name="expression">dataSetRow["TYPE_X"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">ARCHITECTURE_X</property>
> <expression name="expression">dataSetRow["ARCHITECTURE_X"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">ROMVERSION_X</property>
> <expression name="expression">dataSetRow["ROMVERSION_X"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">MEMORYSIZE_X</property>
> <expression name="expression">dataSetRow["MEMORYSIZE_X"]</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">LABEL_X</property>
> <expression name="expression">dataSetRow["LABEL_X"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CLOSEDATE_X</property>
> <expression name="expression">dataSetRow["CLOSEDATE_X"]</expression >
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <list-property name="sort">
> <structure>
> <expression name="key">row["RFCNUMBER_X"]</expression>
> </structure>
> </list-property>
> <column id="309">
> <property name="width">0.708in</property>
> </column>
> <column id="310">
> <property name="width">5.281in</property>
> </column>
> <header>
> <row id="300">
> <cell id="301"/>
> <cell id="302"/>
> </row>
> </header>
> <group id="360">
> <property name="groupName">rfcGroup</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["RFCNUMBER_X"]</expression>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <header>
> <row id="361">
> <cell id="362">
> <property name="colSpan">2</property>
> <property name="rowSpan">1</property>
> <data id="369">
> <property name="style">RFCline</property>
> <property name="fontFamily">"Arial Black"</property>
> <property name="fontWeight">bold</property>
> <property name="color">#0080C0</property>
> <property name="paddingTop">10px</property>
> <structure name="stringFormat">
> <property name="category">Custom</property>
> </structure>
> <property name="resultSetColumn">RFCNUMBER_X</property>
> <structure name="action">
> <property name="linkType">hyperlink</property>
> <expression name="uri">" http://localhost:57355/viewer/run?__report=c:/ws/BIRT/MyBirt Project/rfcDetails.rptdesign&rpRfcNumber=" + row["RFCNUMBER_X"]</expression>
> <property name="targetWindow">_blank</property>
> </structure>
> </data>
> </cell>
> </row>
> </header>
> <footer>
> <row id="365">
> <cell id="366"/>
> <cell id="368"/>
> </row>
> </footer>
> </group>
> <detail>
> <row id="303">
> <cell id="304"/>
> <cell id="305">
> <grid id="315">
> <property name="width">100%</property>
> <column id="316">
> <property name="width">2.333in</property>
> </column>
> <column id="317">
> <property name="width">2.645in</property>
> </column>
> <row id="318">
> <cell id="319">
> <data id="348">
> <property name="fontFamily">"Serif"</property>
> <property name="color">#0080C0</property>
> <property name="resultSetColumn">FQDN_X</property>
> </data>
> </cell>
> <cell id="320">
> <label id="370">
> <property name="color">#676767</property>
> <text-property name="text">Event Graph for last 7 days</text-property>
> </label>
> </cell>
> </row>
> <row id="321">
> <cell id="322">
> <grid id="324">
> <property name="width">100%</property>
> <column id="325"/>
> <column id="326"/>
> <row id="327">
> <cell id="328">
> <property name="style">GridBorderTop</property>
> <label id="371">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Owner</text-property>
> </label>
> </cell>
> <cell id="329">
> <property name="style">GridBorderTop</property>
> <data id="350">
> <property name="resultSetColumn">SOURCETOKEN_X</property>
> </data>
> </cell>
> </row>
> <row id="425">
> <cell id="426">
> <property name="style">GridBorderTop</property>
> <label id="429">
> <property name="fontFamily">sans-serif</property>
> <text-property name="text">Label</text-property>
> </label>
> </cell>
> <cell id="427">
> <property name="style">GridBorderTop</property>
> <data id="428">
> <property name="resultSetColumn">LABEL_X</property>
> </data>
> </cell>
> </row>
> <row id="330">
> <cell id="331">
> <property name="style">GridBorder</property>
> <label id="372">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Manufacturer</text-property>
> </label>
> </cell>
> <cell id="332">
> <property name="style">GridBorder</property>
> <data id="349">
> <property name="resultSetColumn">MANUFACTURER_X</property>
> </data>
> </cell>
> </row>
> <row id="333">
> <cell id="334">
> <property name="style">GridBorder</property>
> <label id="373">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Architecture</text-property>
> </label>
> </cell>
> <cell id="335">
> <property name="style">GridBorder</property>
> <data id="354">
> <property name="resultSetColumn">ARCHITECTURE_X</property>
> </data>
> </cell>
> </row>
> <row id="336">
> <cell id="337">
> <property name="style">GridBorder</property>
> <label id="378">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Model</text-property>
> </label>
> </cell>
> <cell id="338">
> <property name="style">GridBorder</property>
> <data id="351">
> <property name="resultSetColumn">MODEL_X</property>
> </data>
> </cell>
> </row>
> <row id="339">
> <cell id="340">
> <property name="style">GridBorder</property>
> <label id="379">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Type</text-property>
> </label>
> </cell>
> <cell id="341">
> <property name="style">GridBorder</property>
> <data id="352">
> <property name="resultSetColumn">TYPE_X</property>
> </data>
> </cell>
> </row>
> <row id="342">
> <cell id="343">
> <property name="style">GridBorder</property>
> <label id="380">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Rom version</text-property>
> </label>
> </cell>
> <cell id="344">
> <property name="style">GridBorder</property>
> <data id="355">
> <property name="resultSetColumn">ROMVERSION_X</property>
> </data>
> </cell>
> </row>
> <row id="387">
> <cell id="388">
> <property name="style">GridBorder</property>
> <label id="381">
> <property name="fontFamily">"Serif"</property>
> <text-property name="text">Memory size</text-property>
> </label>
> </cell>
> <cell id="389">
> <property name="style">GridBorder</property>
> <data id="359">
> <property name="resultSetColumn">MEMORYSIZE_X</property>
> </data>
> </cell>
> </row>
> </grid>
> </cell>
> <cell id="323">
> <extended-item extensionName="Chart" id="386">
> <property name="height">130pt</property>
> <property name="width">212pt</property>
> <property name="dataSet">getEventGraph</property>
> <list-property name="paramBindings">
> <structure>
> <property name="paramName">param1</property>
> <expression name="expression">row._outer["LABEL_X"]</expression>
> </structure>
> <structure>
> <property name="paramName">param2</property>
> <expression name="expression">row._outer["LABEL_X"]</expression>
> </structure>
> </list-property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">HOSTNAME</property>
> <expression name="expression">dataSetRow["HOSTNAME"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">EVENTDATE</property>
> <expression name="expression">dataSetRow["EVENTDATE"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">EVENTCOUNT</property>
> <expression name="expression">dataSetRow["EVENTCOUNT"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">EVENTAVG</property>
> <expression name="expression">dataSetRow["EVENTAVG"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">EVENTSTD</property>
> <expression name="expression">dataSetRow["EVENTSTD"]</expression>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="name">eventDate</property>
> <expression name="expression">dataSetRow["eventDate"]</expression>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> <xml-property name="xmlRepresentation"><
Home