Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Content Management
- Alfresco
- Alfresco Archive
- BIRT Report an Alfresco - Blank report
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BIRT Report an Alfresco - Blank report
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2010 03:51 PM
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:
rtpdesign file:
Can anyone help me with this one?
Thanks
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 <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
Labels:
- Labels:
-
Archive
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2010 01:32 PM
Hello again,
The problem is solved by add ALF_TICKET on my report document settings.
Thanks again!
The problem is solved by add ALF_TICKET on my report document settings.
Thanks again!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2011 03:31 PM
Hey, can one of you, tell me how you have set ALF_TICKET in BIRT? Actully, I am facing the same problem while trying to call web script from a BIRT report.
It connects to XML Response resulted from web script but still the report comes blank. If I provide xml data source url with extension like:
http://localhost:8080/alfresco/...../webscript?ticket=TICKET_8d3e565782c775bd26839b78e636a89e7cbd536..., it shows all the record from the XMl file, but it wont work all the time, as I need to provide ticket dynemically.
Can you help me out?
It connects to XML Response resulted from web script but still the report comes blank. If I provide xml data source url with extension like:
http://localhost:8080/alfresco/...../webscript?ticket=TICKET_8d3e565782c775bd26839b78e636a89e7cbd536..., it shows all the record from the XMl file, but it wont work all the time, as I need to provide ticket dynemically.
Can you help me out?
Related Content
- How to Report Security Issues for Alfresco in Alfresco Blog
- Important topics and useful resources in Alfresco Forum
- Where to report a security vulnerability in Alfresco Forum
- Getting Started: Run Alfresco AI Development Locally with Docker Model Runner in Alfresco Blog
- Alfresco Customer Newsletter - January 2025 in Alfresco Blog
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
