[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.birt] Re: Error on report (preview tab) "The report contains errors, would you like to continue for previewing" 
Moi,

Does the expression.txt file get created?
When you drop the expression does it work?

Jason

moi wrote: 
No there is no error trace at the bottom of the report.
The expression :
<<
// To comment only there for design time
    importPackage( Packages.java.io );
    importPackage( Packages.javax.servlet.http );

    var cookies = reportContext.getHttpServletRequest( ).getCookies();

out = new PrintWriter( new FileWriter( "c:/expression.txt", true ) );
var login;
var password;
out.println("fetching cookies");
out.println("cookies.length : " + cookies.length);
for(var i=0; i < cookies.length; i++) {
var monCookie = cookies[i];
out.println("cookie found : " + monCookie.getName());
if (monCookie.getName().equals("report_login")) {
login = cookies[i].getValue();
}
else if (monCookie.getName().equals("report_password")) { password = cookies[i].getValue();
}
}

out.println( "login : " + login);
out.println( "password : " + password);

if (login != null) {
out.close();
"http://localhost:6060/orsid_js/xmlQuery.jsp?login="; + login + "&password=" + password;
}
else {
out.close();
"C:\\report1_datas.xml";
}
>>

Jason Weathersby a écrit : 
Moi,

Do you get an error trace at the bottom of the report?
Can you drop the expression in property binding? I assume this is where it is happening. Add a little of it back at a time.

Jason

moi wrote: 
Hi,

A report generated with birt 2.3.1 shows the error : "The report contains errors, would you like to continue for previewing".

Do you know where is the error ? I cannot find it.

Regards,
Moi.

-----
<?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.1.v20080911 Build &lt;2.3.1.v20080922-1151></property>
<property name="units">in</property>
<list-property name="propertyBindings">
<structure>
<property name="name">FILELIST</property>
<property name="id">26</property>
<expression name="value">// To comment only there for design time
importPackage( Packages.java.io );
importPackage( Packages.javax.servlet.http );

    var cookies = reportContext.getHttpServletRequest( ).getCookies();

out = new PrintWriter( new FileWriter( "c:/expression.txt", true ) );
var login;
var password;
out.println("fetching cookies");
out.println("cookies.length : " + cookies.length);
for(var i=0; i &lt; cookies.length; i++) {
var monCookie = cookies[i];
out.println("cookie found : " + monCookie);
if (monCookie.getName().equals("report_login")) {
login = cookies[i].getValue();
}
else if (monCookie.getName().equals("report_password")) { password = cookies[i].getValue();
}
}

var request = reportContext.getHttpServletRequest();
var login = request.getSession().getAttribute("login");
var password = request.getSession().getAttribute("password");

out.println( "login : " + login);
out.println( "password : " + password);

if (login != null) {
out.close();
"http://localhost:6060/orsid_js/xmlQuery.jsp?login="; + login + "&amp;password=" + password;
}
else {
out.close();
"C:\\report1_datas.xml";
}</expression>
</structure>
</list-property>
<property name="iconFile">/templates/simple_listing.gif</property>
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting</property>

<property name="bidiLayoutOrientation">ltr</property>
<parameters>
<scalar-parameter name="login" id="27">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">login</text-property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="password" id="28">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="queryXML" id="26">
<property name="FILELIST">C:\report1_datas.xml</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Data Set1" id="52">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Workey_Id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Workey_Doctype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Workey_Subject</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">queryXML</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Workey_Id</property>
<property name="nativeName">Workey_Id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Workey_Doctype</property>
<property name="nativeName">Workey_Doctype</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Workey_Subject</property>
<property name="nativeName">Workey_Subject</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">table0#-TNAME-#table0#:#[/hits/hit]#:#{Workey_Id;STRING;/Workey_Id},{Workey_Doctype;STRING;/Workey_Doctype},{Workey_Subject;STRING;/Workey_Subject}#:#&lt;"","http:%%www.c-log.com%ns%workey-j2ee-api";"xlink","http:%%www.w3.org%1999%xlink";"xsi","http:%%www.w3.org%2001%XMLSchema-instance"></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>Workey_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>Workey_Id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>Workey_Doctype</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>Workey_Doctype</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>Workey_Subject</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>Workey_Subject</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="crosstab-cell" id="24">
<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="25">
<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">
<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>
<table id="53">
<property name="width">100%</property>
<property name="dataSet">Data Set1</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Workey_Id</property>
<property name="displayName">Workey_Id</property>
<expression name="expression">dataSetRow["Workey_Id"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Workey_Doctype</property>
<property name="displayName">Workey_Doctype</property>
<expression name="expression">dataSetRow["Workey_Doctype"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Workey_Subject</property>
<property name="displayName">Workey_Subject</property>
<expression name="expression">dataSetRow["Workey_Subject"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="72"/>
<column id="73"/>
<column id="74"/>
<header>
<row id="54">
<cell id="55">
<label id="56">
<text-property name="text">Workey_Id</text-property>
</label>
</cell>
<cell id="57">
<label id="58">
<text-property name="text">Workey_Doctype</text-property>
</label>
</cell>
<cell id="59">
<label id="60">
<text-property name="text">Workey_Subject</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="61">
<cell id="62">
<data id="63">
<property name="resultSetColumn">Workey_Id</property>
</data>
</cell>
<cell id="64">
<data id="65">
<property name="resultSetColumn">Workey_Doctype</property>
</data>
</cell>
<cell id="66">
<data id="67">
<property name="resultSetColumn">Workey_Subject</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="68">
<cell id="69"/>
<cell id="70"/>
<cell id="71"/>
</row>
</footer>
</table>
</body>
</report>
-----