org.eclipse.birt.report.engine.api.EngineException: Can not load the report query

detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 186. Errors occurred when generating the report document for the report element with ID 186. (Element ID:186) 
Please help 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design</a>" version="3.2.22" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build <2.6.2.v20110214-1523></property> 
<property name="units">in</property> 
<property name="iconFile">/templates/blank_report.gif</property> 
<property name="layoutPreference">fixed layout</property> 
<property name="bidiLayoutOrientation">ltr</property> 
<property name="imageDPI">96</property> 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7"> 
<property name="odaDriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property> 
<property name="odaJndiName">java:jboss/datasources/XXXXXXXXXDbDatasource</property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set1" id="91"> 
<property name="nullsOrdering">nulls lowest</property> 
<list-property name="columnHints"> 
<structure> 
<property name="columnName">firstname</property> 
<text-property name="displayName">firstname</text-property> 
<text-property name="heading">firstname</text-property> 
</structure> 
<structure> 
<property name="columnName">lastname</property> 
<text-property name="displayName">lastname</text-property> 
<text-property name="heading">lastname</text-property> 
</structure> 
<structure> 
<property name="columnName">username</property> 
<text-property name="displayName">username</text-property> 
<text-property name="heading">username</text-property> 
</structure> 
<structure> 
<property name="columnName">emailAddress</property> 
<text-property name="displayName">emailAddress</text-property> 
<text-property name="heading">emailAddress</text-property> 
</structure> 
<structure> 
<property name="columnName">lastLogin</property> 
<text-property name="displayName">lastLogin</text-property> 
<text-property name="heading">lastLogin</text-property> 
</structure> 
<structure> 
<property name="columnName">registrationDate</property> 
<text-property name="displayName">registrationDate</text-property> 
<text-property name="heading">registrationDate</text-property> 
</structure> 
</list-property> 
<structure name="cachedMetaData"> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">firstname</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">lastname</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">username</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">emailAddress</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">lastLogin</property> 
<property name="dataType">date-time</property> 
</structure> 
<structure> 
<property name="position">6</property> 
<property name="name">registrationDate</property> 
<property name="dataType">date-time</property> 
</structure> 
</list-property> 
</structure> 
<property name="dataSource">Data Source</property> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">firstname</property> 
<property name="nativeName">firstname</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">lastname</property> 
<property name="nativeName">lastname</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">username</property> 
<property name="nativeName">username</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">emailAddress</property> 
<property name="nativeName">emailAddress</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">lastLogin</property> 
<property name="nativeName">lastLogin</property> 
<property name="dataType">date-time</property> 
</structure> 
<structure> 
<property name="position">6</property> 
<property name="name">registrationDate</property> 
<property name="nativeName">registrationDate</property> 
<property name="dataType">date-time</property> 
</structure> 
</list-property> 
<xml-property name="queryText"><![CDATA[select ua.username as uname,ua.firstname as fname,ua.lastname as lname, wu.emailAddress as email, wu.lastLogin as lastlogin, wu.registrationDate as registrationDate from UserAccount ua join ua.webUser wu where ua.userType='HO' order by wu.lastLogin DESC]]></xml-property> 
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?> 
<model:DesignValues xmlns:design="<a data-ipb='nomediaparse' href='http://www.eclipse.org/datatools/connectivity/oda/design'>http://www.eclipse.org/datatools/connectivity/oda/design</a>" xmlns:model="<a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/report/model/adapter/odaModel'>http://www.eclipse.org/birt/report/model/adapter/odaModel</a>"> 
<Version>2.0</Version>< 
<design:ResultSets derivedMetaData="true"> 
<design:resultSetDefinitions> 
<design:resultSetColumns> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:identifier> 
<design:name>occurredWhen</design:name> 
<design:position>1</design:position> 
</design:identifier> 
<design:nativeDataTypeCode>93</design:nativeDataTypeCode> 
<design:precision>-1</design:precision> 
<design:scale>-1</design:scale> 
<design:nullability>Unknown</design:nullability> 
<design:uiHints> 
<design:displayName>occurredWhen</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>occurredWhen</design:label> 
<design:formattingHints> 
<design:displaySize>8</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:identifier> 
<design:name>username</design:name> 
<design:position>2</design:position> 
</design:identifier> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>-1</design:precision> 
<design:scale>-1</design:scale> 
<design:nullability>Unknown</design:nullability> 
<design:uiHints> 
<design:displayName>username</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>username</design:label> 
<design:formattingHints> 
<design:displaySize>8</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
</design:resultSetColumns> 
<design:criteria/> 
</design:resultSetDefinitions> 
</design:ResultSets> 
</model:DesignValues>]]></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="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> 
<label id="208"> 
<property name="backgroundAttachment">scroll</property> 
<property name="backgroundPositionX">0%</property> 
<property name="backgroundPositionY">0%</property> 
<property name="backgroundRepeat">repeat</property> 
<property name="fontFamily">sans-serif</property> 
<property name="fontSize">12pt</property> 
<property name="fontWeight">bold</property> 
<property name="fontStyle">normal</property> 
<property name="fontVariant">normal</property> 
<property name="color">black</property> 
<property name="textLineThrough">none</property> 
<property name="textOverline">none</property> 
<property name="textUnderline">none</property> 
<property name="borderBottomColor">black</property> 
<property name="borderBottomStyle">none</property> 
<property name="borderBottomWidth">medium</property> 
<property name="borderLeftColor">black</property> 
<property name="borderLeftStyle">none</property> 
<property name="borderLeftWidth">medium</property> 
<property name="borderRightColor">black</property> 
<property name="borderRightStyle">none</property> 
<property name="borderRightWidth">medium</property> 
<property name="borderTopColor">black</property> 
<property name="borderTopStyle">none</property> 
<property name="borderTopWidth">medium</property> 
<property name="marginTop">0pt</property> 
<property name="marginLeft">0pt</property> 
<property name="marginBottom">0pt</property> 
<property name="marginRight">0pt</property> 
<property name="paddingTop">1pt</property> 
<property name="paddingLeft">1pt</property> 
<property name="paddingBottom">1pt</property> 
<property name="paddingRight">1pt</property> 
<property name="textAlign">center</property> 
<property name="letterSpacing">normal</property> 
<property name="lineHeight">normal</property> 
<property name="orphans">2</property> 
<property name="textTransform">none</property> 
<property name="whiteSpace">normal</property> 
<property name="widows">2</property> 
<property name="wordSpacing">normal</property> 
<property name="display">block</property> 
<property name="pageBreakAfter">auto</property> 
<property name="pageBreakBefore">auto</property> 
<property name="pageBreakInside">auto</property> 
<property name="showIfBlank">false</property> 
<property name="canShrink">false</property> 
<property name="overflow">hidden</property> 
<text-property name="text">Home Office User Access Report</text-property> 
</label> 
<table id="186"> 
<property name="textAlign">center</property> 
<property name="width">10.302083333333334in</property> 
<property name="dataSet">Data Set1</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">firstname</property> 
<text-property name="displayName">firstname</text-property> 
<expression name="expression" type="javascript">dataSetRow["fname"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">lastname</property> 
<text-property name="displayName">lastname</text-property> 
<expression name="expression" type="javascript">dataSetRow["lname"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">username</property> 
<text-property name="displayName">username</text-property> 
<expression name="expression" type="javascript">dataSetRow["uname"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">emailAddress</property> 
<text-property name="displayName">emailAddress</text-property> 
<expression name="expression" type="javascript">dataSetRow["email"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">lastLogin</property> 
<text-property name="displayName">lastLogin</text-property> 
<expression name="expression" type="javascript">dataSetRow["lastlogin"]</expression> 
<property name="dataType">date-time</property> 
</structure> 
<structure> 
<property name="name">registrationDate</property> 
<text-property name="displayName">registrationDate</text-property> 
<expression name="expression" type="javascript">dataSetRow["registrationDate"]</expression> 
<property name="dataType">date-time</property> 
</structure> 
<structure> 
<property name="name">Count</property> 
<text-property name="displayName">Count</text-property> 
<property name="dataType">integer</property> 
<property name="aggregateFunction">COUNT</property> 
<list-property name="arguments"> 
<structure> 
<property name="name">Expression</property> 
</structure> 
</list-property> 
</structure> 
</list-property> 
<column id="205"> 
<property name="width">1.6145833333333333in</property> 
</column> 
<column id="206"> 
<property name="width">1.75in</property> 
</column> 
<column id="207"> 
<property name="width">1.75in</property> 
</column> 
<header> 
<row id="187"> 
<cell id="301"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<label id="302"> 
<text-property name="text">First Name</text-property> 
</label> 
</cell> 
<cell id="303"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<label id="304"> 
<text-property name="text">Last Name</text-property> 
</label> 
</cell> 
<cell id="190"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<label id="193"> 
<text-property name="text">User Name</text-property> 
</label> 
</cell> 
<cell id="305"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<label id="306"> 
<text-property name="text">Email Address</text-property> 
</label> 
</cell> 
<cell id="307"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<label id="308"> 
<text-property name="text">Last Login</text-property> 
</label> 
</cell> 
<cell id="309"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<label id="332"> 
<text-property name="text">Registration Date</text-property> 
</label> 
</cell> 
</row> 
</header> 
<detail> 
<row id="194"> 
<cell id="312"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<data id="313"> 
<property name="textAlign">center</property> 
<property name="whiteSpace">nowrap</property> 
<property name="resultSetColumn">firstname</property> 
</data> 
</cell> 
<cell id="314"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<data id="315"> 
<property name="textAlign">center</property> 
<property name="whiteSpace">nowrap</property> 
<property name="resultSetColumn">lastname</property> 
</data> 
</cell> 
<cell id="310"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<data id="311"> 
<property name="textAlign">center</property> 
<property name="whiteSpace">nowrap</property> 
<property name="resultSetColumn">username</property> 
</data> 
</cell> 
<cell id="316"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<data id="317"> 
<property name="textAlign">center</property> 
<property name="whiteSpace">nowrap</property> 
<property name="resultSetColumn">emailAddress</property> 
</data> 
</cell> 
<cell id="195"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<data id="196"> 
<structure name="dateTimeFormat"> 
<property name="category">Custom</property> 
<property name="pattern">M/d/yy h:mm:ss a</property> 
</structure> 
<property name="textAlign">center</property> 
<property name="whiteSpace">nowrap</property> 
<property name="resultSetColumn">lastLogin</property> 
</data> 
</cell> 
<cell id="333"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<data id="334"> 
<structure name="dateTimeFormat"> 
<property name="category">Custom</property> 
<property name="pattern">M/d/yy h:mm:ss a</property> 
</structure> 
<property name="textAlign">center</property> 
<property name="whiteSpace">nowrap</property> 
<property name="resultSetColumn">registrationDate</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="202"> 
<cell id="203"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
<property name="fontWeight">bold</property> 
<text id="204"> 
<property name="display">inline</property> 
<property name="contentType">auto</property> 
<text-property name="content"><![CDATA[Count:]]></text-property> 
</text> 
<data id="205"> 
<property name="display">inline</property> 
<property name="resultSetColumn">Count</property> 
</data> 
</cell> 
<cell id="206"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
</cell> 
<cell id="207"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
</cell> 
<cell id="407"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
</cell> 
<cell id="507"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
</cell> 
<cell id="508"> 
<property name="borderBottomColor">#C0C0C0</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#C0C0C0</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#C0C0C0</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#C0C0C0</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<property name="verticalAlign">middle</property> 
</cell> 
</row> 
</footer> 
</table> 
</body> 
</report>

Find more posts tagged with

Comments

fannyV

Hi, 
Did you fix it? 
 
Could you execute : 
<pre class="_prettyXprint _lang-nocode">
select
ua.username as uname,
ua.firstname as fname,
ua.lastname as lname,
wu.emailAddress as email,
wu.lastLogin as lastlogin,
wu.registrationDate as registrationDate
from UserAccount ua
join ua.webUser wu
where ua.userType='HO'
order by wu.lastLogin DESC
</pre>
In your database or when you edit the data set, try to preview the results. Did you receive anything? 
 
Did you set the database URL, User Name, and password in the database source?