Home » Archived » BIRT » "Total" is not defined
| "Total" is not defined [message #234861] |
Mon, 16 April 2007 14:11  |
Eclipse User |
|
|
|
Originally posted by: arndt.schoenberg.freenet.de
I've big problems with a report with computed values in the table-footer.
Some of the cell are computed coorectly - other create the error "Total"
is not defined. Even if I use the SAME formular in 2 databindings one
works fine and the other dont. I attach the reportdefinition - e.g.
binding "amount365DSumP" dont work. Binding "amount180DSumP" work fine.
Thank you for help
Arndt
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.2</property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007
schönberg-solutions</property>
<list-property name="propertyBindings">
<structure>
<property name="name">odaDriverClass</property>
<property name="id">5</property>
</structure>
<structure>
<property name="name">odaURL</property>
<property name="id">5</property>
<expression name="value">params["Connectstring"]</expression>
</structure>
<structure>
<property name="name">odaUser</property>
<property name="id">5</property>
</structure>
<structure>
<property name="name">odaPassword</property>
<property name="id">5</property>
</structure>
<structure>
<property name="name">odaJndiName</property>
<property name="id">5</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="Connectstring" id="4">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<property
name="defaultValue">jdbc:postgresql://127.0.0.1:5432/erp</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Application" id="8">
<property name="valueType">static</property>
<property name="dataType">integer</property>
<property name="allowNull">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Variation" id="9">
<property name="valueType">static</property>
<property name="dataType">integer</property>
<property name="allowNull">false</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="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="5">
<property
name="odaDriverClass">org.postgresql.Driver</property>
<property
name="odaURL">jdbc:postgresql://127.0.0.1:5432/erp</property>
<property name="odaUser">postgres</property>
<encrypted-property
name="odaPassword">cXdlcnR5Mjk=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="BillNotPaied" id="430">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">custid</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">billdate</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">customer</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property
name="name">amountpriceafterskonto</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">param6</property>
<property name="paramName">Application</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param7</property>
<property name="paramName">Variation</property>
<property name="dataType">integer</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">custid</property>
<property name="nativeName">custid</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">billdate</property>
<property name="nativeName">billdate</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">customer</property>
<property name="nativeName">customer</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">amountpriceafterskonto</property>
<property
name="nativeName">amountpriceafterskonto</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
</list-property>
<property name="queryText">select custid, billdate,
cust_masterdata.company || ', ' || cust_masterdata.city as customer,
amountpriceafterskonto
from view_billing
JOIN cust_masterdata
ON cust_masterdata.appliid = view_billing.appliid
AND cust_masterdata.variation = view_billing.variation
AND cust_masterdata.id = view_billing.custid
WHERE view_billing.appliid = ?
AND view_billing.variation = ?
AND not view_billing.billdate is null
AND view_billing.paied <> 'J' AND view_billing.expensed <> 'J'
ORDER BY customer ASC
</property>
</oda-data-set>
</data-sets>
<styles>
<style name="BorderTopBottom" id="129">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="Currency" id="169">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0.00â¬</property>
</structure>
<property name="textAlign">right</property>
</style>
<style name="page" id="248">
<property name="fontFamily">"Arial"</property>
</style>
<style name="ArticleRow" id="297">
<property name="marginTop">10pt</property>
<property name="marginBottom">0pt</property>
</style>
<style name="HedareIntern" id="348">
<property name="backgroundColor">#C0C0C0</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">x-large</property>
<property name="textAlign">center</property>
</style>
<style name="TableHeader" id="390">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
</style>
<style name="SubHeader" id="465">
<property name="fontSize">larger</property>
<property name="fontWeight">bolder</property>
<property name="textAlign">center</property>
<property name="verticalAlign">middle</property>
</style>
<style name="Percent" id="652">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">#,##0.00%</property>
</structure>
<property name="textAlign">center</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">1cm</property>
<property name="leftMargin">1cm</property>
<property name="bottomMargin">1cm</property>
<property name="rightMargin">1cm</property>
<page-footer>
<text id="391">
<property name="style">page</property>
<property name="marginTop">11pt</property>
<property name="textAlign">center</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Seite
<value-of>pageNumber</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<text id="426">
<property name="style">HedareIntern</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Altersstruktur der
Debitoren-OPs vom <value-of format="dd.MM.yyyy">new
Date()</value-of>]]></text-property>
</text>
<table id="392">
<property name="style">page</property>
<property name="fontSize">small</property>
<property name="marginTop">10pt</property>
<property name="width">100%</property>
<property name="dataSet">BillNotPaied</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">custid</property>
<expression
name="expression">dataSetRow["custid"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">billdate</property>
<expression
name="expression">dataSetRow["billdate"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">customer</property>
<expression
name="expression">dataSetRow["customer"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">amountpriceafterskonto</property>
<expression
name="expression">dataSetRow["amountpriceafterskonto"]</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">gesamt</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"], null,
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount30D</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
0)), (DateTimeSpan.subDate(new Date(), 0, 0, 30))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount60D</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
31)), (DateTimeSpan.subDate(new Date(), 0, 0, 60))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount90D</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
61)), (DateTimeSpan.subDate(new Date(), 0, 0, 90))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount180D</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
91)), (DateTimeSpan.subDate(new Date(), 0, 0, 180))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount365D</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
181)), (DateTimeSpan.subDate(new Date(), 0, 0, 365))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount2Y</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
365)), (DateTimeSpan.subDate(new Date(), 0, 0, 730))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amountg2Y</property>
<expression
name="expression">Total.sum(row["amountpriceafterskonto"],
BirtComp.lessThan(row["billdate"], (DateTimeSpan.subDate(new Date(), 0, 0,
730))),
'customergroup')</expression>
<property name="dataType">decimal</property>
<property name="aggregateOn">customergroup</property>
</structure>
<structure>
<property name="name">amount30DP</property>
<expression name="expression">row["amount30D"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount60DP</property>
<expression name="expression">row["amount60D"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount90DP</property>
<expression name="expression">row["amount90D"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount180DP</property>
<expression name="expression">row["amount180D"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount365DP</property>
<expression name="expression">row["amount365D"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount2YP</property>
<expression name="expression">row["amount2Y"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amountg2Yp</property>
<expression name="expression">row["amountg2Y"]
/row["gesamt"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">gesamtSum</property>
<expression
name="expression">Total.sum(row["gesamt"])</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount30DSum</property>
<expression
name="expression">Total.sum(row["amount30D"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount60DSum</property>
<expression
name="expression">Total.sum(row["amount60D"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount90DSum</property>
<expression
name="expression">Total.sum(row["amount90D"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount180DSum</property>
<expression
name="expression">Total.sum(row["amount180D"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount365DSum</property>
<expression
name="expression">Total.sum(row["amount365D"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount2YSum</property>
<expression
name="expression">Total.sum(row["amount2Y"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amountg2YSum</property>
<expression
name="expression">Total.sum(row["amountg2Y"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount30DSumP</property>
<expression
name="expression">row["amount30DSum"]/row["gesamtSum"] </expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount60DSumP</property>
<expression
name="expression">row["amount60DSum"]/row["gesamtSum"] </expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount90DSumP</property>
<expression
name="expression">row["amount90DSum"]/row["gesamtSum"] </expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount180DSumP</property>
<expression
name="expression">row["amount180DSum"]/row["gesamtSum"] </expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount365DSumP</property>
<expression
name="expression">row["amount180DSum"]/row["gesamtSum"] </expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">amount2YSumP</property>
<expression
name="expression">row["amount2YSum"]/12</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">amountg2YSumP</property>
<expression
name="expression">Total.sum(dataSetRow["amountpriceafterskonto "])</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<column id="560">
<property name="width">8%</property>
</column>
<column id="411">
<property name="width">34%</property>
</column>
<column id="487">
<property name="width">10%</property>
</column>
<column id="540">
<property name="width">10%</property>
</column>
<column id="565">
<property name="width">10%</property>
</column>
<column id="584">
<property name="width">10%</property>
</column>
<column id="592">
<property name="width">10%</property>
</column>
<column id="588">
<property name="width">10%</property>
</column>
<column id="600">
<property name="width">10%</property>
</column>
<column id="413">
<property name="width">10%</property>
</column>
<header>
<row id="393">
<cell id="557">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="561">
<property name="style">TableHeader</property>
<text-property name="text">Nr.</text-property>
</label>
</cell>
<cell id="394">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="416">
<property name="style">TableHeader</property>
<text-property
name="text">Kunde</text-property>
</label>
</cell>
<cell id="484">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="489">
<property name="style">TableHeader</property>
<text-property name="text">0-30
Tage</text-property>
</label>
</cell>
<cell id="537">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="541">
<property name="style">TableHeader</property>
<text-property name="text">31-60
Tage</text-property>
</label>
</cell>
<cell id="562">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="593">
<property name="style">TableHeader</property>
<text-property name="text">61-90
Tage</text-property>
</label>
</cell>
<cell id="581">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="594">
<property name="style">TableHeader</property>
<text-property name="text">91-180
Tage</text-property>
</label>
</cell>
<cell id="589">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="595">
<property name="style">TableHeader</property>
<text-property name="text">181-365
Tage</text-property>
</label>
</cell>
<cell id="585">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="596">
<property name="style">TableHeader</property>
<text-property name="text">1-2
Jahre</text-property>
</label>
</cell>
<cell id="597">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="601">
<property name="style">TableHeader</property>
<text-property name="text">> 2
Jahre</text-property>
</label>
</cell>
<cell id="396">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<label id="420">
<property name="style">TableHeader</property>
<text-property
name="text">Gesamt</text-property>
</label>
</cell>
</row>
</header>
<group id="605">
<property name="groupName">customergroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["customer"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">true</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<list-property name="filter">
<structure>
<property name="operator">ge</property>
<expression
name="expr">row["billdate"]</expression>
<expression name="value1">DateTimeSpan.subDate(new
Date(), 0, 0, 30)</expression>
</structure>
</list-property>
<header>
<row id="606">
<property name="height">10pt</property>
<cell id="607"/>
<cell id="608"/>
<cell id="609"/>
<cell id="610"/>
<cell id="611"/>
<cell id="612"/>
<cell id="613"/>
<cell id="614"/>
<cell id="615"/>
<cell id="616"/>
</row>
</header>
<footer>
<row id="617">
<cell id="618">
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="628">
<property
name="textAlign">center</property>
<property
name="resultSetColumn">custid</property>
</data>
</cell>
<cell id="619">
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="629">
<property
name="resultSetColumn">customer</property>
</data>
</cell>
<cell id="620">
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="632">
<property name="style">Currency</property>
<property
name="resultSetColumn">amount30D</property>
</data>
</cell>
<cell id="621">
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="634">
<property name="style">Currency</property>
<property
name="resultSetColumn">amount60D</property>
</data>
</cell>
<cell id="622">
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="635">
<property name="style">Currency</property>
<property
name="resultSetColumn">amount90D</property>
</data>
</cell>
<cell id="623">
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTop
|
|
|
| Re: "Total" is not defined [message #235282 is a reply to message #234861] |
Wed, 18 April 2007 11:33  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Arndt,
Which footer row is having the problem?
Jason
Arndt wrote:
> I've big problems with a report with computed values in the
> table-footer. Some of the cell are computed coorectly - other create the
> error "Total" is not defined. Even if I use the SAME formular in 2
> databindings one works fine and the other dont. I attach the
> reportdefinition - e.g. binding "amount365DSumP" dont work. Binding
> "amount180DSumP" work fine.
>
> Thank you for help
>
> Arndt
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Written by Eclipse BIRT 2.0 -->
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.1.2</property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007
> schönberg-solutions</property>
> <list-property name="propertyBindings">
> <structure>
> <property name="name">odaDriverClass</property>
> <property name="id">5</property>
> </structure>
> <structure>
> <property name="name">odaURL</property>
> <property name="id">5</property>
> <expression name="value">params["Connectstring"]</expression>
> </structure>
> <structure>
> <property name="name">odaUser</property>
> <property name="id">5</property>
> </structure>
> <structure>
> <property name="name">odaPassword</property>
> <property name="id">5</property>
> </structure>
> <structure>
> <property name="name">odaJndiName</property>
> <property name="id">5</property>
> </structure>
> </list-property>
> <parameters>
> <scalar-parameter name="Connectstring" id="4">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <property
> name="defaultValue">jdbc:postgresql://127.0.0.1:5432/erp</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Application" id="8">
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="allowNull">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">1</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Variation" id="9">
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="allowNull">false</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="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="5">
> <property name="odaDriverClass">org.postgresql.Driver</property>
> <property
> name="odaURL">jdbc:postgresql://127.0.0.1:5432/erp</property>
> <property name="odaUser">postgres</property>
> <encrypted-property
> name="odaPassword">cXdlcnR5Mjk=</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="BillNotPaied" id="430">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">custid</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">billdate</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">customer</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property
> name="name">amountpriceafterskonto</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">param6</property>
> <property name="paramName">Application</property>
> <property name="dataType">integer</property>
> <property name="position">1</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param7</property>
> <property name="paramName">Variation</property>
> <property name="dataType">integer</property>
> <property name="position">2</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">custid</property>
> <property name="nativeName">custid</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">billdate</property>
> <property name="nativeName">billdate</property>
> <property name="dataType">date-time</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">customer</property>
> <property name="nativeName">customer</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">amountpriceafterskonto</property>
> <property
> name="nativeName">amountpriceafterskonto</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> </list-property>
> <property name="queryText">select custid, billdate,
> cust_masterdata.company || ', ' || cust_masterdata.city as customer,
> amountpriceafterskonto
> from view_billing
> JOIN cust_masterdata ON cust_masterdata.appliid = view_billing.appliid
> AND cust_masterdata.variation = view_billing.variation
> AND cust_masterdata.id = view_billing.custid
> WHERE view_billing.appliid = ?
> AND view_billing.variation = ?
> AND not view_billing.billdate is null
> AND view_billing.paied <> 'J' AND view_billing.expensed <> 'J'
> ORDER BY customer ASC
>
> </property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="BorderTopBottom" id="129">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="Currency" id="169">
> <structure name="numberFormat">
> <property name="category">Currency</property>
> <property name="pattern">#,##0.00�</property>
> </structure>
> <property name="textAlign">right</property>
> </style>
> <style name="page" id="248">
> <property name="fontFamily">"Arial"</property>
> </style>
> <style name="ArticleRow" id="297">
> <property name="marginTop">10pt</property>
> <property name="marginBottom">0pt</property>
> </style>
> <style name="HedareIntern" id="348">
> <property name="backgroundColor">#C0C0C0</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">x-large</property>
> <property name="textAlign">center</property>
> </style>
> <style name="TableHeader" id="390">
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> </style>
> <style name="SubHeader" id="465">
> <property name="fontSize">larger</property>
> <property name="fontWeight">bolder</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="Percent" id="652">
> <structure name="numberFormat">
> <property name="category">Percent</property>
> <property name="pattern">#,##0.00%</property>
> </structure>
> <property name="textAlign">center</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">1cm</property>
> <property name="leftMargin">1cm</property>
> <property name="bottomMargin">1cm</property>
> <property name="rightMargin">1cm</property>
> <page-footer>
> <text id="391">
> <property name="style">page</property>
> <property name="marginTop">11pt</property>
> <property name="textAlign">center</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[Seite
> <value-of>pageNumber</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <text id="426">
> <property name="style">HedareIntern</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[Altersstruktur der
> Debitoren-OPs vom <value-of format="dd.MM.yyyy">new
> Date()</value-of>]]></text-property>
> </text>
> <table id="392">
> <property name="style">page</property>
> <property name="fontSize">small</property>
> <property name="marginTop">10pt</property>
> <property name="width">100%</property>
> <property name="dataSet">BillNotPaied</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">custid</property>
> <expression
> name="expression">dataSetRow["custid"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">billdate</property>
> <expression
> name="expression">dataSetRow["billdate"]</expression>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">customer</property>
> <expression
> name="expression">dataSetRow["customer"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">amountpriceafterskonto</property>
> <expression
> name="expression">dataSetRow["amountpriceafterskonto"]</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">gesamt</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"], null,
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount30D</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 0)), (DateTimeSpan.subDate(new Date(), 0, 0, 30))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount60D</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 31)), (DateTimeSpan.subDate(new Date(), 0, 0, 60))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount90D</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 61)), (DateTimeSpan.subDate(new Date(), 0, 0, 90))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount180D</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 91)), (DateTimeSpan.subDate(new Date(), 0, 0, 180))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount365D</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 181)), (DateTimeSpan.subDate(new Date(), 0, 0, 365))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount2Y</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.between(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 365)), (DateTimeSpan.subDate(new Date(), 0, 0, 730))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amountg2Y</property>
> <expression
> name="expression">Total.sum(row["amountpriceafterskonto"],
> BirtComp.lessThan(row["billdate"], (DateTimeSpan.subDate(new Date(), 0,
> 0, 730))),
> 'customergroup')</expression>
> <property name="dataType">decimal</property>
> <property name="aggregateOn">customergroup</property>
> </structure>
> <structure>
> <property name="name">amount30DP</property>
> <expression name="expression">row["amount30D"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount60DP</property>
> <expression name="expression">row["amount60D"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount90DP</property>
> <expression name="expression">row["amount90D"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount180DP</property>
> <expression name="expression">row["amount180D"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount365DP</property>
> <expression name="expression">row["amount365D"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount2YP</property>
> <expression name="expression">row["amount2Y"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amountg2Yp</property>
> <expression name="expression">row["amountg2Y"]
> /row["gesamt"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">gesamtSum</property>
> <expression
> name="expression">Total.sum(row["gesamt"])</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount30DSum</property>
> <expression
> name="expression">Total.sum(row["amount30D"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount60DSum</property>
> <expression
> name="expression">Total.sum(row["amount60D"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount90DSum</property>
> <expression
> name="expression">Total.sum(row["amount90D"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount180DSum</property>
> <expression
> name="expression">Total.sum(row["amount180D"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount365DSum</property>
> <expression
> name="expression">Total.sum(row["amount365D"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount2YSum</property>
> <expression
> name="expression">Total.sum(row["amount2Y"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amountg2YSum</property>
> <expression
> name="expression">Total.sum(row["amountg2Y"])</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount30DSumP</property>
> <expression
> name="expression">row["amount30DSum"]/row["gesamtSum"] </expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount60DSumP</property>
> <expression
> name="expression">row["amount60DSum"]/row["gesamtSum"] </expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount90DSumP</property>
> <expression
> name="expression">row["amount90DSum"]/row["gesamtSum"] </expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount180DSumP</property>
> <expression
> name="expression">row["amount180DSum"]/row["gesamtSum"] </expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount365DSumP</property>
> <expression
> name="expression">row["amount180DSum"]/row["gesamtSum"] </expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">amount2YSumP</property>
> <expression
> name="expression">row["amount2YSum"]/12</expression>
> <property name="dataType">any</property>
> </structure>
> <structure>
> <property name="name">amountg2YSumP</property>
> <expression
> name="expression">Total.sum(dataSetRow["amountpriceafterskonto "])</expression>
>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <column id="560">
> <property name="width">8%</property>
> </column>
> <column id="411">
> <property name="width">34%</property>
> </column>
> <column id="487">
> <property name="width">10%</property>
> </column>
> <column id="540">
> <property name="width">10%</property>
> </column>
> <column id="565">
> <property name="width">10%</property>
> </column>
> <column id="584">
> <property name="width">10%</property>
> </column>
> <column id="592">
> <property name="width">10%</property>
> </column>
> <column id="588">
> <property name="width">10%</property>
> </column>
> <column id="600">
> <property name="width">10%</property>
> </column>
> <column id="413">
> <property name="width">10%</property>
> </column>
> <header>
> <row id="393">
> <cell id="557">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="561">
> <property name="style">TableHeader</property>
> <text-property name="text">Nr.</text-property>
> </label>
> </cell>
> <cell id="394">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="416">
> <property name="style">TableHeader</property>
> <text-property name="text">Kunde</text-property>
> </label>
> </cell>
> <cell id="484">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="489">
> <property name="style">TableHeader</property>
> <text-property name="text">0-30
> Tage</text-property>
> </label>
> </cell>
> <cell id="537">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="541">
> <property name="style">TableHeader</property>
> <text-property name="text">31-60
> Tage</text-property>
> </label>
> </cell>
> <cell id="562">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="593">
> <property name="style">TableHeader</property>
> <text-property name="text">61-90
> Tage</text-property>
> </label>
> </cell>
> <cell id="581">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="594">
> <property name="style">TableHeader</property>
> <text-property name="text">91-180
> Tage</text-property>
> </label>
> </cell>
> <cell id="589">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="595">
> <property name="style">TableHeader</property>
> <text-property name="text">181-365
> Tage</text-property>
> </label>
> </cell>
> <cell id="585">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="596">
> <property name="style">TableHeader</property>
> <text-property name="text">1-2
> Jahre</text-property>
> </label>
> </cell>
> <cell id="597">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="601">
> <property name="style">TableHeader</property>
> <text-property name="text">> 2
> Jahre</text-property>
> </label>
> </cell>
> <cell id="396">
> <property
> name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <label id="420">
> <property name="style">TableHeader</property>
> <text-property
> name="text">Gesamt</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="605">
> <property name="groupName">customergroup</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["customer"]</expression>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">true</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <list-property name="filter">
> <structure>
> <property name="operator">ge</property>
> <expression name="expr">row["billdate"]</expression>
> <expression
> name="value1">DateTimeSpan.subDate(new Date(), 0, 0, 30)</expression>
> </structure>
> </list-property>
> <header>
> <row id="606">
> <property name="height">10pt</property>
> <cell id="607"/>
> <cell id="608"/>
> <cell id="609"/>
> <cell id="610"/>
> <cell id="611"/>
> <cell id="612"/>
> <cell id="613"/>
> <cell id="614"/>
> <cell id="615"/>
> <cell id="616"/>
> </row>
> </header>
> <footer>
> <row id="617">
> <cell id="618">
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="628">
> <property name="textAlign">center</property>
> <property
> name="resultSetColumn">custid</property>
> </data>
> </cell>
> <cell id="619">
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="629">
> <property
> name="resultSetColumn">customer</property>
> </data>
> </cell>
> <cell id="620">
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="632">
> <property name="style">Currency</property>
> <property
> name="resultSetColumn">amount30D</property>
> </data>
> </cell>
> <cell id="621">
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#000000</property>
> <property name="b
|
|
|
Goto Forum:
Current Time: Fri Jul 18 09:46:52 EDT 2025
Powered by FUDForum. Page generated in 0.03291 seconds |
Home