It's all about the answers!

Ask a question

BIRT and New RTC OPAL Template


Matt McGinn (632610) | asked May 03 '12, 12:34 a.m.
We are trying to use some reports that have already been developed and are working on the new OPAL 2.4 Template.

The reports don't return any data when installed on projects using the new OPAL 2.4 template.
I think the report is not able to pick up the Project Area from '{Current Project Area}' so no data can be retrieved.

Are there any suggestions for a work around for this problem or any suggestions for an alternate cause / solution?

3 answers



permanent link
Matt McGinn (632610) | answered May 08 '12, 10:13 p.m.
Investigation Update - We have made some headway in investigating this issue. When we output the contents of the 'Project_Area' table the OPAL 2.4 project is not included - it appears that the project in question is not registering somewhere along the way and is not being picked up as a project. This explains why we cannot get any data output for the project using the '{Current Project Area}' value.

Any ideas as to what could have gone wrong with the setup of the project to prevent it being included in the 'Project_Area' table?

permanent link
Rafik Jaouani (5.0k16) | answered May 28 '12, 4:29 p.m.
JAZZ DEVELOPER
Hard to tell. Could be a read access restriction. To know for sure, I will need to look at the report design file.

permanent link
Matt McGinn (632610) | answered May 31 '12, 1:49 a.m.
Currently I think it is a problem with how the template has been implemented as the specific project name is not listed when I output a list of project areas. But if you don't mind having a look at the report's code, I would appreciate it.

Here's the report xml:

