Author: msorokin Date: 2009-11-09 12:26:15 -0500 (Mon, 09 Nov 2009) New Revision: 18501 Added: trunk/birt/docs/en/files/ trunk/birt/docs/en/files/helloBirt.rptdesign Log: https://jira.jboss.org/jira/browse/JBIDE-4779 updated the guide Added: trunk/birt/docs/en/files/helloBirt.rptdesign =================================================================== --- trunk/birt/docs/en/files/helloBirt.rptdesign (rev 0) +++ trunk/birt/docs/en/files/helloBirt.rptdesign 2009-11-09 17:26:15 UTC (rev 18501) @@ -0,0 +1,554 @@ +<?xml version="1.0" encoding="UTF-8"?> +<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20" id="1"> + <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903 Build &lt;2.5.1.v20090922-0630></property> + <property name="units">in</property> + <property name="iconFile">/templates/first_report.gif</property> + <property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.firstreport</property> + <property name="bidiLayoutOrientation">ltr</property> + <template-parameter-definitions> + <template-parameter-definition name="NewTemplateParameterDefinition" id="28"> + <property name="allowedType">Table</property> + <text-property name="description">Customer Listing</text-property> + <default> + <table id="29"> + <property name="width">100%</property> + <property name="pageBreakInterval">50</property> + <column id="49"/> + <column id="50"/> + <column id="51"/> + <column id="52"/> + <header> + <row id="30"> + <cell id="31"> + <label id="32"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Contact</text-property> + </label> + </cell> + <cell id="33"> + <label id="34"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">First</text-property> + </label> + </cell> + <cell id="35"> + <label id="36"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Last</text-property> + </label> + </cell> + <cell id="37"> + <label id="38"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Phone</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="39"> + <cell id="40"/> + <cell id="41"/> + <cell id="42"/> + <cell id="43"/> + </row> + </detail> + <footer> + <row id="44"> + <cell id="45"/> + <cell id="46"/> + <cell id="47"/> + <cell id="48"/> + </row> + </footer> + </table> + </default> + </template-parameter-definition> + <template-parameter-definition name="NewTemplateParameterDefinition1" id="78"> + <property name="allowedType">Table</property> + <text-property name="description">Customer Listing Table</text-property> + <default> + <table id="79"> + <property name="width">100%</property> + <property name="refTemplateParameter">NewTemplateParameterDefinition</property> + <property name="pageBreakInterval">50</property> + <column id="99"/> + <column id="100"/> + <column id="101"/> + <column id="102"/> + <header> + <row id="80"> + <cell id="81"> + <label id="82"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Contact</text-property> + </label> + </cell> + <cell id="83"> + <label id="84"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">First</text-property> + </label> + </cell> + <cell id="85"> + <label id="86"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Last</text-property> + </label> + </cell> + <cell id="87"> + <label id="88"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Phone</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="89"> + <cell id="90"/> + <cell id="91"/> + <cell id="92"/> + <cell id="93"/> + </row> + </detail> + <footer> + <row id="94"> + <cell id="95"/> + <cell id="96"/> + <cell id="97"/> + <cell id="98"/> + </row> + </footer> + </table> + </default> + </template-parameter-definition> + <template-parameter-definition name="NewTemplateParameterDefinition2" id="132"> + <property name="allowedType">Table</property> + <text-property name="description">Customer Listing Table</text-property> + <default> + <table id="133"> + <property name="width">100%</property> + <property name="refTemplateParameter">NewTemplateParameterDefinition1</property> + <property name="pageBreakInterval">50</property> + <column id="157"/> + <column id="158"/> + <column id="159"/> + <column id="160"/> + <header> + <row id="134"> + <cell id="135"> + <label id="136"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Contact</text-property> + </label> + </cell> + <cell id="137"> + <label id="138"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">First</text-property> + </label> + </cell> + <cell id="139"> + <label id="140"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Last</text-property> + </label> + </cell> + <cell id="141"> + <label id="142"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Phone</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="143"> + <cell id="144"> + <data id="145"/> + </cell> + <cell id="146"> + <data id="147"/> + </cell> + <cell id="148"> + <data id="149"/> + </cell> + <cell id="150"> + <data id="151"/> + </cell> + </row> + </detail> + <footer> + <row id="152"> + <cell id="153"/> + <cell id="154"/> + <cell id="155"/> + <cell id="156"/> + </row> + </footer> + </table> + </default> + </template-parameter-definition> + </template-parameter-definitions> + <parameters> + <scalar-parameter name="reportTitle" id="254"> + <property name="valueType">static</property> + <property name="dataType">string</property> + <property name="distinct">true</property> + <simple-property-list name="defaultValue"> + <value type="constant">No Title</value> + </simple-property-list> + <property name="paramType">simple</property> + <property name="controlType">text-box</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="248"> + <text-property name="displayName"></text-property> + <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="Data Set" id="249"> + <list-property name="columnHints"> + <structure> + <property name="columnName">CUSTOMERNAME</property> + <text-property name="displayName">CUSTOMERNAME</text-property> + </structure> + <structure> + <property name="columnName">CONTACTLASTNAME</property> + <text-property name="displayName">CONTACTLASTNAME</text-property> + </structure> + <structure> + <property name="columnName">CONTACTFIRSTNAME</property> + <text-property name="displayName">CONTACTFIRSTNAME</text-property> + </structure> + <structure> + <property name="columnName">PHONE</property> + <text-property name="displayName">PHONE</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">CUSTOMERNAME</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">CONTACTLASTNAME</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">CONTACTFIRSTNAME</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">PHONE</property> + <property name="dataType">string</property> + </structure> + </list-property> + </structure> + <property name="dataSource">Data Source</property> + <list-property name="resultSet"> + <structure> + <property name="position">1</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">2</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">3</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">4</property> + <property name="name">PHONE</property> + <property name="nativeName">PHONE</property> + <property name="dataType">string</property> + <property name="nativeDataType">12</property> + </structure> + </list-property> + <xml-property name="queryText"><![CDATA[select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, +CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME, +CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME, +CLASSICMODELS.CUSTOMERS.PHONE +from CLASSICMODELS.CUSTOMERS]]></xml-property> + <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?> +<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/desi... xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaMod... + <Version>1.0</Version> + <design:ResultSets derivedMetaData="true"> + <design:resultSetDefinitions> + <design:resultSetColumns> + <design:resultColumnDefinitions> + <design:attributes> + <design:name>CUSTOMERNAME</design:name> + <design:position>1</design:position> + <design:nativeDataTypeCode>12</design:nativeDataTypeCode> + <design:precision>50</design:precision> + <design:scale>0</design:scale> + <design:nullability>Nullable</design:nullability> + <design:uiHints> + <design:displayName>CUSTOMERNAME</design:displayName> + </design:uiHints> + </design:attributes> + <design:usageHints> + <design:label>CUSTOMERNAME</design:label> + <design:formattingHints> + <design:displaySize>50</design:displaySize> + </design:formattingHints> + </design:usageHints> + </design:resultColumnDefinitions> + <design:resultColumnDefinitions> + <design:attributes> + <design:name>CONTACTLASTNAME</design:name> + <design:position>2</design:position> + <design:nativeDataTypeCode>12</design:nativeDataTypeCode> + <design:precision>50</design:precision> + <design:scale>0</design:scale> + <design:nullability>Nullable</design:nullability> + <design:uiHints> + <design:displayName>CONTACTLASTNAME</design:displayName> + </design:uiHints> + </design:attributes> + <design:usageHints> + <design:label>CONTACTLASTNAME</design:label> + <design:formattingHints> + <design:displaySize>50</design:displaySize> + </design:formattingHints> + </design:usageHints> + </design:resultColumnDefinitions> + <design:resultColumnDefinitions> + <design:attributes> + <design:name>CONTACTFIRSTNAME</design:name> + <design:position>3</design:position> + <design:nativeDataTypeCode>12</design:nativeDataTypeCode> + <design:precision>50</design:precision> + <design:scale>0</design:scale> + <design:nullability>Nullable</design:nullability> + <design:uiHints> + <design:displayName>CONTACTFIRSTNAME</design:displayName> + </design:uiHints> + </design:attributes> + <design:usageHints> + <design:label>CONTACTFIRSTNAME</design:label> + <design:formattingHints> + <design:displaySize>50</design:displaySize> + </design:formattingHints> + </design:usageHints> + </design:resultColumnDefinitions> + <design:resultColumnDefinitions> + <design:attributes> + <design:name>PHONE</design:name> + <design:position>4</design:position> + <design:nativeDataTypeCode>12</design:nativeDataTypeCode> + <design:precision>50</design:precision> + <design:scale>0</design:scale> + <design:nullability>Nullable</design:nullability> + <design:uiHints> + <design:displayName>PHONE</design:displayName> + </design:uiHints> + </design:attributes> + <design:usageHints> + <design:label>PHONE</design:label> + <design:formattingHints> + <design:displaySize>50</design:displaySize> + </design:formattingHints> + </design:usageHints> + </design:resultColumnDefinitions> + </design:resultSetColumns> + </design:resultSetDefinitions> + </design:ResultSets> +</model:DesignValues> +]]></xml-property> + </oda-data-set> + </data-sets> + <styles> + <style name="report" id="110"> + <property name="fontFamily">sans-serif</property> + <property name="fontSize">10pt</property> + </style> + <style name="crosstab-cell" id="246"> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> + <style name="crosstab" id="247"> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> + </styles> + <page-setup> + <simple-master-page name="Simple MasterPage" id="2"> + <page-footer> + <text id="3"> + <property name="contentType">html</property> + <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> + </text> + </page-footer> + </simple-master-page> + </page-setup> + <body> + <data id="255"> + <list-property name="boundDataColumns"> + <structure> + <property name="name">reportTitle</property> + <expression name="expression">params["reportTitle"].value</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="resultSetColumn">reportTitle</property> + </data> + <table id="163"> + <property name="width">100%</property> + <property name="dataSet">Data Set</property> + <property name="refTemplateParameter">NewTemplateParameterDefinition2</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">CUSTOMERNAME</property> + <text-property name="displayName">CUSTOMERNAME</text-property> + <expression name="expression">dataSetRow["CUSTOMERNAME"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">CONTACTLASTNAME</property> + <text-property name="displayName">CONTACTLASTNAME</text-property> + <expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">CONTACTFIRSTNAME</property> + <text-property name="displayName">CONTACTFIRSTNAME</text-property> + <expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">PHONE</property> + <text-property name="displayName">PHONE</text-property> + <expression name="expression">dataSetRow["PHONE"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="pageBreakInterval">50</property> + <column id="187"/> + <column id="188"/> + <column id="189"/> + <column id="190"/> + <header> + <row id="164"> + <cell id="165"> + <label id="166"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Customer</text-property> + </label> + </cell> + <cell id="167"> + <label id="168"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">First</text-property> + </label> + </cell> + <cell id="169"> + <label id="170"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Last</text-property> + </label> + </cell> + <cell id="171"> + <label id="172"> + <property name="fontFamily">sans-serif</property> + <property name="fontWeight">bold</property> + <text-property name="text">Phone</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="173"> + <cell id="174"> + <data id="250"> + <property name="resultSetColumn">CUSTOMERNAME</property> + </data> + </cell> + <cell id="176"> + <data id="251"> + <property name="resultSetColumn">CONTACTLASTNAME</property> + </data> + </cell> + <cell id="178"> + <data id="252"> + <property name="resultSetColumn">CONTACTFIRSTNAME</property> + </data> + </cell> + <cell id="180"> + <data id="253"> + <property name="resultSetColumn">PHONE</property> + </data> + </cell> + </row> + </detail> + <footer> + <row id="182"> + <cell id="183"/> + <cell id="184"/> + <cell id="185"/> + <cell id="186"/> + </row> + </footer> + </table> + </body> +</report>