Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » extending example salesInvoice
extending example salesInvoice [message #224633] Tue, 13 March 2007 13:31 Go to next message
lukas myslivec is currently offline lukas myslivecFriend
Messages: 1
Registered: July 2009
Junior Member
hi,

i am new with birt and i am playing around.

is it possible to to generate the salesinvoice report for more than one
order?

i did like to have one invoice per page.

/lukas

Report message to a moderator

Re: extending example salesInvoice [message #224791 is a reply to message #224633] Tue, 13 March 2007 17:06 Go to previous message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

This is a multi-part message in MIME format.
--------------080600020007020003000503
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

lukas wrote:
> hi,
>
> i am new with birt and i am playing around.
>
> is it possible to to generate the salesinvoice report for more than one
> order?
>
> i did like to have one invoice per page.
>
> /lukas
>
Yes. See the attachment.

Jason


--------------080600020007020003000503
Content-Type: text/xml;
name="SalesInvoiceAll.rptdesign"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="SalesInvoiceAll.rptdesign"

<?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="author">Paul Clenahan</property>
<property name="createdBy">Eclipse BIRT Designer Version 1.0.0 Build &lt;20050601-0809></property>
<property name="units">in</property>
<text-property name="title">Classic Models Sales Invoice Report</text-property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Classic Models" id="6">
<property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Invoice Data" id="7">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICE_CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">FIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">PRODUCTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">MSRP</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Classic Models</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICE_CITY</property>
<property name="nativeName">OFFICE_CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LASTNAME</property>
<property name="nativeName">LASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">FIRSTNAME</property>
<property name="nativeName">FIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">CONTACTLASTNAME</property>
<property name="nativeName">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="nativeName">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">SHIPPEDDATE</property>
<property name="nativeName">SHIPPEDDATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">PRODUCTNAME</property>
<property name="nativeName">PRODUCTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">MSRP</property>
<property name="nativeName">MSRP</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">SELECT
CLASSICMODELS.OFFICES.CITY AS "OFFICE_CITY",
CLASSICMODELS.EMPLOYEES.LASTNAME,
CLASSICMODELS.EMPLOYEES.FIRSTNAME,
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME,
CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME,
CLASSICMODELS.CUSTOMERS.ADDRESSLINE1,
CLASSICMODELS.CUSTOMERS.ADDRESSLINE2,
CLASSICMODELS.CUSTOMERS.CITY,
CLASSICMODELS.CUSTOMERS.STATE,
CLASSICMODELS.CUSTOMERS.POSTALCODE,
CLASSICMODELS.CUSTOMERS.COUNTRY,
CLASSICMODELS.ORDERS.ORDERNUMBER,
CLASSICMODELS.ORDERS.ORDERDATE,
CLASSICMODELS.ORDERS.SHIPPEDDATE,
CLASSICMODELS.ORDERDETAILS.PRODUCTCODE,
CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED,
CLASSICMODELS.ORDERDETAILS.PRICEEACH,
CLASSICMODELS.PRODUCTS.PRODUCTNAME,
CLASSICMODELS.PRODUCTS.MSRP

FROM
CLASSICMODELS.OFFICES,
CLASSICMODELS.EMPLOYEES,
CLASSICMODELS.CUSTOMERS,
CLASSICMODELS.ORDERS,
CLASSICMODELS.ORDERDETAILS,
CLASSICMODELS.PRODUCTS

WHERE CLASSICMODELS.OFFICES.OFFICECODE = CLASSICMODELS.EMPLOYEES.OFFICECODE
AND CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER = CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER
AND CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = CLASSICMODELS.ORDERS.CUSTOMERNUMBER
AND CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
AND CLASSICMODELS.ORDERDETAILS.PRODUCTCODE = CLASSICMODELS.PRODUCTS.PRODUCTCODE


ORDER BY CLASSICMODELS.ORDERS.ORDERNUMBER</property>
</oda-data-set>
</data-sets>
<styles>
<style name="BackgroundLightGray" id="2">
<property name="backgroundColor">#EAEAEA</property>
</style>
<style name="BackgroundBlue" id="3">
<property name="backgroundColor">#4B6987</property>
</style>
<style name="BackgroundYellow" id="4">
<property name="backgroundColor">#FAD764</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="8">
<page-footer>
<text id="9">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="10">
<property name="width">100%</property>
<column id="11">
<property name="width">2.8in</property>
</column>
<column id="12">
<property name="width">3.2in</property>
</column>
<row id="13">
<property name="style">BackgroundLightGray</property>
<cell id="14">
<property name="style">BackgroundLightGray</property>
<image id="15">
<property name="borderBottomColor">#808080</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#808080</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#808080</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#808080</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="source">embed</property>
<property name="imageName">C:\Documents and Settings\pclenahan\My Documents\ClassicModels\logos\Classic-Models-Full-M.jpg</property >
</image>
</cell>
<cell id="16">
<property name="style">BackgroundLightGray</property>
<property name="verticalAlign">middle</property>
<label id="17">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">20pt</property>
<property name="fontWeight">bold</property>
<property name="color">#000080</property>
<text-property name="text">Classic Models, Inc.</text-property>
</label>
<text id="18">
<property name="fontFamily">sans-serif</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[701 Gateway Boulevard,<BR>
San Francisco, CA 94107<BR>
<BR>]]></text-property>
</text>
<label id="19">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">18pt</property>
<property name="fontWeight">bold</property>
<text-property name="text">Sales Invoice</text-property>
</label>
</cell>
</row>
<row id="20">
<property name="height">0.25in</property>
<cell id="21"/>
<cell id="22"/>
</row>
</grid>
<table id="23">
<property name="pageBreakAfter">auto</property>
<property name="width">100%</property>
<property name="dataSet">Invoice Data</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">PRODUCTCODE</property>
<expression name="expression">dataSetRow["PRODUCTCODE"]</expression >
</structure>
<structure>
<property name="name">PRODUCTNAME</property>
<expression name="expression">dataSetRow["PRODUCTNAME"]</expression >
</structure>
<structure>
<property name="name">QUANTITYORDERED</property>
<expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >
</structure>
<structure>
<property name="name">MSRP</property>
<expression name="expression">dataSetRow["MSRP"]</expression>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<expression name="expression">dataSetRow["PRICEEACH"]</expression>
</structure>
<structure>
<property name="name">(row["MSRP"] - row["PRICEEACH"]) / row["MSRP"]</property>
<expression name="expression">(row["MSRP"] - row["PRICEEACH"]) / row["MSRP"]</expression>
</structure>
<structure>
<property name="name">row["QUANTITYORDERED"] * row["PRICEEACH"]</property>
<expression name="expression">row["QUANTITYORDERED"] * row["PRICEEACH"]</expression>
</structure>
<structure>
<property name="name">ORDERNUMBER</property>
<expression name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">CUSTOMERNAME</property>
<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">CONTACTFIRSTNAME</property>
<expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">CONTACTLASTNAME</property>
<expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"]</property>
<expression name="expression">row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression name="expression">dataSetRow["CITY"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression name="expression">dataSetRow["STATE"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">(row["CITY"] + ", " + row["STATE"] + " " +
row["POSTALCODE"]).replace("null, ", "").replace("null ", "").replace("null", "")</property>
<expression name="expression">(row["CITY"] + ", " + row["STATE"] + " " +
row["POSTALCODE"]).replace("null, ", "").replace("null ", "").replace("null", "")</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression name="expression">dataSetRow["COUNTRY"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">ORDERDATE</property>
<expression name="expression">dataSetRow["ORDERDATE"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">SHIPPEDDATE</property>
<expression name="expression">dataSetRow["SHIPPEDDATE"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">OFFICE_CITY</property>
<expression name="expression">dataSetRow["OFFICE_CITY"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">FIRSTNAME</property>
<expression name="expression">dataSetRow["FIRSTNAME"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">LASTNAME</property>
<expression name="expression">dataSetRow["LASTNAME"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">row["FIRSTNAME"] + " " + row["LASTNAME"]</property>
<expression name="expression">row["FIRSTNAME"] + " " + row["LASTNAME"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">QUANTITYORDERED_1</property>
<expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">PRICEEACH_1</property>
<expression name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="aggregateOn">Order Group</property>
</structure>
<structure>
<property name="name">Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH "])</property>
<expression name="expression">Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH "])</expression>
<property name="aggregateOn">Order Group</property>
</structure>
</list-property>
<property name="pageBreakInterval">0</property>
<column id="132"/>
<column id="133"/>
<column id="134"/>
<column id="135"/>
<column id="136"/>
<column id="137"/>
<column id="138"/>
<group id="24">
<property name="groupName">Order Group</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["ORDERNUMBER"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">always</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="25">
<cell id="26">
<property name="colSpan">7</property>
<property name="rowSpan">1</property>
<grid id="27">
<property name="pageBreakBefore">auto</property>
<property name="width">100%</property>
<column id="28">
<property name="width">2.343in</property>
</column>
<column id="29">
<property name="width">0.25in</property>
</column>
<column id="30">
<property name="width">3.312in</property>
</column>
<row id="31">
<cell id="32">
<property name="style">BackgroundBlue</property>
<label id="33">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">large</property>
<property name="color">#FFFFFF</property>
<text-property name="text">Customer Details</text-property>
</label>
</cell>
<cell id="34"/>
<cell id="35">
<property name="style">BackgroundBlue</property>
<label id="36">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">large</property>
<property name="color">#FFFFFF</property>
<text-property name="text">Order Details</text-property>
</label>
</cell>
</row>
<row id="37">
<cell id="38">
<property name="style">BackgroundLightGray</property>
<property name="verticalAlign">top</property>
<data id="39">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">CUSTOMERNAME</property>
</data>
<data id="40">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"]</property>
</data>
<data id="41">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">ADDRESSLINE1</property>
</data>
<data id="42">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">ADDRESSLINE2</property>
</data>
<data id="43">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">(row["CITY"] + ", " + row["STATE"] + " " +
row["POSTALCODE"]).replace("null, ", "").replace("null ", "").replace("null", "")</property>
</data>
<data id="44">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">COUNTRY</property>
</data>
</cell>
<cell id="45"/>
<cell id="46">
<property name="style">BackgroundLightGray</property>
<grid id="47">
<property name="width">100%</property>
<column id="48"/>
<column id="49"/>
<row id="50">
<cell id="51">
<label id="52">
<property name="fontFamily">sans-serif</property>
<text-property name="text">Customer Number:</text-property>
</label>
</cell>
<cell id="53">
<data id="54">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">CUSTOMERNUMBER</property>
</data>
</cell>
</row>
<row id="55">
<cell id="56">
<label id="57">
<property name="fontFamily">sans-serif</property>
<text-property name="text">Order Number:</text-property>
</label>
</cell>
<cell id="58">
<data id="59">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
</row>
<row id="60">
<cell id="61">
<label id="62">
<property name="fontFamily">sans-serif</property>
<text-property name="text">Order Date:</text-property>
</label>
</cell>
<cell id="63">
<data id="64">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">ORDERDATE</property>
</data>
</cell>
</row>
<row id="65">
<cell id="66">
<label id="67">
<property name="fontFamily">sans-serif</property>
<text-property name="text">Ship Date:</text-property>
</label>
</cell>
<cell id="68">
<data id="69">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">SHIPPEDDATE</property>
</data>
</cell>
</row>
<row id="70">
<cell id="71">
<label id="72">
<property name="fontFamily">sans-serif</property>
<text-property name="text">Office:</text-property>
</label>
</cell>
<cell id="73">
<data id="74">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">OFFICE_CITY</property>
</data>
</cell>
</row>
<row id="75">
<cell id="76">
<label id="77">
<property name="fontFamily">sans-serif</property>
<text-property name="text">Sales Representative:</text-property>
</label>
</cell>
<cell id="78">
<data id="79">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="resultSetColumn">row["FIRSTNAME"] + " " + row["LASTNAME"]</property>
</data>
</cell>
</row>
</grid>
</cell>
</row>
<row id="80">
<property name="height">0.25in</property>
<cell id="81"/>
<cell id="82"/>
<cell id="83"/>
</row>
</grid>
</cell>
</row>
<row id="84">
<property name="style">BackgroundYellow</property>
<cell id="85">
<property name="style">BackgroundYellow</property>
<property name="borderBottomColor">#808080</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#808080</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#808080</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#808080</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="86">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Code</text-property>
</label>
</cell>
<cell id="87">
<property name="style">BackgroundYellow</property>
<property name="borderBottomColor">#808080</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#808080</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#808080</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#808080</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">3pt</property>

Report message to a moderator

Previous Topic:charting disparate data sets on the same chart
Next Topic:Engine generates random names for images
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 17:21:32 GMT 2024

Powered by FUDForum. Page generated in 0.03378 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