Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » PDF - Generation Time...
PDF - Generation Time... [message #368125] Tue, 05 May 2009 14:28 Go to next message
Patrick is currently offline PatrickFriend
Messages: 48
Registered: July 2009
Member
Hello!:-)

I'have a report, where the html generation for a preview takes about 39
seconds. When i try to preview the report in pdf, it's not done in 4
Minutes. Is that normal? My other reports have about 50% time - diference
at maximum.
If its not normal, how can i speed up the report generation in pdf?

Thanks!
(BIRT 2.1.3, RCP Designer )

Report message to a moderator

Re: PDF - Generation Time... [message #368127 is a reply to message #368125] Tue, 05 May 2009 14:32 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Patrick,

Can you post the report?

Jason

Patrick wrote:
> Hello!:-)
>
> I'have a report, where the html generation for a preview takes about 39
> seconds. When i try to preview the report in pdf, it's not done in 4
> Minutes. Is that normal? My other reports have about 50% time -
> diference at maximum. If its not normal, how can i speed up the report
> generation in pdf?
>
> Thanks!
> (BIRT 2.1.3, RCP Designer )
>

Report message to a moderator

Re: PDF - Generation Time... [message #368130 is a reply to message #368127] Tue, 05 May 2009 15:13 Go to previous messageGo to next message
Patrick is currently offline PatrickFriend
Messages: 48
Registered: July 2009
Member
Here it comes...

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.7"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build
&lt;20051130-1157></property>
<property name="units">mm</property>
<property name="comments">Copyright (c) 2006 &lt;&lt;Your Company Name
here>></property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">42</property>
<expression name="value">"Select st.cusid, cu.NAME1 as
CusName1, cu.NAME2 as CusName2, st.artid, st.PACID as VPK, st.NAME1,
st.NAME2, cu.bunid, SUM(st.TURNOVER08) as UmsLfdJahr, SUM(st.TURNOVER07)
as UmsVorjahr, SUM(st.TURNOVER06) as UmsVorvorjahr,SUM(st.QUANTITY08) as
MenLfdJahr, SUM(st.QUANTITY07) as MenVorjahr, SUM(st.QUANTITY06) as
MenVorvorjahr,SUM(st.PROFIT08) as RohgLfdJahr, SUM(st.PROFIT07) as
RohgVorjahr, SUM(st.PROFIT06) as RohgVorvorjahr from
KINFO.STAT"+params["bunId"]+"01 st, KINFO.CUSTOMER01 cu where cu.bunid =
'"+params["bunId"]+"' and st.cusid = cu.cusid group by cu.bunid,
st.CUSID, cu.NAME1, cu.NAME2, st.artid, st.PACID, st.NAME1, st.NAME2 order
by cu.NAME1, st.NAME1 asc, st.NAME2 asc, st.PACID asc"</expression>
</structure>
<structure>
<property name="name">queryText</property>
<property name="id">46</property>
<expression name="value">"Select NAME from KINFO.BUSUNTP where
BUNID = '"+params["bunId"]+"'"</expression>
</structure>
</list-property>
<parameters>
<scalar-parameter name="bunId" id="45">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<property name="defaultValue">ST</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="username" id="505">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<property name="defaultValue">Max Mustermann</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="DatenVorhanden" id="979">
<property name="valueType">static</property>
<property name="dataType">integer</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="com.iq.oda.ws" name="Debala04"
id="41"/>
</data-sources>
<data-sets>
<oda-data-set extensionID="com.iq.oda.ws.dataSet"
name="WSDB2_StatData_QuantityPerYear" id="42">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ARTID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">NAME1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">NAME2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">VPK</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">UMSLFDJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">UMSVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">UMSVORVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MENLFDJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MENVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MENVORVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ROHGLFDJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">ROHGVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">ROHGVORVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">CUSID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">CUSNAME1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CUSNAME2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">BUNID</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="rowFetchLimit">0</property>
<property name="dataSource">Debala04</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ARTID</property>
<property name="nativeName">ARTID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">NAME1</property>
<property name="nativeName">NAME1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">NAME2</property>
<property name="nativeName">NAME2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">VPK</property>
<property name="nativeName">VPK</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">UMSLFDJAHR</property>
<property name="nativeName">UMSLFDJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">UMSVORJAHR</property>
<property name="nativeName">UMSVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">UMSVORVORJAHR</property>
<property name="nativeName">UMSVORVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MENLFDJAHR</property>
<property name="nativeName">MENLFDJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MENVORJAHR</property>
<property name="nativeName">MENVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MENVORVORJAHR</property>
<property name="nativeName">MENVORVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ROHGLFDJAHR</property>
<property name="nativeName">ROHGLFDJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">ROHGVORJAHR</property>
<property name="nativeName">ROHGVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">ROHGVORVORJAHR</property>
<property name="nativeName">ROHGVORVORJAHR</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">CUSID</property>
<property name="nativeName">CUSID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">CUSNAME1</property>
<property name="nativeName">CUSNAME1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CUSNAME2</property>
<property name="nativeName">CUSNAME2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">BUNID</property>
<property name="nativeName">BUNID</property>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="queryText">Select st.artid, st.NAME1,
st.NAME2, st.PACID as VPK, SUM(st.TURNOVER08) as UmsLfdJahr,
SUM(st.TURNOVER07) as UmsVorjahr, SUM(st.TURNOVER06) as UmsVorvorjahr,
SUM(st.QUANTITY08) as MenLfdJahr, SUM(st.QUANTITY07) as MenVorjahr,
SUM(st.QUANTITY06) as MenVorvorjahr, SUM(st.PROFIT08) as RohgLfdJahr,
SUM(st.PROFIT07) as RohgVorjahr, SUM(st.PROFIT06) as RohgVorvorjahr,
st.cusid, cu.NAME1 as CUSNAME1, cu.NAME2 as CUSNAME2, cu.BUNID from
KINFO.STATST01 st, KINFO.CUSTOMER01 cu where st.cusid = cu.cusid and 'ST'
= cu.BUNID group by st.artid, st.PACID, st.NAME1, st.NAME2,
st.PACID,st.cusid, cu.NAME1, cu.NAME2, cu.BUNID order by st.PACID,
lower(st.NAME1) asc</property>
</oda-data-set>
<oda-data-set extensionID="com.iq.oda.ws.dataSet"
name="WSDB2_BUNID_NAME" id="46">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="rowFetchLimit">0</property>
<property name="dataSource">Debala04</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">NAME</property>
<property name="nativeName">NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="queryText">Select NAME from KINFO.BUSUNTP
where BUNID = 'ST'</property>
</oda-data-set>
</data-sets>
<styles>
<style name="Header" id="435">
<property name="backgroundColor">#FF8040</property>
<property name="fontWeight">bold</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="Font_Number" id="515">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0</property>
</structure>
<structure name="stringFormat">
<property name="category">Unformatted</property>
</structure>
</style>
<style name="Kruse_TableHeader" id="1424">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="color">#165A87</property>
</style>
<style name="Align" id="1465">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">a4</property>
<property name="orientation">landscape</property>
<property name="topMargin">10mm</property>
<property name="leftMargin">20mm</property>
<property name="bottomMargin">10mm</property>
<property name="rightMargin">20mm</property>
<page-header>
<grid id="53">
<property name="marginTop">0%</property>
<property name="marginLeft">0%</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0%</property>
<property name="verticalAlign">middle</property>
<property name="canShrink">false</property>
<property name="height">0%</property>
<property name="width">257mm</property>
<method
name="onPrepare"><![CDATA[if(reportContext.getOutputFormat()== "html")
{
this.getStyle().marginTop = "1%";
this.getStyle().textAlign = "center";
}]]></method>
<column id="54">
<property name="width">30%</property>
</column>
<column id="55">
<property name="width">40%</property>
</column>
<column id="56">
<property name="width">30%</property>
</column>
<row id="57">
<property name="height">0.4166666667in</property>
<property name="backgroundColor">#FFFFFF</property>
<cell id="58">
<property
name="borderBottomColor">#165A87</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">4pt</property>
<property name="textAlign">left</property>
<image id="1113">
<property name="source">embed</property>
<property name="imageName">K.png</property>
</image>
</cell>
<cell id="59">
<property
name="borderBottomColor">#165A87</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property name="paddingTop">4pt</property>
<property name="paddingBottom">4pt</property>
<property name="textAlign">center</property>
<text id="514">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">14pt</property>
<property name="fontWeight">bold</property>
<property
name="textAlign">center</property>
<property
name="contentType">html</property>
<text-property
name="content"><![CDATA[Jahreswerte Kunden ]]></text-property>
</text>
</cell>
<cell id="60">
<property
name="borderBottomColor">#165A87</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property name="paddingTop">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">right</property>
</cell>
</row>
<row id="1475">
<property name="backgroundColor">#FFFFFF</property>
<cell id="1476">
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="textAlign">left</property>
</cell>
<cell id="1477">
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="textAlign">left</property>
</cell>
<cell id="1478">
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="textAlign">left</property>
<text id="1076">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="marginTop">0mm</property>
<property name="marginLeft">0pt</property>
<property
name="marginBottom">0mm</property>
<property name="textAlign">right</property>
<property
name="contentType">html</property>
<text-property
name="content"><![CDATA[Geschäftsbereich]]></text-property >
</text>
<data id="930">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<property name="marginTop">9px</property>
<property name="marginLeft">0pt</property>
<property
name="marginBottom">0mm</property>
<property name="textAlign">right</property>
<property
name="dataSet">WSDB2_BUNID_NAME</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">NAME</property>
<expression
name="expression">dataSetRow["NAME"]</expression>
<property
name="dataType">string</property>
</structure>
</list-property>
<property
name="resultSetColumn">NAME</property>
</data>
</cell>
</row>
<row id="1111">
<property name="backgroundColor">#FFFFFF</property>
<cell id="1112">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property
name="borderTopColor">#165A87</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="textAlign">left</property>
<text id="1110">
<property
name="contentType">auto</property>
<text-property name="content"><![CDATA[
]]></text-property>
</text>
</cell>
</row>
</grid>
</page-header>
<page-footer>
<grid id="494">
<property name="marginLeft">0%</property>
<property name="marginRight">0%</property>
<property name="width">257mm</property>
<method
name="onPrepare"><![CDATA[if(reportContext.getOutputFormat() == "html")
{
this.getStyle().textAlign = "center";
}]]></method>
<column id="1095">
<property name="width">40%</property>
</column>
<column id="495">
<property name="width">7.5%</property>
</column>
<column id="496">
<property name="width">5%</property>
</column>
<column id="497">
<property name="width">7.5%</property>
</column>
<column id="1097">
<property name="width">40%</property>
</column>
<row id="1098">
<list-property name="visibility">
<structure>
<property name="format">html</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<cell id="1099">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<property
name="borderTopColor">#165A87</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="1104">
<property
name="contentType">auto</property>
<text-property name="content"><![CDATA[
]]></text-property>
</text>
</cell>
</row>
<row id="1479">
<list-property name="visibility">
<structure>
<property name="format">pdf</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<cell id="1480"/>
<cell id="1481"/>
<cell id="1482"/>
<cell id="1483"/>
<cell id="1484"/>
</row>
<row id="498">
<cell id="1094">
<text id="1105">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<method
name="onCreate"><![CDATA[if(reportContext.getOutputFormat() == "html")
{
this.getStyle().textAlign = "left";
}]]></method>
<property
name="contentType">html</property>
<text-property
name="content"><![CDATA[Ersteller: <VALUE-OF>var datum = new Date();
//Uhrzeit
var stunden = "00" + datum.getHours();
stunden = stunden.substr(stunden.length-2, 2);
var minuten = "00" + datum.getMinutes();
minuten = minuten.substr(minuten.length-2, 2);
var sekunden = "00" + datum.getSeconds();
sekunden = sekunden.substr(sekunden.length-2, 2);
var uhrzeit = stunden+":"+minuten+":"+sekunden;
//Datum
var tag = "00" + datum.getDate();
tag = tag.substr(tag.length-2, 2);
var monat = "00" + (datum.getMonth()+1);
monat = monat.substr(monat.length-2, 2);
var jahr = "00" + datum.getFullYear();
jahr = jahr.substr(jahr.length-4, 4);
var date = tag+"."+monat+"."+jahr;
//Zusammenbauen
params["username"] + " " + date + " " +
uhrzeit;</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="499">
<auto-text id="500">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property
name="format">html</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<property
name="type">page-number</property>
</auto-text>
</cell>
<cell id="501">
<text id="502">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<property
name="textAlign">center</property>
<list-property name="visibility">
<structure>
<property
name="format">html</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<property
name="contentType">plain</property>
<text-property
name="content"><![CDATA[/]]></text-property>
</text>
</cell>
<cell id="503">
<auto-text id="504">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<list-property name="visibility">
<structure>
<property
name="format">html</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<property name="type">total-page</property>
</auto-text>
</cell>
<cell id="1096">
<text id="1546">
<property
name="fontFamily">"Arial"</property>
<property name="fontSize">9pt</property>
<property name="textAlign">right</property>
<property
name="dataSet">WSDB2_StatData_QuantityPerYear</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">ARTID</property>
<expression
name="expression">dataSetRow["ARTID"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">NAME1</property>
<expression
name="expression">dataSetRow["NAME1"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">NAME2</property>
<expression
name="expression">dataSetRow["NAME2"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">VPK</property>
<expression
name="expression">dataSetRow["VPK"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">UMSLFDJAHR</property>
<expression
name="expression">dataSetRow["UMSLFDJAHR"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">UMSVORJAHR</property>
<expression
name="expression">dataSetRow["UMSVORJAHR"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">UMSVORVORJAHR</property>
<expression
name="expression">dataSetRow["UMSVORVORJAHR"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">MENLFDJAHR</property>
<expression
name="expression">dataSetRow["MENLFDJAHR"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">MENVORJAHR</property>
<expression
name="expression">dataSetRow["MENVORJAHR"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">MENVORVORJAHR</property>
<expression
name="expression">dataSetRow["MENVORVORJAHR"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">ROHGLFDJAHR</property>
<expression
name="expression">dataSetRow["ROHGLFDJAHR"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">ROHGVORJAHR</property>
<expression
name="expression">dataSetRow["ROHGVORJAHR"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">ROHGVORVORJAHR</property>
<expression
name="expression">dataSetRow["ROHGVORVORJAHR"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CUSID</property>
<expression
name="expression">dataSetRow["CUSID"]</expression>
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CUSNAME1</property>
<expression
name="expression">dataSetRow["CUSNAME1"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSNAME2</property>
<expression
name="expression">dataSetRow["CUSNAME2"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">BUNID</property>
<expression
name="expression">dataSetRow["BUNID"]</expression>
<property
name="dataType">string</property>
</structure>
</list-property>
<property
name="contentType">html</property>
<text-property
name="content"><![CDATA[Reportversion: 1.05 /
<VALUE-OF>(Total.count(dataSetRow["CUSID"])).toString() + "
Datensätze"</VALUE-OF> ]]></text-property>
</text>
</cell>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="1180">
<property name="style">Font_Number</property>
<property name="width">257mm</property>
<property
name="dataSet">WSDB2_StatData_QuantityPerYear</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSNAME1</property>
<expression
name="expression">dataSetRow["CUSNAME1"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUSNAME2</property>
<expression
name="expression">dataSetRow["CUSNAME2"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUSID</property>
<expression name="expression">"Kdnr.
"+dataSetRow["CUSID"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">NAME1</property>
<expression
name="expression">dataSetRow["NAME1"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">NAME2</property>
<expression
name="expression">dataSetRow["NAME2"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">VPK</property>
<expression
name="expression">dataSetRow["VPK"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">UMSLFDJAHR</property>
<expression
name="expression">dataSetRow["UMSLFDJAHR"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">UMSVORJAHR</property>
<expression
name="expression">dataSetRow["UMSVORJAHR"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">UMSVORVORJAHR</property>
<expression
name="expression">dataSetRow["UMSVORVORJAHR"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">MENLFDJAHR</property>
<expression
name="expression">dataSetRow["MENLFDJAHR"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">MENVORJAHR</property>
<expression
name="expression">dataSetRow["MENVORJAHR"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">MENVORVORJAHR</property>
<expression
name="expression">dataSetRow["MENVORVORJAHR"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ROHGLFDJAHR</property>
<expression
name="expression">dataSetRow["ROHGLFDJAHR"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ROHGVORJAHR</property>
<expression
name="expression">dataSetRow["ROHGVORJAHR"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ROHGVORVORJAHR</property>
<expression
name="expression">dataSetRow["ROHGVORVORJAHR"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">to</property>
<expression
name="expression">Total.sum(row["UMSLFDJAHR"], null, 1)</expression>
<property name="dataType">integer</property>
<property name="aggregateOn">Customer</property>
</structure>
<structure>
<property name="name">TotalUmsVorJahr</property>
<expression
name="expression">Total.sum(row["UMSVORJAHR"])</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">TotalUmsVorvorjahr</property>
<expression
name="expression">Total.sum(row["UMSVORVORJAHR"])</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">to4</property>
<expression
name="expression">Total.sum(row["MENLFDJAHR"], null, 1)</expression>
<property name="dataType">integer</property>
<property name="aggregateOn">Customer</property>
</structure>
<structure>
<property name="name">TotalMenVorJahr</property>
<expression
name="expression">Total.sum(row["MENVORJAHR"])</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">TotalMenVorvorJahr</property>
<expression
name="expression">Tot

Report message to a moderator

Re: PDF - Generation Time... [message #368135 is a reply to message #368130] Tue, 05 May 2009 16:14 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Patrick,

I did not see anything in the report that would cause performance
issues. What ODA are you using and how long does it take to get the
data? Also can you make a copy of the report and drop the table footer
to see the amount of time it takes?

Jason

Patrick wrote:
> Here it comes...
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.7"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build
> &lt;20051130-1157></property>
> <property name="units">mm</property>
> <property name="comments">Copyright (c) 2006 &lt;&lt;Your Company
> Name here>></property>
> <list-property name="propertyBindings">
> <structure>
> <property name="name">queryText</property>
> <property name="id">42</property>
> <expression name="value">"Select st.cusid, cu.NAME1 as
> CusName1, cu.NAME2 as CusName2, st.artid, st.PACID as VPK, st.NAME1,
> st.NAME2, cu.bunid, SUM(st.TURNOVER08) as UmsLfdJahr, SUM(st.TURNOVER07)
> as UmsVorjahr, SUM(st.TURNOVER06) as UmsVorvorjahr,SUM(st.QUANTITY08) as
> MenLfdJahr, SUM(st.QUANTITY07) as MenVorjahr, SUM(st.QUANTITY06) as
> MenVorvorjahr,SUM(st.PROFIT08) as RohgLfdJahr, SUM(st.PROFIT07) as
> RohgVorjahr, SUM(st.PROFIT06) as RohgVorvorjahr from
> KINFO.STAT"+params["bunId"]+"01 st, KINFO.CUSTOMER01 cu where cu.bunid =
> '"+params["bunId"]+"' and st.cusid = cu.cusid group by cu.bunid,
> st.CUSID, cu.NAME1, cu.NAME2, st.artid, st.PACID, st.NAME1, st.NAME2
> order by cu.NAME1, st.NAME1 asc, st.NAME2 asc, st.PACID asc"</expression>
> </structure>
> <structure>
> <property name="name">queryText</property>
> <property name="id">46</property>
> <expression name="value">"Select NAME from KINFO.BUSUNTP
> where BUNID = '"+params["bunId"]+"'"</expression>
> </structure>
> </list-property>
> <parameters>
> <scalar-parameter name="bunId" id="45">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">ST</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="username" id="505">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">Max Mustermann</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="DatenVorhanden" id="979">
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">1</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source extensionID="com.iq.oda.ws" name="Debala04"
> id="41"/>
> </data-sources>
> <data-sets>
> <oda-data-set extensionID="com.iq.oda.ws.dataSet"
> name="WSDB2_StatData_QuantityPerYear" id="42">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ARTID</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">NAME1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">NAME2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">VPK</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">UMSLFDJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">UMSVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">UMSVORVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">MENLFDJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">MENVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">MENVORVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">ROHGLFDJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">ROHGVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">ROHGVORVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">CUSID</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">CUSNAME1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">CUSNAME2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">BUNID</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="rowFetchLimit">0</property>
> <property name="dataSource">Debala04</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ARTID</property>
> <property name="nativeName">ARTID</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">NAME1</property>
> <property name="nativeName">NAME1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">NAME2</property>
> <property name="nativeName">NAME2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">VPK</property>
> <property name="nativeName">VPK</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">UMSLFDJAHR</property>
> <property name="nativeName">UMSLFDJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">UMSVORJAHR</property>
> <property name="nativeName">UMSVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">UMSVORVORJAHR</property>
> <property name="nativeName">UMSVORVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">MENLFDJAHR</property>
> <property name="nativeName">MENLFDJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">MENVORJAHR</property>
> <property name="nativeName">MENVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">MENVORVORJAHR</property>
> <property name="nativeName">MENVORVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">ROHGLFDJAHR</property>
> <property name="nativeName">ROHGLFDJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">ROHGVORJAHR</property>
> <property name="nativeName">ROHGVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">ROHGVORVORJAHR</property>
> <property name="nativeName">ROHGVORVORJAHR</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">CUSID</property>
> <property name="nativeName">CUSID</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">CUSNAME1</property>
> <property name="nativeName">CUSNAME1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">CUSNAME2</property>
> <property name="nativeName">CUSNAME2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">BUNID</property>
> <property name="nativeName">BUNID</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <property name="queryText">Select st.artid, st.NAME1,
> st.NAME2, st.PACID as VPK, SUM(st.TURNOVER08) as UmsLfdJahr,
> SUM(st.TURNOVER07) as UmsVorjahr, SUM(st.TURNOVER06) as UmsVorvorjahr,
> SUM(st.QUANTITY08) as MenLfdJahr, SUM(st.QUANTITY07) as MenVorjahr,
> SUM(st.QUANTITY06) as MenVorvorjahr, SUM(st.PROFIT08) as RohgLfdJahr,
> SUM(st.PROFIT07) as RohgVorjahr, SUM(st.PROFIT06) as RohgVorvorjahr,
> st.cusid, cu.NAME1 as CUSNAME1, cu.NAME2 as CUSNAME2, cu.BUNID from
> KINFO.STATST01 st, KINFO.CUSTOMER01 cu where st.cusid = cu.cusid and
> 'ST' = cu.BUNID group by st.artid, st.PACID, st.NAME1, st.NAME2,
> st.PACID,st.cusid, cu.NAME1, cu.NAME2, cu.BUNID order by st.PACID,
> lower(st.NAME1) asc</property>
> </oda-data-set>
> <oda-data-set extensionID="com.iq.oda.ws.dataSet"
> name="WSDB2_BUNID_NAME" id="46">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">NAME</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="rowFetchLimit">0</property>
> <property name="dataSource">Debala04</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">NAME</property>
> <property name="nativeName">NAME</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <property name="queryText">Select NAME from KINFO.BUSUNTP
> where BUNID = 'ST'</property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="Header" id="435">
> <property name="backgroundColor">#FF8040</property>
> <property name="fontWeight">bold</property>
> <property name="borderBottomStyle">none</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopStyle">none</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="Font_Number" id="515">
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <structure name="numberFormat">
> <property name="category">Currency</property>
> <property name="pattern">#,##0</property>
> </structure>
> <structure name="stringFormat">
> <property name="category">Unformatted</property>
> </structure>
> </style>
> <style name="Kruse_TableHeader" id="1424">
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="color">#165A87</property>
> </style>
> <style name="Align" id="1465">
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="type">a4</property>
> <property name="orientation">landscape</property>
> <property name="topMargin">10mm</property>
> <property name="leftMargin">20mm</property>
> <property name="bottomMargin">10mm</property>
> <property name="rightMargin">20mm</property>
> <page-header>
> <grid id="53">
> <property name="marginTop">0%</property>
> <property name="marginLeft">0%</property>
> <property name="marginBottom">0pt</property>
> <property name="marginRight">0%</property>
> <property name="verticalAlign">middle</property>
> <property name="canShrink">false</property>
> <property name="height">0%</property>
> <property name="width">257mm</property>
> <method
> name="onPrepare"><![CDATA[if(reportContext.getOutputFormat()== "html")
> {
> this.getStyle().marginTop = "1%";
> this.getStyle().textAlign = "center";
> }]]></method>
> <column id="54">
> <property name="width">30%</property>
> </column>
> <column id="55">
> <property name="width">40%</property>
> </column>
> <column id="56">
> <property name="width">30%</property>
> </column>
> <row id="57">
> <property name="height">0.4166666667in</property>
> <property name="backgroundColor">#FFFFFF</property>
> <cell id="58">
> <property
> name="borderBottomColor">#165A87</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">4pt</property>
> <property name="textAlign">left</property>
> <image id="1113">
> <property name="source">embed</property>
> <property name="imageName">K.png</property>
> </image>
> </cell>
> <cell id="59">
> <property
> name="borderBottomColor">#165A87</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property name="paddingTop">4pt</property>
> <property name="paddingBottom">4pt</property>
> <property name="textAlign">center</property>
> <text id="514">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">14pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <property name="contentType">html</property>
> <text-property
> name="content"><![CDATA[Jahreswerte Kunden ]]></text-property>
> </text>
> </cell>
> <cell id="60">
> <property
> name="borderBottomColor">#165A87</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> <property name="textAlign">right</property>
> </cell>
> </row>
> <row id="1475">
> <property name="backgroundColor">#FFFFFF</property>
> <cell id="1476">
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="textAlign">left</property>
> </cell>
> <cell id="1477">
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="textAlign">left</property>
> </cell>
> <cell id="1478">
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="textAlign">left</property>
> <text id="1076">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="marginTop">0mm</property>
> <property name="marginLeft">0pt</property>
> <property name="marginBottom">0mm</property>
> <property name="textAlign">right</property>
> <property name="contentType">html</property>
> <text-property
> name="content"><![CDATA[Geschäftsbereich]]></text-property >
> </text>
> <data id="930">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <property name="marginTop">9px</property>
> <property name="marginLeft">0pt</property>
> <property name="marginBottom">0mm</property>
> <property name="textAlign">right</property>
> <property
> name="dataSet">WSDB2_BUNID_NAME</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">NAME</property>
> <expression
> name="expression">dataSetRow["NAME"]</expression>
> <property
> name="dataType">string</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">NAME</property>
> </data>
> </cell>
> </row>
> <row id="1111">
> <property name="backgroundColor">#FFFFFF</property>
> <cell id="1112">
> <property name="colSpan">3</property>
> <property name="rowSpan">1</property>
> <property
> name="borderTopColor">#165A87</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="textAlign">left</property>
> <text id="1110">
> <property name="contentType">auto</property>
> <text-property name="content"><![CDATA[
> ]]></text-property>
> </text>
> </cell>
> </row>
> </grid>
> </page-header>
> <page-footer>
> <grid id="494">
> <property name="marginLeft">0%</property>
> <property name="marginRight">0%</property>
> <property name="width">257mm</property>
> <method
> name="onPrepare"><![CDATA[if(reportContext.getOutputFormat() == "html")
> {
> this.getStyle().textAlign = "center";
> }]]></method>
> <column id="1095">
> <property name="width">40%</property>
> </column>
> <column id="495">
> <property name="width">7.5%</property>
> </column>
> <column id="496">
> <property name="width">5%</property>
> </column>
> <column id="497">
> <property name="width">7.5%</property>
> </column>
> <column id="1097">
> <property name="width">40%</property>
> </column>
> <row id="1098">
> <list-property name="visibility">
> <structure>
> <property name="format">html</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <cell id="1099">
> <property name="colSpan">5</property>
> <property name="rowSpan">1</property>
> <property
> name="borderTopColor">#165A87</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="1104">
> <property name="contentType">auto</property>
> <text-property name="content"><![CDATA[
> ]]></text-property>
> </text>
> </cell>
> </row>
> <row id="1479">
> <list-property name="visibility">
> <structure>
> <property name="format">pdf</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <cell id="1480"/>
> <cell id="1481"/>
> <cell id="1482"/>
> <cell id="1483"/>
> <cell id="1484"/>
> </row>
> <row id="498">
> <cell id="1094">
> <text id="1105">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <method
> name="onCreate"><![CDATA[if(reportContext.getOutputFormat() == "html")
> {
> this.getStyle().textAlign = "left";
> }]]></method>
> <property name="contentType">html</property>
> <text-property
> name="content"><![CDATA[Ersteller: <VALUE-OF>var datum = new Date();
> //Uhrzeit
> var stunden = "00" + datum.getHours();
> stunden = stunden.substr(stunden.length-2, 2);
> var minuten = "00" + datum.getMinutes();
> minuten = minuten.substr(minuten.length-2, 2);
> var sekunden = "00" + datum.getSeconds();
> sekunden = sekunden.substr(sekunden.length-2, 2);
> var uhrzeit = stunden+":"+minuten+":"+sekunden;
> //Datum
> var tag = "00" + datum.getDate();
> tag = tag.substr(tag.length-2, 2);
> var monat = "00" + (datum.getMonth()+1);
> monat = monat.substr(monat.length-2, 2);
> var jahr = "00" + datum.getFullYear();
> jahr = jahr.substr(jahr.length-4, 4);
> var date = tag+"."+monat+"."+jahr;
> //Zusammenbauen
> params["username"] + " " + date + " " +
> uhrzeit;</VALUE-OF>]]></text-property>
> </text>
> </cell>
> <cell id="499">
> <auto-text id="500">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <property name="textAlign">right</property>
> <list-property name="visibility">
> <structure>
> <property
> name="format">html</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <property name="type">page-number</property>
> </auto-text>
> </cell>
> <cell id="501">
> <text id="502">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <list-property name="visibility">
> <structure>
> <property
> name="format">html</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <property
> name="contentType">plain</property>
> <text-property
> name="content"><![CDATA[/]]></text-property>
> </text>
> </cell>
> <cell id="503">
> <auto-text id="504">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <list-property name="visibility">
> <structure>
> <property
> name="format">html</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <property name="type">total-page</property>
> </auto-text>
> </cell>
> <cell id="1096">
> <text id="1546">
> <property
> name="fontFamily">"Arial"</property>
> <property name="fontSize">9pt</property>
> <property name="textAlign">right</property>
> <property
> name="dataSet">WSDB2_StatData_QuantityPerYear</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">ARTID</property>
> <expression
> name="expression">dataSetRow["ARTID"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">NAME1</property>
> <expression
> name="expression">dataSetRow["NAME1"]</expression>
> <property
> name="dataType">string</property>
> </structure>
> <structure>
> <property
> name="name">NAME2</property>
> <expression
> name="expression">dataSetRow["NAME2"]</expression>
> <property
> name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">VPK</property>
> <expression
> name="expression">dataSetRow["VPK"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">UMSLFDJAHR</property>
> <expression
> name="expression">dataSetRow["UMSLFDJAHR"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">UMSVORJAHR</property>
> <expression
> name="expression">dataSetRow["UMSVORJAHR"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">UMSVORVORJAHR</property>
> <expression
> name="expression">dataSetRow["UMSVORVORJAHR"]</expression >
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">MENLFDJAHR</property>
> <expression
> name="expression">dataSetRow["MENLFDJAHR"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">MENVORJAHR</property>
> <expression
> name="expression">dataSetRow["MENVORJAHR"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">MENVORVORJAHR</property>
> <expression
> name="expression">dataSetRow["MENVORVORJAHR"]</expression >
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">ROHGLFDJAHR</property>
> <expression
> name="expression">dataSetRow["ROHGLFDJAHR"]</expression >
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">ROHGVORJAHR</property>
> <expression
> name="expression">dataSetRow["ROHGVORJAHR"]</expression >
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">ROHGVORVORJAHR</property>
> <expression
> name="expression">dataSetRow["ROHGVORVORJAHR"]</expression >
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">CUSID</property>
> <expression
> name="expression">dataSetRow["CUSID"]</expression>
> <property
> name="dataType">integer</property>
> </structure>
> <structure>
> <property
> name="name">CUSNAME1</property>
> <expression
> name="expression">dataSetRow["CUSNAME1"]</expression>
> <property
> name="dataType">string</property>
> </structure>
> <structure>
> <property
> name="name">CUSNAME2</property>
> <expression
> name="expression">dataSetRow["CUSNAME2"]</expression>
> <property
> name="dataType">string</property>
> </structure>
> <structure>
> <property
> name="name">BUNID</property>
> <expression
> name="expression">dataSetRow["BUNID"]</expression>
> <property
> name="dataType">string</property>
> </structure>
> </list-property>
> <property name="contentType">html</property>
> <text-property
> name="content"><![CDATA[Reportversion: 1.05 /
> <VALUE-OF>(Total.count(dataSetRow["CUSID"])).toString() + "
> Datensätze"</VALUE-OF> ]]></text-property>
> </text>
> </cell>
> </row>
> </grid>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="1180">
> <property name="style">Font_Number</property>
> <property name="width">257mm</property>
> <property
> name="dataSet">WSDB2_StatData_QuantityPerYear</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSNAME1</property>
> <expression
> name="expression">dataSetRow["CUSNAME1"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CUSNAME2</property>
> <expression
> name="expression">dataSetRow["CUSNAME2"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CUSID</property>
> <expression name="expression">"Kdnr.
> "+dataSetRow["CUSID"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">NAME1</property>
> <expression
> name="expression">dataSetRow["NAME1"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">NAME2</property>
> <expression
> name="expression">dataSetRow["NAME2"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">VPK</property>
> <expression
> name="expression">dataSetRow["VPK"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">UMSLFDJAHR</property>
> <expression
> name="expression">dataSetRow["UMSLFDJAHR"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">UMSVORJAHR</property>
> <expression
> name="expression">dataSetRow["UMSVORJAHR"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">UMSVORVORJAHR</property>
> <expression
> name="expression">dataSetRow["UMSVORVORJAHR"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">MENLFDJAHR</property>
> <expression
> name="expression">dataSetRow["MENLFDJAHR"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">MENVORJAHR</property>
> <expression
> name="expression">dataSetRow["MENVORJAHR"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">MENVORVORJAHR</property>
>

Report message to a moderator

Re: PDF - Generation Time... [message #368206 is a reply to message #368135] Tue, 12 May 2009 10:45 Go to previous messageGo to next message
Patrick is currently offline PatrickFriend
Messages: 48
Registered: July 2009
Member
Hello! :-)
Removing the table - footer didn't improve the performance. The colleague
responsible for the oda data source is out of office so i'cant get any
infomation from him at the moment.

However i discovered something else. I tried to log the excution of
various methods during the report creation.

importPackage(Packages.java.io);
fos = new java.io.FileOutputStream("c:\\logging\\logFile3.txt");
pw = new java.io.PrintWriter(fos);
var d = new Date();
var h = d.getHours();
var m = d.getMinutes();
var s = d.getSeconds();
pw.println("initialize " + h+"."+m+"."+s);

It seems that all the DataSet - Methods from one DataSet are all called
twice. The onFetch-Method is called even more. Is that normal behaviour?
If not, what cut possibly cause this?
My log-File (10 Preview - Rows)
-"Methodname" + this.name + Hours.Minutes.Seconds
-WSDB2_StatData_QuantityPerYear is the DataSet - Name?


initialize 12.20.37
beforeOpen WSDB2_StatData_QuantityPerYear 12.20.37
afterOpen 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
beforeOpen WSDB2_StatData_QuantityPerYear 12.20.47
afterOpen 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
onFetch WSDB2_StatData_QuantityPerYear 12.20.47
beforeClose 12.20.47
afterClose 12.20.47
beforeClose 12.20.47
afterClose 12.20.47

Report message to a moderator

Re: PDF - Generation Time... [message #368211 is a reply to message #368206] Tue, 12 May 2009 15:32 Go to previous message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Patrick,

I believe this has been corrected since 2.1.3. I am using 2.3.2 and
this issue is not there.

Jason

Patrick wrote:
> Hello! :-)
> Removing the table - footer didn't improve the performance. The
> colleague responsible for the oda data source is out of office so i'cant
> get any infomation from him at the moment.
> However i discovered something else. I tried to log the excution of
> various methods during the report creation.
> importPackage(Packages.java.io);
> fos = new java.io.FileOutputStream("c:\\logging\\logFile3.txt");
> pw = new java.io.PrintWriter(fos);
> var d = new Date();
> var h = d.getHours();
> var m = d.getMinutes();
> var s = d.getSeconds();
> pw.println("initialize " + h+"."+m+"."+s);
>
> It seems that all the DataSet - Methods from one DataSet are all called
> twice. The onFetch-Method is called even more. Is that normal behaviour?
> If not, what cut possibly cause this? My log-File (10 Preview - Rows)
> -"Methodname" + this.name + Hours.Minutes.Seconds
> -WSDB2_StatData_QuantityPerYear is the DataSet - Name?
>
>
> initialize 12.20.37
> beforeOpen WSDB2_StatData_QuantityPerYear 12.20.37
> afterOpen 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> beforeOpen WSDB2_StatData_QuantityPerYear 12.20.47
> afterOpen 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> onFetch WSDB2_StatData_QuantityPerYear 12.20.47
> beforeClose 12.20.47
> afterClose 12.20.47
> beforeClose 12.20.47
> afterClose 12.20.47
>
>
>
>

Report message to a moderator

Previous Topic:Dynamic default values?
Next Topic:Do not prompt parameter input
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 06:18:03 GMT 2024

Powered by FUDForum. Page generated in 0.04189 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly