I have a report where I need to add a couple of columns to my table at run time. I have a particular set of data that changes based on the project a user is logged into. So I'm getting the name for the column header from one data set and then trying to pass that data into an array and use it to set the query and columns of a separate table. The array is getting set, but when I try to use the data in the other table, it says the array is empty. Is there a way that I can pass this array from one table to another? Or is there a better way to do this? Below is the code for the two data sets and the tables.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?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.v20110913-1734></property>
<list-property name="includeScripts">
<property>ProcessReports/scripts/debugWindow.js</property>
</list-property>
<property name="units">in</property>
<method name="initialize"><![CDATA[countOfRows = 0;
activeProjectId = -1;
perfOrgArray = []]]></method>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="ProjectLog" id="24">
<list-property name="computedColumns">
<structure>
<property name="name">IdCount</property>
<property name="dataType">integer</property>
<property name="aggregateFunction">COUNT</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">row["id"]</expression>
</structure>
</list-property>
</structure>
</list-property>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">event_date</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">category</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">title</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">priority</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">workstream</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">workgroup</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">audience</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">customer_reporting</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">is_complete</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">created_by</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">date_identified</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">project_id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">IdCount</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<method name="beforeOpen"><![CDATA[if (perfOrgArray != null) {
var text = "";
for (var i=0;i<perfOrgArray.length;i++) {
text = text + "CASE WHEN \n"+
"(SELECT po.PERFORMING_ORGANIZATION_ID FROM PROJECT_ORGANIZATION po WHERE po.PERFORMING_ORGANIZATION_ID = " + perfOrgArray[i][0] + " AND po.PROJECT_LOG_ID = pl.ID) IS NULL \n" +
"THEN 'No' \n" +
"ELSE 'Yes' \n" +
"END AS " + perfOrgArray[i][1] + ",\n";
}
this.queryText =
"SELECT DISTINCT \n"+
"pl.ID AS id, \n"+
"DATE(pl.EVENT_DATE) AS event_date, \n"+
"(SELECT category.NAME FROM LOOKUP category WHERE category.ID = pl.CATEGORY_ID) AS category, \n"+
"pl.TITLE AS title, \n"+
"pl.DESCRIPTION AS description, \n"+
"(SELECT priority.NAME FROM LOOKUP priority WHERE priority.ID = pl.PRIORITY_ID) AS priority, \n"+
"(SELECT workstream.NAME FROM LOOKUP workstream WHERE workstream.ID = pl.WORKSTREAM_ID) AS workstream, \n"+
"(SELECT workgroup.NAME FROM LOOKUP workgroup WHERE workgroup.ID = pl.WORKGROUP_ID) AS workgroup, \n"+
"(SELECT audience.NAME FROM LOOKUP audience WHERE audience.ID = pl.AUDIENCE_ID) AS audience, \n"+
"CASE WHEN pl.NOTIFY_CUSTOMER = 1 THEN 'Yes' ELSE 'No' END AS customer_reporting, \n"+
"CASE WHEN pl.COMPLETE = 1 THEN 'Yes' ELSE 'No' END AS is_complete, \n"+
"CASE \n"+
"WHEN CONCAT(m.FIRST_NAME,' ', m.MIDDLE_NAME,' ', m.LAST_NAME) IS NULL THEN CONCAT(m.FIRST_NAME,' ', m.LAST_NAME) \n"+
"ELSE CONCAT(m.FIRST_NAME,' ', m.MIDDLE_NAME,' ', m.LAST_NAME) \n"+
"END AS created_by, \n"+
text+
"DATE(e.CREATED_DATE) AS date_identified, \n"+
"e.PROJECT_ID AS project_id \n"+
"FROM \n"+
"PROJECT_LOG pl \n"+
"INNER JOIN ENTITY e \n"+
"ON pl.ID = e.ID \n"+
"INNER JOIN MEMBER m \n"+
"ON e.CREATED_BY_BASE_MEMBER_ID = m.ID \n"+
"WHERE \n"+
"pl.STATUS_ID = 5202 AND \n"+
"(pl.WORKGROUP_ID = "+params["WorkgroupParam"].value+" OR "+params["WorkgroupParam"].value+" = -1) AND \n"+
"(pl.WORKSTREAM_ID = "+params["WorkstreamParam"].value+" OR "+params["WorkstreamParam"].value+" = -1) AND \n"+
"(pl.CATEGORY_ID = "+params["CategoryParam"].value+" OR "+params["CategoryParam"].value+" = -1) AND \n"+
"(pl.AUDIENCE_ID = "+params["AudienceParam"].value+" OR "+params["AudienceParam"].value+" = -1) AND \n"+
"(pl.NOTIFY_CUSTOMER = "+params["ReportingParam"].value+" OR "+params["ReportingParam"].value+" = -1) AND \n"+
"("+params["TitleParam"].value+" IS NULL OR pl.TITLE LIKE CONCAT('%',"+params["TitleParam"].value+",'%')) AND \n"+
"(pl.PRIORITY_ID = "+params["PriorityParam"].value+" OR "+params["PriorityParam"].value+" = -1) AND \n"+
"(pl.COMPLETE = "+params["EventCompleteParam"].value+" OR "+params["EventCompleteParam"].value+" = -1) AND \n"+
"(DATE(pl.EVENT_DATE) BETWEEN '"+params["StartDateParam"].value+"' AND '"+params["EndDateParam"].value+"') \n"+
"AND e.PROJECT_ID = "+activeProjectId+" \n";
}]]></method>
<property name="dataSource">Business</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="nativeName">id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">event_date</property>
<property name="nativeName">event_date</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">category</property>
<property name="nativeName">category</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">title</property>
<property name="nativeName">title</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">description</property>
<property name="nativeName">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">priority</property>
<property name="nativeName">priority</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">workstream</property>
<property name="nativeName">workstream</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">workgroup</property>
<property name="nativeName">workgroup</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">audience</property>
<property name="nativeName">audience</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">customer_reporting</property>
<property name="nativeName">customer_reporting</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">is_complete</property>
<property name="nativeName">is_complete</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">created_by</property>
<property name="nativeName">created_by</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">date_identified</property>
<property name="nativeName">date_identified</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">project_id</property>
<property name="nativeName">project_id</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT DISTINCT
pl.ID AS id,
DATE(pl.EVENT_DATE) AS event_date,
(SELECT category.NAME FROM LOOKUP category WHERE category.ID = pl.CATEGORY_ID) AS category,
pl.TITLE AS title,
pl.DESCRIPTION AS description,
(SELECT priority.NAME FROM LOOKUP priority WHERE priority.ID = pl.PRIORITY_ID) AS priority,
(SELECT workstream.NAME FROM LOOKUP workstream WHERE workstream.ID = pl.WORKSTREAM_ID) AS workstream,
(SELECT workgroup.NAME FROM LOOKUP workgroup WHERE workgroup.ID = pl.WORKGROUP_ID) AS workgroup,
(SELECT audience.NAME FROM LOOKUP audience WHERE audience.ID = pl.AUDIENCE_ID) AS audience,
CASE WHEN pl.NOTIFY_CUSTOMER = 1 THEN 'Yes' ELSE 'No' END AS customer_reporting,
CASE WHEN pl.COMPLETE = 1 THEN 'Yes' ELSE 'No' END AS is_complete,
CASE
WHEN CONCAT(m.FIRST_NAME,' ', m.MIDDLE_NAME,' ', m.LAST_NAME) IS NULL THEN CONCAT(m.FIRST_NAME,' ', m.LAST_NAME)
ELSE CONCAT(m.FIRST_NAME,' ', m.MIDDLE_NAME,' ', m.LAST_NAME)
END AS created_by,
DATE(e.CREATED_DATE) AS date_identified,
e.PROJECT_ID AS project_id
FROM
PROJECT_LOG pl
LEFT OUTER JOIN PROJECT_ORGANIZATION po
ON pl.ID = po.PROJECT_LOG_ID
INNER JOIN ENTITY e
ON pl.ID = e.ID
INNER JOIN MEMBER m
ON e.CREATED_BY_BASE_MEMBER_ID = m.ID
WHERE
pl.STATUS_ID = 5202 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>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>ID</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ID</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>TITLE</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>TITLE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>TITLE</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>EVENT_DATE</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>23</design:precision>
<design:scale>10</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>EVENT_DATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>EVENT_DATE</design:label>
<design:formattingHints>
<design:displaySize>23</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>COMPLETE</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>5</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>COMPLETE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>COMPLETE</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>TODO_ID</design:name>
<design:position>5</design:position>
</design:identifier>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>2</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>TODO_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>TODO_ID</design:label>
<design:formattingHints>
<design:displaySize>19</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>PROJECT_ID</design:name>
<design:position>6</design:position>
</design:identifier>
<design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PROJECT_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PROJECT_ID</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>CATEGORY_ID</design:name>
<design:position>7</design:position>
</design:identifier>
<design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CATEGORY_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CATEGORY_ID</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="PerformingOrganization" id="1178">
<list-property name="parameters">
<structure>
<property name="name">projectId</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<expression name="defaultValue" type="javascript">3</expression>
<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">id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Business</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="nativeName">id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">name</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT DISTINCT
org.ID AS id,
org.NAME AS name
FROM
LOOKUP org
WHERE
org.IS_ACTIVE AND
org.TYPE_ID = 'ProjectLogDataTypes::PerformingOrganization' AND
org.PROJECT_ID = ?
ORDER BY
org.ID ]]></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">custom</property>
<property name="height">5000in</property>
<property name="width">25in</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>
<text-data id="1046">
<property name="dataSet">ActiveProject</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">true</expression>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ActiveUser::LOGIN_NAME</property>
<text-property name="displayName">LOGIN_NAME</text-property>
<expression name="expression" type="javascript">dataSetRow["ActiveUser::LOGIN_NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">MemberData::USERNAME</property>
<text-property name="displayName">USERNAME</text-property>
<expression name="expression" type="javascript">dataSetRow["MemberData::USERNAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">MemberData::PROJECT_ID</property>
<text-property name="displayName">PROJECT_ID</text-property>
<expression name="expression" type="javascript">dataSetRow["MemberData::PROJECT_ID"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<expression name="valueExpr">"Hidden Label Bound to ActiveProject Data Set: " + Total.count();
activeProjectId = row["MemberData::PROJECT_ID"];</expression>
<property name="contentType">html</property>
</text-data>
<table id="1266">
<property name="dataSet">PerformingOrganization</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">true</expression>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">id</property>
<text-property name="displayName">id</text-property>
<expression name="expression" type="javascript">dataSetRow["id"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">name</property>
<text-property name="displayName">name</text-property>
<expression name="expression" type="javascript">dataSetRow["name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="1276"/>
<column id="1273"/>
<detail>
<row id="1269">
<method name="onCreate"><![CDATA[var id = this.getRowData().getColumnValue(0);
var name = this.getRowData().getColumnValue(1);
perfOrgArray.push(new Array(id,name));
]]></method>
<cell id="1275">
<data id="1277">
<property name="resultSetColumn">id</property>
</data>
</cell>
<cell id="1270">
<data id="1274">
<property name="resultSetColumn">name</property>
</data>
</cell>
</row>
</detail>
</table>
<table name="dataTable" id="71">
<property name="width">24.447916666666668in</property>
<property name="dataSet">ProjectLog</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">id</property>
<text-property name="displayName">id</text-property>
<expression name="expression" type="javascript">dataSetRow["id"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">event_date</property>
<text-property name="displayName">event_date</text-property>
<expression name="expression" type="javascript">dataSetRow["event_date"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">category</property>
<text-property name="displayName">category</text-property>
<expression name="expression" type="javascript">dataSetRow["category"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">title</property>
<text-property name="displayName">title</text-property>
<expression name="expression" type="javascript">dataSetRow["title"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">description</property>
<text-property name="displayName">description</text-property>
<expression name="expression" type="javascript">dataSetRow["description"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">priority</property>
<text-property name="displayName">priority</text-property>
<expression name="expression" type="javascript">dataSetRow["priority"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">workstream</property>
<text-property name="displayName">workstream</text-property>
<expression name="expression" type="javascript">dataSetRow["workstream"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">workgroup</property>
<text-property name="displayName">workgroup</text-property>
<expression name="expression" type="javascript">dataSetRow["workgroup"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">audience</property>
<text-property name="displayName">audience</text-property>
<expression name="expression" type="javascript">dataSetRow["audience"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">customer_reporting</property>
<text-property name="displayName">customer_reporting</text-property>
<expression name="expression" type="javascript">dataSetRow["customer_reporting"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">is_complete</property>
<text-property name="displayName">is_complete</text-property>
<expression name="expression" type="javascript">dataSetRow["is_complete"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">created_by</property>
<text-property name="displayName">created_by</text-property>
<expression name="expression" type="javascript">dataSetRow["created_by"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">date_identified</property>
<text-property name="displayName">date_identified</text-property>
<expression name="expression" type="javascript">dataSetRow["date_identified"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">project_id</property>
<text-property name="displayName">project_id</text-property>
<expression name="expression" type="javascript">dataSetRow["project_id"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">IdCount</property>
<text-property name="displayName">IdCount</text-property>
<expression name="expression" type="javascript">dataSetRow["IdCount"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<method name="onPrepare"><![CDATA[logToDebugWindow(perfOrgArray.length);]]></method>
<method name="onCreate"><![CDATA[importPackage( Packages.org.eclipse.birt.report.engine.api.script.element );
importPackage( Packages.org.eclipse.birt.report.model.api.simpleapi );
importPackage(Packages.org.eclipse.birt.report.model.api);
if (perfOrgArray !=null){
var table = reportContext.getDesignHandle().findElement("dataTable");
//table.setDataSet(reportContext.getDesigneHandle().findDataSet("ProjectLog"));
var elementFactory = reportContext.getDesignHandle().getElementFactory();
var colBinds = table.getColumnBindings();
var cs1 = [];
StructureFactory.createComputedColumn();
//logToDebugWindow(perfOrgArray[0][0]);
for (var i=0;i<perfOrgArray.length;i++){
cs1[i] = StructureFactory.createComputedColumn();
cs1[i].setName(perfOrgArray[i][1]);
cs1[i].setExpression("dataSetRow[\"" + perfOrgArray[i][1] + "\"]");
colBinds.addItem(cs1[i]);
// Add column
//var incnt = i;
table.insertColumn(i+4,-1);
//Add detail
var detail = table.getDetail().get(0);
var tcell = detail.getCells().get(i+4);
var data = elementFactory.newDataItem(null);
data.setResultSetColumn(perfOrgArray[i][1]);
tcell.getContent().add(data);
// Add column headers
var header = table.getHeader().get(0);
var tcell = header.getCells().get(i+4);
var label = elementFactory.newLabel(null);
label.setText(perfOrgArray[i][1]);
tcell.getContent().add(label);
}
}]]></method>
<column id="126">
<property name="width">0.7in</property>
</column>
<column id="127">
<property name="width">1.0625in</property>
</column>
<column id="128">
<property name="width">1.0625in</property>
</column>
<column id="203">
<property name="width">1.0625in</property>
</column>
<column id="129">
<property name="width">1.0625in</property>
</column>
<column id="211">
<property name="width">1.0625in</property>
</column>
<column id="199">
<property name="width">1.0625in</property>
</column>
<column id="130">
<property name="width">1.0625in</property>
</column>
<column id="207">
<property name="width">1.0625in</property>
</column>
<column id="131">
<property name="width">1.0625in</property>
</column>
<column id="463">
<property name="width">1.0625in</property>
</column>
<column id="132">
<property name="width">1.0625in</property>
</column>
<column id="468">
<property name="width">1.0625in</property>
</column>
<column id="133">
<property name="width">1.0625in</property>
</column>
<column id="134">
<property name="width">1.5in</property>
</column>
<column id="135">
<property name="width">0.7in</property>
</column>
<column id="136">
<property name="width">0.8in</property>
</column>
<column id="141">
<property name="width">1.0625in</property>
</column>
<column id="142">
<property name="width">1.0625in</property>
</column>
<header>
<row id="212">
<property name="backgroundColor">gray</property>
<property name="fontWeight">bold</property>
<property name="color">white</property>
<property name="verticalAlign">middle</property>
<cell id="213">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="161">
<text-property name="text">ID</text-property>
</label>
</cell>
<cell id="214">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="163">
<text-property name="text">Event Date</text-property>
</label>
</cell>
<cell id="215">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="166">
<text-property name="text">Category</text-property>
</label>
</cell>
<cell id="216">
<property name="colSpan">3</property>
<property name="rowSpan">2</property>
<label id="168">
<text-property name="text">Title</text-property>
</label>
</cell>
<cell id="219">
<property name="colSpan">3</property>
<property name="rowSpan">2</property>
<label id="170">
<text-property name="text">Description</text-property>
</label>
</cell>
<cell id="222">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="172">
<text-property name="text">Priority</text-property>
</label>
</cell>
<cell id="459">
<property name="colSpan">2</property>
<property name="rowSpan">2</property>
<label id="174">
<text-property name="text">Workstream</text-property>
</label>
</cell>
<cell id="464">
<property name="colSpan">2</property>
<property name="rowSpan">2</property>
<label id="176">
<text-property name="text">Workgroup</text-property>
</label>
</cell>
<cell id="225">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="178">
<text-property name="text">Audience</text-property>
</label>
</cell>
<cell id="226">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="180">
<text-property name="text">Customer Reporting</text-property>
</label>
</cell>
<cell id="227">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="182">
<text-property name="text">Completed</text-property>
</label>
</cell>
<cell id="232">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="192">
<text-property name="text">Reporter</text-property>
</label>
</cell>
<cell id="233">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<label id="194">
<text-property name="text">Date Identified</text-property>
</label>
</cell>
</row>
<row id="72">
<property name="backgroundColor">gray</property>
<property name="fontWeight">bold</property>
<property name="color">white</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="verticalAlign">middle</property>
</row>
</header>
<detail>
<row id="90">
<method name="onCreate"><![CDATA[countOfRows++;]]></method>
<property name="verticalAlign">middle</property>
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property name="backgroundColor">#C6E2FF</property>
<property name="fontSize">10pt</property>
<expression name="testExpr" type="javascript">row[0] % 2</expression>
<simple-property-list name="value1">
<value type="javascript">1</value>
</simple-property-list>
</structure>
</list-property>
<cell id="91">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1px</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="162">
<property name="textAlign">center</property>
<property name="resultSetColumn">id</property>
</data>
</cell>
<cell id="92">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1px</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="164">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">MM/dd/yyyy</property>
</structure>
<property name="textAlign">center</property>
<property name="resultSetColumn">event_date</property>
</data>
</cell>
<cell id="93">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1px</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="167">
<property name="textAlign">center</property>
<property name="resultSetColumn">category</property>
</data>
</cell>
<cell id="201">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1px</property>
<property name="borderTopColor">#000000</property>