<xml>
<report>
<property>Eclipse BIRT Designer Version 2.5.2.v20100208 Build <2.5.2.v20100210-0630></property>
<property>in</property>
<list>
<structure>
<property>repository</property>
<property>400</property>
</structure>
<structure>
<property>snapshot</property>
<property>400</property>
</structure>
<structure>
<property>projectArea</property>
<property>400</property>
</structure>
<structure>
<property>OdaConnProfileName</property>
<property>400</property>
</structure>
<structure>
<property>OdaConnProfileStorePath</property>
<property>400</property>
</structure>
</list>
<method><CDATA></method>
<method><CDATA></method>
<property>/templates/blank_report.gif</property>
<property>auto layout</property>
<property>ltr</property>
<parameters>
<scalar>
<text>Display information about the report functionality</text>
<property>static</property>
<property>boolean</property>
<property>true</property>
<simple>
<value>false</value>
</simple>
<property>simple</property>
<property>check-box</property>
<structure>
</scalar>
</parameters>
<data>
<oda>
<property>Data Source for the Leave Data Set</property>
<property>https://gbstechtools.au.ibm.com:9445/ccm/</property>
<property>APT_SNAPSHOT</property>
<property>IBM OPAL 2.4</property>
</oda>
<oda>
<property>Data Source for the Project Areas & User Data Set</property>
<property>https://gbstechtools.au.ibm.com:9445/ccm/</property>
<property>COMMON_SNAPSHOT</property>
<property>IBM OPAL 2.4</property>
</oda>
<script>
<property>Data Source place holder for Joint Scripted User Leave Data Sets</property>
</script>
</data>
<data>
<oda>
<list>
<structure>
<property>CONTRIBUTOR_USERID</property>
<text>CONTRIBUTOR_USERID</text>
</structure>
<structure>
<property>CONTRIBUTOR_NAME</property>
<text>CONTRIBUTOR_NAME</text>
</structure>
<structure>
<property>CONTRIBUTOR_ITEMID</property>
<text>CONTRIBUTOR_ITEMID</text>
</structure>
<structure>
<property>ABSENCE_STARTDATE</property>
<text>ABSENCE_STARTDATE</text>
</structure>
<structure>
<property>ABSENCE_ENDDATE</property>
<text>ABSENCE_ENDDATE</text>
</structure>
</list>
<list>
<structure>
<property>le</property>
<expression>row</expression>
<simple>
<value>BirtDateTime.addQuarter(BirtDateTime.today(),1)</value>
</simple>
</structure>
<structure>
<property>ge</property>
<expression>row</expression>
<simple>
<value>BirtDateTime.today()</value>
</simple>
</structure>
</list>
<list>
<structure>
<property>RESULT_SET_SIZE</property>
<property>RESULT_SET_SIZE</property>
<property>integer</property>
<property>3</property>
<property>1</property>
<property>true</property>
<property>true</property>
<property>true</property>
</structure>
<structure>
<property>CONTRIBUTOR_USERID</property>
<property>CONTRIBUTOR_USERID</property>
<property>string</property>
<property>2</property>
<property>2</property>
<property>true</property>
<property>true</property>
<property>true</property>
</structure>
</list>
<structure>
<list>
<structure>
<property>1</property>
<property>CONTRIBUTOR_USERID</property>
<property>string</property>
</structure>
<structure>
<property>2</property>
<property>CONTRIBUTOR_NAME</property>
<property>string</property>
</structure>
<structure>
<property>3</property>
<property>CONTRIBUTOR_ITEMID</property>
<property>string</property>
</structure>
<structure>
<property>4</property>
<property>ABSENCE_STARTDATE</property>
<property>date-time</property>
</structure>
<structure>
<property>5</property>
<property>ABSENCE_ENDDATE</property>
<property>date-time</property>
</structure>
</list>
</structure>
<method><CDATA></method>
<property>APT Source</property>
<list>
<structure>
<property>1</property>
<property>CONTRIBUTOR_USERID</property>
<property>CONTRIBUTOR_USERID</property>
<property>string</property>
<property>2</property>
</structure>
<structure>
<property>2</property>
<property>CONTRIBUTOR_NAME</property>
<property>CONTRIBUTOR_NAME</property>
<property>string</property>
<property>2</property>
</structure>
<structure>
<property>3</property>
<property>CONTRIBUTOR_ITEMID</property>
<property>CONTRIBUTOR_ITEMID</property>
<property>string</property>
<property>7</property>
</structure>
<structure>
<property>4</property>
<property>ABSENCE_STARTDATE</property>
<property>ABSENCE_STARTDATE</property>
<property>date-time</property>
<property>6</property>
</structure>
<structure>
<property>5</property>
<property>ABSENCE_ENDDATE</property>
<property>ABSENCE_ENDDATE</property>
<property>date-time</property>
<property>6</property>
</structure>
</list>
<xml><CDATA></xml>
<xml><!]></xml>
<list>
<ex>
<name>fact</name>
<value>CONTRIBUTOR_ABSENCE</value>
</ex>
<ex>
<name>selectedFields</name>
<value>CONTRIBUTOR_USERID,CONTRIBUTOR_NAME,CONTRIBUTOR_ITEMID,ABSENCE_STARTDATE,ABSENCE_ENDDATE</value>
</ex>
<ex>
<name>parameterFields</name>
<value>CONTRIBUTOR_USERID</value>
</ex>
</list>
<property>CONTRIBUTOR_ABSENCE</property>
<property>CONTRIBUTOR_USERID,CONTRIBUTOR_NAME,CONTRIBUTOR_ITEMID,ABSENCE_STARTDATE,ABSENCE_ENDDATE</property>
<property>CONTRIBUTOR_USERID</property>
</oda>
<oda>
<list>
<structure>
<property>PROJECT_AREA_ITEMID</property>
<text>PROJECT_AREA_ITEMID</text>
</structure>
<structure>
<property>PROJECT_AREA_NAME</property>
<text>PROJECT_AREA_NAME</text>
</structure>
</list>
<list>
<structure>
<property>PROJECT_AREA_ITEMID</property>
<property>PROJECT_AREA_ITEMID</property>
<property>string</property>
<property>7</property>
<property>1</property>
<expression>'{Current Project Area}'</expression>
<property>true</property>
<property>true</property>
<property>true</property>
<property>false</property>
</structure>
<structure>
<property>PROJECT_AREA_NAME</property>
<property>PROJECT_AREA_NAME</property>
<property>string</property>
<property>2</property>
<property>2</property>
<property>true</property>
<property>true</property>
<property>true</property>
</structure>
<structure>
<property>RESULT_SET_SIZE</property>
<property>RESULT_SET_SIZE</property>
<property>integer</property>
<property>3</property>
<property>3</property>
<property>true</property>
<property>true</property>
<property>true</property>
</structure>
</list>
<structure>
<list>
<structure>
<property>1</property>
<property>PROJECT_AREA_ITEMID</property>
<property>string</property>
</structure>
<structure>
<property>2</property>
<property>PROJECT_AREA_NAME</property>
<property>string</property>
</structure>
</list>
</structure>
<method><CDATA></method>
<property>Common Source</property>
<list>
<structure>
<property>1</property>
<property>PROJECT_AREA_ITEMID</property>
<property>PROJECT_AREA_ITEMID</property>
<property>string</property>
<property>7</property>
</structure>
<structure>
<property>2</property>
<property>PROJECT_AREA_NAME</property>
<property>PROJECT_AREA_NAME</property>
<property>string</property>
<property>2</property>
</structure>
</list>
<xml><CDATA></xml>
<xml><!]></xml>
<list>
<ex>
<name>fact</name>
<value>PROJECT_AREA</value>
</ex>
<ex>
<name>parameterFields</name>
<value>PROJECT_AREA_ITEMID,PROJECT_AREA_NAME</value>
</ex>
</list>
<property>PROJECT_AREA</property>
<property>PROJECT_AREA_ITEMID,PROJECT_AREA_NAME</property>
</oda>
<oda>
<list>
<structure>
<property>CONTRIBUTOR_ITEMID</property>
<text>CONTRIBUTOR_ITEMID</text>
</structure>
<structure>
<property>CONTRIBUTOR_USERID</property>
<text>CONTRIBUTOR_USERID</text>
</structure>
<structure>
<property>CONTRIBUTOR_NAME</property>
<text>CONTRIBUTOR_NAME</text>
</structure>
<structure>
<property>PROJECT_AREA_ITEMID</property>
<text>PROJECT_AREA_ITEMID</text>
</structure>
<structure>
<property>PROJECT_AREA_NAME</property>
<text>PROJECT_AREA_NAME</text>
</structure>
<structure>
<property>TEAM_AREA_ITEMID</property>
<text>TEAM_AREA_ITEMID</text>
</structure>
<structure>
<property>TEAM_AREA_NAME</property>
<text>TEAM_AREA_NAME</text>
</structure>
</list>
<list>
<structure>
<property>PROJECT_AREA_ITEMID</property>
<property>PROJECT_AREA_ITEMID</property>
<property>string</property>
<property>7</property>
<property>1</property>
<expression>'{Current Project Area}'</expression>
<property>true</property>
<property>true</property>
<property>true</property>
<property>false</property>
</structure>
<structure>
<property>RESULT_SET_SIZE</property>
<property>RESULT_SET_SIZE</property>
<property>integer</property>
<property>3</property>
<property>2</property>
<property>true</property>
<property>true</property>
<property>true</property>
</structure>
</list>
<structure>
<list>
<structure>
<property>1</property>
<property>CONTRIBUTOR_ITEMID</property>
<property>string</property>
</structure>
<structure>
<property>2</property>
<property>CONTRIBUTOR_USERID</property>
<property>string</property>
</structure>
<structure>
<property>3</property>
<property>CONTRIBUTOR_NAME</property>
<property>string</property>
</structure>
<structure>
<property>4</property>
<property>PROJECT_AREA_ITEMID</property>
<property>string</property>
</structure>
<structure>
<property>5</property>
<property>PROJECT_AREA_NAME</property>
<property>string</property>
</structure>
<structure>
<property>6</property>
<property>TEAM_AREA_ITEMID</property>
<property>string</property>
</structure>
<structure>
<property>7</property>
<property>TEAM_AREA_NAME</property>
<property>string</property>
</structure>
</list>
</structure>
<method><CDATA></method>
<property>Common Source</property>
<list>
<structure>
<property>1</property>
<property>CONTRIBUTOR_ITEMID</property>
<property>CONTRIBUTOR_ITEMID</property>
<property>string</property>
<property>7</property>
</structure>
<structure>
<property>2</property>
<property>CONTRIBUTOR_USERID</property>
<property>CONTRIBUTOR_USERID</property>
<property>string</property>
<property>2</property>
</structure>
<structure>
<property>3</property>
<property>CONTRIBUTOR_NAME</property>
<property>CONTRIBUTOR_NAME</property>
<property>string</property>
<property>2</property>
</structure>
<structure>
<property>4</property>
<property>PROJECT_AREA_ITEMID</property>
<property>PROJECT_AREA_ITEMID</property>
<property>string</property>
<property>7</property>
</structure>
<structure>
<property>5</property>
<property>PROJECT_AREA_NAME</property>
<property>PROJECT_AREA_NAME</property>
<property>string</property>
<property>2</property>
</structure>
<structure>
<property>6</property>
<property>TEAM_AREA_ITEMID</property>
<property>TEAM_AREA_ITEMID</property>
<property>string</property>
<property>7</property>
</structure>
<structure>
<property>7</property>
<property>TEAM_AREA_NAME</property>
<property>TEAM_AREA_NAME</property>
<property>string</property>
<property>2</property>
</structure>
</list>
<xml><CDATA></xml>
<xml><!]></xml>
<list>
<ex>
<name>fact</name>
<value>LIVE_CONTRIBUTOR</value>
</ex>
<ex>
<name>selectedFields</name>
<value>CONTRIBUTOR_ITEMID,CONTRIBUTOR_USERID,CONTRIBUTOR_NAME,PROJECT_AREA_ITEMID,PROJECT_AREA_NAME,TEAM_AREA_ITEMID,TEAM_AREA_NAME</value>
</ex>
<ex>
<name>parameterFields</name>
<value>PROJECT_AREA_ITEMID</value>
</ex>
</list>
<property>LIVE_CONTRIBUTOR</property>
<property>CONTRIBUTOR_ITEMID,CONTRIBUTOR_USERID,CONTRIBUTOR_NAME,PROJECT_AREA_ITEMID,PROJECT_AREA_NAME,TEAM_AREA_ITEMID,TEAM_AREA_NAME</property>
<property>PROJECT_AREA_ITEMID</property>
</oda>
<script>
<list>
<structure>
<property>1</property>
<property>user_id</property>
<property>string</property>
</structure>
<structure>
<property>2</property>
<property>user_name</property>
<property>string</property>
</structure>
<structure>
<property>3</property>
<property>leave_start</property>
<property>date</property>
</structure>
<structure>
<property>4</property>
<property>leave_end</property>
<property>date</property>
</structure>
<structure>
<property>5</property>
<property>validStartDate</property>
<property>boolean</property>
</structure>
<structure>
<property>6</property>
<property>validEndDate</property>
<property>boolean</property>
</structure>
</list>
<list>
<structure>
<property>user_id</property>
</structure>
<structure>
<property>user_name</property>
</structure>
<structure>
<property>leave_start</property>
</structure>
<structure>
<property>leave_end</property>
</structure>
<structure>
<property>validStartDate</property>
</structure>
<structure>
<property>validEndDate</property>
</structure>
</list>
<list>
<structure>
<property>le</property>
<expression>row</expression>
<simple>
<value>BirtDateTime.addDay(BirtDateTime.today(),90)</value>
</simple>
</structure>
<structure>
<property>ge</property>
<expression>row</expression>
<simple>
<value>BirtDateTime.today()</value>
</simple>
</structure>
</list>
<structure>
<list>
<structure>
<property>1</property>
<property>user_id</property>
<property>string</property>
</structure>
<structure>
<property>2</property>
<property>user_name</property>
<property>string</property>
</structure>
<structure>
<property>3</property>
<property>leave_start</property>
<property>date</property>
</structure>
<structure>
<property>4</property>
<property>leave_end</property>
<property>date</property>
</structure>
<structure>
<property>5</property>
<property>validStartDate</property>
<property>boolean</property>
</structure>
<structure>
<property>6</property>
<property>validEndDate</property>
<property>boolean</property>
</structure>
</list>
</structure>
<property>Scripted Data Source</property>
<method><CDATA></method>
<method><!;
dataSetIndex++;

