AnsweredAssumed Answered

BIRT Report an Alfresco - Blank report

Question asked by rafaelscg on Jul 28, 2010
Latest reply on Feb 7, 2011 by ronak
Hi experts,

Im trying to implement the extension for generate BIRT Reports for alfresco.
I create Webscript and this return to me XML response. When i test the report on Eclipse, i can generate the report with all datas what i need.
All installation of this module in Alfresco works fine (i guess). I can generate reports with schedule or by click on report file action. But, on both options, the reports generated dont have any datas (only headers). I dont know if i do anything wrong.

The Xml response:
<records>
<type>com_bluexml_crm_Contact</type>
<qName>crm:com_bluexml_crm_Contact</qName>

<items>

<item>
<id>fd2648fb-f45e-402a-bef1-c425b1a238f9</id>
<displayPath>/Company Home</displayPath>
<icon16>/alfresco/images/icons/space-icon-default.gif</icon16>

<nodeRef>
workspace://SpacesStore/fd2648fb-f45e-402a-bef1-c425b1a238f9
</nodeRef>
<com_bluexml_crm_Contact_firstName>Data Dictionary</com_bluexml_crm_Contact_firstName>
<com_bluexml_crm_Contact_size>14</com_bluexml_crm_Contact_size>
</item>

<item>
<id>e9eceb17-caf5-47c4-bedd-592074372ef4</id>
<displayPath>/Company Home</displayPath>
<icon16>/alfresco/images/icons/space-icon-default.gif</icon16>

<nodeRef>
workspace://SpacesStore/e9eceb17-caf5-47c4-bedd-592074372ef4
</nodeRef>
<com_bluexml_crm_Contact_firstName>Guest Home</com_bluexml_crm_Contact_firstName>
<com_bluexml_crm_Contact_size>0</com_bluexml_crm_Contact_size>
</item>

<item>
<id>432755df-2bed-4e18-b44d-bf10b5211edc</id>
<displayPath>/Company Home</displayPath>
<icon16>/alfresco/images/icons/space-icon-default.gif</icon16>

<nodeRef>
workspace://SpacesStore/432755df-2bed-4e18-b44d-bf10b5211edc
</nodeRef>
<com_bluexml_crm_Contact_firstName>User Homes</com_bluexml_crm_Contact_firstName>
<com_bluexml_crm_Contact_size>0</com_bluexml_crm_Contact_size>
</item>

<item>
<id>847302d2-4143-4a47-9a79-781a6ed17e26</id>
<displayPath>/Company Home</displayPath>
<icon16>/alfresco/images/icons/space-icon-default.gif</icon16>

<nodeRef>
workspace://SpacesStore/847302d2-4143-4a47-9a79-781a6ed17e26
</nodeRef>
<com_bluexml_crm_Contact_firstName>Sites</com_bluexml_crm_Contact_firstName>
<com_bluexml_crm_Contact_size>0</com_bluexml_crm_Contact_size>
</item>

<item>
<id>fa89213a-736a-4d2e-ac49-1042d21ec9d0</id>
<displayPath>/Company Home</displayPath>
<icon16>/alfresco/images/icons/space-icon-default.gif</icon16>

<nodeRef>
workspace://SpacesStore/fa89213a-736a-4d2e-ac49-1042d21ec9d0
</nodeRef>
<com_bluexml_crm_Contact_firstName>Banco IBI</com_bluexml_crm_Contact_firstName>
<com_bluexml_crm_Contact_size>1</com_bluexml_crm_Contact_size>
</item>
</items>
<totalCount>5</totalCount>
</records>

