[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [6697] bkbooking: simpler version of report
|
From: |
Kjell Arne Espedal |
|
Subject: |
[Fmsystem-commits] [6697] bkbooking: simpler version of report |
|
Date: |
Wed, 22 Dec 2010 15:18:11 +0000 |
Revision: 6697
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6697
Author: kjell
Date: 2010-12-22 15:18:10 +0000 (Wed, 22 Dec 2010)
Log Message:
-----------
bkbooking: simpler version of report
Modified Paths:
--------------
trunk/booking/jasper/templates/application.jrxml
Modified: trunk/booking/jasper/templates/application.jrxml
===================================================================
--- trunk/booking/jasper/templates/application.jrxml 2010-12-22 15:12:28 UTC
(rev 6696)
+++ trunk/booking/jasper/templates/application.jrxml 2010-12-22 15:18:10 UTC
(rev 6697)
@@ -2,7 +2,7 @@
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="report1"
language="groovy" pageWidth="595" pageHeight="842" columnWidth="555"
leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="0.9090909090909091"/>
<property name="ireport.x" value="0"/>
- <property name="ireport.y" value="96"/>
+ <property name="ireport.y" value="120"/>
<property name="net.sf.jasperreports.export.pdf.tagged" value="true"/>
<property name="net.sf.jasperreports.export.pdf.tag.language"
value="EN-US"/>
<style name="table">
@@ -28,37 +28,11 @@
<subDataset name="resources">
<parameter name="APPLICATION_ID" class="java.lang.Integer"/>
<queryString>
- <![CDATA[SELECT bb_resource.name AS resource_name,
bb_resource.type AS resource_type FROM
bb_application,bb_application_resource,bb_resource WHERE bb_application.id =
$P{APPLICATION_ID} AND bb_application.id =
bb_application_resource.application_id AND bb_application_resource.resource_id
= bb_resource.id]]>
+ <![CDATA[SELECT bb_resource.name AS resource_name,
bb_resource.type AS resource_type FROM
bb_application,bb_application_resource,bb_resource WHERE bb_application.id =
$P!{APPLICATION_ID} AND bb_application.id =
bb_application_resource.application_id AND bb_application_resource.resource_id
= bb_resource.id]]>
</queryString>
<field name="resource_name" class="java.lang.String"/>
<field name="resource_type" class="java.lang.String"/>
</subDataset>
- <subDataset name="targetaudience">
- <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
- <queryString>
- <![CDATA[SELECT bb_targetaudience.name AS
targetaudience FROM bb_application_targetaudience,bb_targetaudience WHERE
bb_application_targetaudience.application_id = $P{APPLICATION_ID} AND
bb_application_targetaudience.targetaudience_id = bb_targetaudience.id]]>
- </queryString>
- <field name="targetaudience" class="java.lang.String"/>
- </subDataset>
- <subDataset name="agegroup">
- <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
- <queryString>
- <![CDATA[SELECT bb_agegroup.name AS agegroup ,
bb_application_agegroup.male, bb_application_agegroup.female FROM
bb_agegroup,bb_application_agegroup WHERE
bb_application_agegroup.application_id = $P{APPLICATION_ID} AND
bb_application_agegroup.agegroup_id = bb_agegroup.id AND bb_agegroup.active = 1
ORDER BY bb_agegroup.sort]]>
- </queryString>
- <field name="agegroup" class="java.lang.String"/>
- <field name="male" class="java.lang.Integer"/>
- <field name="female" class="java.lang.Integer"/>
- </subDataset>
- <subDataset name="comment">
- <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
- <queryString language="SQL">
- <![CDATA[SELECT
- to_char(time,'DD/MM/YYYY HH24:MI') AS date, author, comment FROM
"bb_application_comment" bb_application_comment WHERE
bb_application_comment.application_id = $P{APPLICATION_ID} AND
bb_application_comment.type = 'comment']]>
- </queryString>
- <field name="date" class="java.lang.String"/>
- <field name="author" class="java.lang.String"/>
- <field name="comment" class="java.lang.String"/>
- </subDataset>
<parameter name="BK_APPLICATION_ID" class="java.lang.String"/>
<parameter name="BK_BUILDING_NAME" class="java.lang.String"/>
<queryString>
@@ -102,7 +76,7 @@
<textField>
<reportElement style="Sans_Normal" x="58"
y="66" width="156" height="13"/>
<textElement/>
- <textFieldExpression
class="java.lang.String"><![CDATA["Navn" +
$F{contact_name}]]></textFieldExpression>
+ <textFieldExpression
class="java.lang.String"><![CDATA["Navn: " +
$F{contact_name}]]></textFieldExpression>
</textField>
<textField>
<reportElement style="Sans_Normal" x="58"
y="40" width="481" height="13"/>
@@ -149,45 +123,12 @@
<text><![CDATA[Formål]]></text>
</staticText>
<staticText>
- <reportElement style="headers" x="6" y="443"
width="546" height="20"/>
- <textElement/>
- <text><![CDATA[Målgruppe og estimert antall
deltakerte]]></text>
- </staticText>
- <break>
- <reportElement x="0" y="612" width="100"
height="1"/>
- </break>
- <staticText>
<reportElement style="Sans_Bold" x="58" y="184"
width="286" height="13"/>
<textElement>
<font isBold="true"
isPdfEmbedded="true"/>
</textElement>
<text><![CDATA[Søker har lest og akseptert
følgende dokument:]]></text>
</staticText>
- <componentElement>
- <reportElement x="58" y="482" width="195"
height="13"/>
- <jr:list
xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components
http://jasperreports.sourceforge.net/xsd/components.xsd"; printOrder="Vertical">
- <datasetRun subDataset="targetaudience">
- <datasetParameter
name="APPLICATION_ID">
-
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
- </datasetParameter>
-
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
- </datasetRun>
- <jr:listContents height="13"
width="195">
- <textField>
- <reportElement x="0"
y="0" width="195" height="13"/>
- <textElement/>
- <textFieldExpression
class="java.lang.String"><![CDATA[$F{targetaudience}]]></textFieldExpression>
- </textField>
- </jr:listContents>
- </jr:list>
- </componentElement>
- <staticText>
- <reportElement x="58" y="469" width="100"
height="13"/>
- <textElement>
- <font isBold="true"
isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Målgruppe:]]></text>
- </staticText>
<textField pattern="###0.00">
<reportElement x="58" y="261" width="126"
height="13"/>
<textElement/>
@@ -204,9 +145,6 @@
<line>
<reportElement x="6" y="304" width="546"
height="1" forecolor="#C0C0C0"/>
</line>
- <line>
- <reportElement x="6" y="461" width="546"
height="1" forecolor="#C0C0C0"/>
- </line>
<textField>
<reportElement style="Sans_Bold" x="58" y="53"
width="156" height="13"/>
<textElement>
@@ -255,124 +193,12 @@
<textElement/>
<textFieldExpression
class="java.lang.String"><![CDATA["Til: " + $F{to}]]></textFieldExpression>
</textField>
- <componentElement>
- <reportElement key="table" style="table"
x="292" y="469" width="191" height="130"/>
- <jr:table
xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components
http://jasperreports.sourceforge.net/xsd/components.xsd";>
- <datasetRun subDataset="agegroup">
- <datasetParameter
name="APPLICATION_ID">
-
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
- </datasetParameter>
-
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
- </datasetRun>
- <jr:column width="128">
- <jr:columnHeader height="19"
rowSpan="1">
- <staticText>
- <reportElement
style="table_CELL_DARK" x="0" y="0" width="128" height="19"/>
- <textElement>
- <font
isBold="true" isItalic="true"/>
- </textElement>
-
<text><![CDATA[Antall deltakere]]></text>
- </staticText>
- </jr:columnHeader>
- <jr:detailCell height="20"
rowSpan="1">
- <textField>
- <reportElement
style="table_CELL_DARK" x="0" y="0" width="128" height="19"/>
- <textElement>
- <font
isBold="true"/>
- </textElement>
-
<textFieldExpression
class="java.lang.String"><![CDATA[$F{agegroup}]]></textFieldExpression>
- </textField>
- </jr:detailCell>
- </jr:column>
- <jr:column width="47">
- <jr:columnHeader height="19"
rowSpan="1">
- <staticText>
- <reportElement
style="table_CELL_DARK" x="0" y="0" width="47" height="19"/>
- <textElement>
- <font
isBold="true"/>
- </textElement>
-
<text><![CDATA[Mann]]></text>
- </staticText>
- </jr:columnHeader>
- <jr:detailCell height="20"
rowSpan="1">
- <textField>
- <reportElement
style="table_CELL_LIGHT" x="0" y="0" width="47" height="19"/>
- <textElement/>
-
<textFieldExpression
class="java.lang.Integer"><![CDATA[$F{male}]]></textFieldExpression>
- </textField>
- </jr:detailCell>
- </jr:column>
- <jr:column width="47">
- <jr:columnHeader height="19"
rowSpan="1">
- <staticText>
- <reportElement
style="table_CELL_DARK" x="0" y="0" width="47" height="19"/>
- <textElement>
- <font
isBold="true"/>
- </textElement>
-
<text><![CDATA[Kvinne]]></text>
- </staticText>
- </jr:columnHeader>
- <jr:detailCell height="20"
rowSpan="1">
- <textField>
- <reportElement
style="table_CELL_LIGHT" x="0" y="0" width="47" height="19"/>
- <textElement/>
-
<textFieldExpression
class="java.lang.Integer"><![CDATA[$F{female}]]></textFieldExpression>
- </textField>
- </jr:detailCell>
- </jr:column>
- </jr:table>
- </componentElement>
<textField>
<reportElement style="Sans_Normal" x="244"
y="79" width="197" height="13"/>
<textElement/>
<textFieldExpression
class="java.lang.String"><![CDATA["E-post: " +
$F{contact_email}]]></textFieldExpression>
</textField>
</band>
- <band height="306">
- <elementGroup>
- <componentElement>
- <reportElement x="6" y="32" width="546"
height="52"/>
- <jr:list
xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components
http://jasperreports.sourceforge.net/xsd/components.xsd"; printOrder="Vertical">
- <datasetRun
subDataset="comment">
- <datasetParameter
name="APPLICATION_ID">
-
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
- </datasetParameter>
-
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
- </datasetRun>
- <jr:listContents height="52"
width="546">
- <textField>
- <reportElement
x="0" y="0" width="104" height="13"/>
- <textElement>
- <font
isBold="true"/>
- </textElement>
-
<textFieldExpression
class="java.lang.String"><![CDATA[$F{date}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement
x="104" y="0" width="117" height="13"/>
- <textElement>
- <font
isBold="true"/>
- </textElement>
-
<textFieldExpression
class="java.lang.String"><![CDATA[$F{author}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement
x="0" y="13" width="546" height="39"/>
- <textElement/>
-
<textFieldExpression
class="java.lang.String"><![CDATA[$F{comment}]]></textFieldExpression>
- </textField>
- </jr:listContents>
- </jr:list>
- </componentElement>
- </elementGroup>
- <elementGroup/>
- <staticText>
- <reportElement style="headers" x="6" y="6"
width="546" height="20"/>
- <textElement/>
- <text><![CDATA[Merknader]]></text>
- </staticText>
- <line>
- <reportElement x="6" y="21" width="546"
height="1" forecolor="#C0C0C0"/>
- </line>
- </band>
</detail>
<pageFooter>
<band height="28">
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [6697] bkbooking: simpler version of report,
Kjell Arne Espedal <=