for (count = 0; count <userData>=BirtDateTime.today())&&(leaveRecord.leave_start<BirtDateTime>=BirtDateTime.today())&&(leaveRecord.leave_end<BirtDateTime></method>
</script>
</data>
<styles>
<style>
<property>"Verdana"</property>
<property>10pt</property>
</style>
<style>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
</style>
<style>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
<property>#CCCCCC</property>
<property>solid</property>
<property>1pt</property>
</style>
</styles>
<page>
<simple>
<property>0.25in</property>
<property>0.25in</property>
<property>0.25in</property>
<property>0.25in</property>
<page>
<text>
<property>html</property>
<text><!]></text>
</text>
</page>
</simple>
</page>
<body>
<text>
<property>14pt</property>
<property>bold</property>
<property>Project Areas</property>
<list>
<structure>
<property>PROJECT_AREA_ITEMID</property>
<expression>dataSetRow</expression>
<property>string</property>
</structure>
<structure>
<property>PROJECT_AREA_NAME</property>
<expression>dataSetRow</expression>
<property>string</property>
</structure>
</list>
<expression>row + " Scheduled Absences - 3 Month View"</expression>
<property>html</property>
</text>
<text>
<property>#70A0E9</property>
<property>#000000</property>
<property>solid</property>
<property>1px</property>
<property>#000000</property>
<property>solid</property>
<property>1px</property>
<property>#000000</property>
<property>solid</property>
<property>1px</property>
<property>#000000</property>
<property>solid</property>
<property>1px</property>
<list>
<structure>
<property>all</property>
<expression>!params.value</expression>
</structure>
</list>
<property>html</property>
<text><!
<BR><BR>
The 'Scheduled Absences Report - 3 Month View' displays data on the <I>Resources</I> in the current project and the <I>Scheduled Absences</I> recorded against their profiles in the coming 3 months, from the current day.
&lt;BR&gt;&lt;BR&gt;
]]&gt;&lt;/text&gt;
&lt;/text&gt;
&lt;text&gt;
&lt;property&gt;Joint Scripted User Leave Data Set - Current Dates&lt;/property&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;all&lt;/property&gt;
&lt;expression&gt;true&lt;/expression&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;user_id&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;user_name&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_start&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;date&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_end&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;date&lt;/property&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;expression&gt;&quot;Hidden label attached to Joint Scripted User Leave Data Set - 3 Month View - &quot; + Total.count();&lt;/expression&gt;
&lt;property&gt;html&lt;/property&gt;
&lt;/text&gt;
&lt;text&gt;
&lt;property&gt;User Data Set&lt;/property&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;all&lt;/property&gt;
&lt;expression&gt;true&lt;/expression&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;CONTRIBUTOR_ITEMID&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;CONTRIBUTOR_USERID&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;CONTRIBUTOR_NAME&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;PROJECT_AREA_ITEMID&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;PROJECT_AREA_NAME&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;TEAM_AREA_ITEMID&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;TEAM_AREA_NAME&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;expression&gt;&quot;Hidden label attached to User Data Set - &quot; + Total.count();&lt;/expression&gt;
&lt;property&gt;html&lt;/property&gt;
&lt;/text&gt;
&lt;text&gt;
&lt;property&gt;Leave Data Set&lt;/property&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;all&lt;/property&gt;
&lt;expression&gt;true&lt;/expression&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;CONTRIBUTOR_USERID&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;CONTRIBUTOR_NAME&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;CONTRIBUTOR_ITEMID&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;ABSENCE_STARTDATE&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;date-time&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;ABSENCE_ENDDATE&lt;/property&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;date-time&lt;/property&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;expression&gt;&quot;Hidden label attached to Leave Data Set - &quot; + Total.count();&lt;/expression&gt;
&lt;property&gt;html&lt;/property&gt;
&lt;/text&gt;
&lt;label&gt;
&lt;table&gt;
&lt;property&gt;0pt&lt;/property&gt;
&lt;property&gt;50px&lt;/property&gt;
&lt;property&gt;60%&lt;/property&gt;
&lt;property&gt;Joint Scripted User Leave Data Set - Current Dates&lt;/property&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;user_id&lt;/property&gt;
&lt;text&gt;user_id&lt;/text&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;user_name&lt;/property&gt;
&lt;text&gt;name&lt;/text&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_start&lt;/property&gt;
&lt;text&gt;start&lt;/text&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;date&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_end&lt;/property&gt;
&lt;text&gt;end&lt;/text&gt;
&lt;expression&gt;dataSetRow&lt;/expression&gt;
&lt;property&gt;date&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_month&lt;/property&gt;
&lt;text&gt;month&lt;/text&gt;
&lt;expression&gt;BirtDateTime.month(dataSetRow)&lt;/expression&gt;
&lt;property&gt;integer&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;Group_Month&lt;/property&gt;
&lt;text&gt;month&lt;/text&gt;
&lt;expression&gt;BirtDateTime.month(dataSetRow,2)&lt;/expression&gt;
&lt;property&gt;string&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_year_simple&lt;/property&gt;
&lt;text&gt;year&lt;/text&gt;
&lt;expression&gt;BirtDateTime.year(dataSetRow)&lt;/expression&gt;
&lt;property&gt;integer&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;property&gt;leave_year&lt;/property&gt;
&lt;text&gt;year&lt;/text&gt;
&lt;expression&gt;BirtDateTime.year(dataSetRow)&lt;/expression&gt;
&lt;property&gt;integer&lt;/property&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;expression&gt;row&lt;/expression&gt;
&lt;property&gt;asc&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;expression&gt;row&lt;/expression&gt;
&lt;property&gt;asc&lt;/property&gt;
&lt;/structure&gt;
&lt;structure&gt;
&lt;expression&gt;row&lt;/expression&gt;
&lt;property&gt;asc&lt;/property&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;column&gt;
&lt;column&gt;
&lt;column&gt;
&lt;property&gt;20px&lt;/property&gt;
&lt;/column&gt;
&lt;column&gt;
&lt;column&gt;
&lt;property&gt;1&lt;/property&gt;
&lt;/column&gt;
&lt;header&gt;
&lt;row&gt;
&lt;cell&gt;
&lt;property&gt;5&lt;/property&gt;
&lt;property&gt;1&lt;/property&gt;
&lt;label&gt;
&lt;property&gt;#FFFFFF&lt;/property&gt;
&lt;property&gt;12pt&lt;/property&gt;
&lt;property&gt;bold&lt;/property&gt;
&lt;property&gt;5pt&lt;/property&gt;
&lt;property&gt;left&lt;/property&gt;
&lt;text&gt;Grouped on Year/Month&lt;/text&gt;
&lt;/label&gt;
&lt;/cell&gt;
&lt;/row&gt;
&lt;row&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;all&lt;/property&gt;
&lt;expression&gt;true&lt;/expression&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;cell&gt;
&lt;property&gt;5&lt;/property&gt;
&lt;property&gt;1&lt;/property&gt;
&lt;label&gt;
&lt;property&gt;#80FF80&lt;/property&gt;
&lt;list&gt;
&lt;structure&gt;
&lt;property&gt;all&lt;/property&gt;
&lt;expression&gt;true&lt;/expression&gt;
&lt;/structure&gt;
&lt;/list&gt;
&lt;text&gt;Joint Scripted User Leave Data Set - Current Dates&lt;/text&gt;
&lt;/label&gt;
&lt;/cell&gt;
&lt;/row&gt;
&lt;row&gt;
&lt;property&gt;silver&lt;/property&gt;
&lt;cell&gt;
&lt;label&gt;
&lt;property&gt;12pt&lt;/property&gt;
&lt;property&gt;bold&lt;/property&gt;
&lt;property&gt;left&lt;/property&gt;
&lt;text&gt;Year / Month&lt;/text&gt;
&lt;/label&gt;
&lt;/cell&gt;
&lt;cell&gt;
&lt;label&gt;
&lt;property&gt;12pt&lt;/property&gt;
&lt;property&gt;bold&lt;/property&gt;
&lt;property&gt;right&lt;/property&gt;
&lt;text&gt;Start Date&lt;/text&gt;
&lt;/label&gt;
&lt;/cell&gt;
&lt;cell&gt;
&lt;cell&gt;
&lt;label&gt;
&lt;property&gt;12pt&lt;/property&gt;
&lt;property&gt;bold&lt;/property&gt;
&lt;property&gt;left&lt;/property&gt;
&lt;text&gt;End Date&lt;/text&gt;
&lt;/label&gt;
&lt;/cell&gt;
&lt;cell&gt;
&lt;label&gt;
&lt;property&gt;12pt&lt;/property&gt;
&lt;property&gt;bold&lt;/property&gt;
&lt;property&gt;left&lt;/property&gt;
&lt;text&gt;Name&lt;/text&gt;
&lt;/label&gt;
&lt;/cell&gt;
&lt;/row&gt;
&lt;/header&gt;
&lt;group&gt;
&lt;property&gt;Year_Group&lt;/property&gt;
&lt;property&gt;none&lt;/property&gt;
&lt;property&gt;asc&lt;/property&gt;
&lt;expression&gt;row&lt;/expression&gt;
&lt;structure&gt;
&lt;expression&gt;row&lt;/expression&gt;
&lt;/structure&gt;
&lt;property&gt;true&lt;/property&gt;
&lt;property&gt;false&lt;/property&gt;
&lt;property&gt;

Comments
Matt McGinn commented Jul 23 '12, 2:12 a.m.

This issue has been resolved - not sure what was done, but we can now see the projects listed in the Project Area data-table and hence the report is able to extract the correct data.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.