rtpdesign file:
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build &lt;2.3.2.v20090218-0730></property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="Data Source" id="7">
            <text-property name="displayName"></text-property>
            <property name="FILELIST">http://localhost:8080/alfresco/service/com_bluexml_crm_Contact.xml</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Other Test" id="8">
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">id</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">displayPath</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">icon16</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">nodeRef</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">com_bluexml_crm_Contact_firstName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">com_bluexml_crm_Contact_size</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">id</property>
                    <property name="nativeName">id</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">displayPath</property>
                    <property name="nativeName">displayPath</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">icon16</property>
                    <property name="nativeName">icon16</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">nodeRef</property>
                    <property name="nativeName">nodeRef</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">com_bluexml_crm_Contact_firstName</property>
                    <property name="nativeName">com_bluexml_crm_Contact_firstName</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">com_bluexml_crm_Contact_size</property>
                    <property name="nativeName">com_bluexml_crm_Contact_size</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <property name="queryText">table0#-TNAME-#table0#:#[/records/items/item]#:#{id;STRING;/id},{displayPath;STRING;/displayPath},{icon16;STRING;/icon16},{nodeRef;STRING;/nodeRef},{com_bluexml_crm_Contact_firstName;STRING;/com_bluexml_crm_Contact_firstName},{com_bluexml_crm_Contact_size;STRING;/com_bluexml_crm_Contact_size}</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>1.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>id</design:name>
            <design:position>1</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>id</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>displayPath</design:name>
            <design:position>2</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>displayPath</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>icon16</design:name>
            <design:position>3</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>icon16</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>nodeRef</design:name>
            <design:position>4</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>nodeRef</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>com_bluexml_crm_Contact_firstName</design:name>
            <design:position>5</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>com_bluexml_crm_Contact_firstName</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>com_bluexml_crm_Contact_size</design:name>
            <design:position>6</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>com_bluexml_crm_Contact_size</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>MAX_ROW</name>
                    <value>1</value>
                </ex-property>
                <ex-property>
                    <name>XML_FILE</name>
                </ex-property>
            </list-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">"Verdana"</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="topMargin">0.25in</property>
            <property name="leftMargin">0.25in</property>
            <property name="bottomMargin">0.25in</property>
            <property name="rightMargin">0.25in</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>
        <list id="9">
            <property name="dataSet">Other Test</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">id</property>
                    <property name="displayName">id</property>
                    <expression name="expression">dataSetRow["id"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">displayPath</property>
                    <property name="displayName">displayPath</property>
                    <expression name="expression">dataSetRow["displayPath"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">icon16</property>
                    <property name="displayName">icon16</property>
                    <expression name="expression">dataSetRow["icon16"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">nodeRef</property>
                    <property name="displayName">nodeRef</property>
                    <expression name="expression">dataSetRow["nodeRef"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">com_bluexml_crm_Contact_firstName</property>
                    <property name="displayName">com_bluexml_crm_Contact_firstName</property>
                    <expression name="expression">dataSetRow["com_bluexml_crm_Contact_firstName"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">com_bluexml_crm_Contact_size</property>
                    <property name="displayName">com_bluexml_crm_Contact_size</property>
                    <expression name="expression">dataSetRow["com_bluexml_crm_Contact_size"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <header>
                <label id="17">
                    <property name="fontWeight">bold</property>
                    <property name="textAlign">center</property>
                    <text-property name="text">Relatorio de espacos no Company Home</text-property>
                </label>
            </header>
            <detail>
                <data id="10">
                    <property name="resultSetColumn">id</property>
                </data>
                <data id="11">
                    <property name="resultSetColumn">displayPath</property>
                </data>
                <data id="12">
                    <property name="resultSetColumn">icon16</property>
                </data>
                <data id="13">
                    <property name="resultSetColumn">nodeRef</property>
                </data>
                <data id="14">
                    <property name="resultSetColumn">com_bluexml_crm_Contact_firstName</property>
                </data>
                <data id="15">
                    <property name="resultSetColumn">com_bluexml_crm_Contact_size</property>
                </data>
                <label id="16">
                    <property name="backgroundColor">black</property>
                    <text-property name="text"> </text-property>
                </label>
            </detail>
        </list>
    </body>
</report>

Can anyone help me with this one?

Thanks

Outcomes