|
Re: Export - Urgent HELP required. [message #148763 is a reply to message #148582] |
Tue, 28 March 2006 02:49 |
|
AJ
Can you post number 2?
Jason
"AJ" <ajay.sinha@siemens.com> wrote in message
news:636cae12bb9ec7328480715f2329a2ce$1@www.eclipse.org...
> Hi,
> I have following setup:
> Eclipse 3.1.0
> BIRT 2.0.1
> EMF 2.1.2
> GEF 3.1.1
>
> I have two reports.
> 1. Simple list report - with report parameters
> 2. Grouped report - no report parameter
>
> For the first report exort to csv works fine.
> When I try to export report 2, I get follwoing error.
> ===================
> Exception in:
> DocumentProcessor.doQueryExport()
>
> There is no result set available for extracting the data.
> ===================
> Also can we export directly to excel or pdf instead of csv?
>
> Thanks.
>
>
|
|
|
|
Re: Export - Urgent HELP required. [message #149095 is a reply to message #148872] |
Tue, 28 March 2006 14:57 |
|
When you run it can you specify __document=somefile.rptdocument and then
email me that document?
Jason
"AJ" <ajay.sinha@siemens.com> wrote in message
news:460a376996f38da3859206c50e351115$1@www.eclipse.org...
> Jason,
> Here is the xml file.
> ======================================================
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Written by Eclipse BIRT 2.0 -->
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.0.1 Build
> <20060222-1204></property>
> <property name="units">in</property>
> <text-property name="displayName">Report Template</text-property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="winccDataSource"
> id="44">
> <property
> name="odaDriverClass">com.microsoft.jdbc.sqlserver.SQLServerDriver </property>
> <property
> name="odaURL">jdbc:microsoft:sqlserver://SDR7887D\WINCC:1193 ;SelectMethod=cursor;DatabaseName=CC_TestProj_06_02_17_15_09 _53R </property>
> <property name="odaUser">user1</property>
> <encrypted-property
> name="odaPassword">dGhl</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="winccDataSet" id="45">
> <property name="dataSource">winccDataSource</property>
> <property name="queryText"> select dbo.AlgDataTmp.msgnr as
> 'MessageNumber', dbo.AlgDataTmp.TimeDiff as 'Duration',
> dbo.AlgDataTmp.text1 as 'Description' , dbo.AlgDataTmp.ptext4 as 'Area',
> dbo.AlgDataTmp.ptext5 as 'Source' from dbo.AlgDataTmp </property>
> </oda-data-set>
> </data-sets>
> <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>
> <grid id="4">
> <property name="width">100%</property>
> <column id="5"/>
> <row id="6">
> <cell id="7"/>
> </row>
> <row id="8">
> <cell id="9">
> <text id="96">
> <property name="backgroundColor">#00FFFF</property>
> <property name="textAlign">center</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<H3>Messages
> Grouped By Message Number</H3>]]></text-property>
> </text>
> </cell>
> </row>
> <row id="10">
> <cell id="11"/>
> </row>
> </grid>
> <grid id="12">
> <property name="width">100%</property>
> <property name="dataSet">winccDataSet</property>
> <column id="13"/>
> <row id="16">
> <cell id="17">
> <table id="47">
> <property name="width">100%</property>
> <column id="60">
> <property name="width">0.864in</property>
> </column>
> <column id="61">
> <property name="width">1.489in</property>
> </column>
> <column id="62"/>
> <column id="84"/>
> <column id="90"/>
> <header>
> <row id="48">
> <cell id="49">
> <property
> name="backgroundColor">#FFFF00</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">medium</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">medium</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">medium</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">medium</property>
> <property
> name="textAlign">center</property>
> <text id="95">
> <property
> name="contentType">plain</property>
> <text-property
> name="content"><![CDATA[Message#]]></text-property>
> </text>
> </cell>
> <cell id="50">
> <property
> name="backgroundColor">#FFFF00</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">medium</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">medium</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">medium</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">medium</property>
> <property
> name="textAlign">center</property>
> <label id="75">
> <text-property
> name="text">Duration</text-property>
> </label>
> </cell>
> <cell id="51">
> <property
> name="backgroundColor">#FFFF00</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">medium</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">medium</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">medium</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">medium</property>
> <property
> name="textAlign">center</property>
> <label id="77">
> <text-property
> name="text">Description</text-property>
> </label>
> </cell>
> <cell id="79">
> <property
> name="backgroundColor">#FFFF00</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">medium</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">medium</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">medium</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">medium</property>
> <property
> name="textAlign">center</property>
> <label id="91">
> <text-property
> name="text">Area</text-property>
> </label>
> </cell>
> <cell id="85">
> <property
> name="backgroundColor">#FFFF00</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">medium</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">medium</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">medium</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">medium</property>
> <property
> name="textAlign">center</property>
> <label id="93">
> <text-property
> name="text">Source</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="64">
> <property
> name="groupName">groupMsgNr</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression
> name="keyExpr">row["MessageNumber"]</expression>
> <header>
> <row id="65">
> <cell id="66">
> <property
> name="colSpan">5</property>
> <property
> name="rowSpan">1</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">medium</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">medium</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">medium</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">medium</property>
> <data id="74">
> <list-property
> name="highlightRules">
> <structure>
> <property
> name="operator">gt</property>
> <property
> name="backgroundColor">#FF0000</property>
> <property
> name="color">#000000</property>
> <expression
> name="testExpr">Total.count()</expression>
> <expression
> name="value1">5</expression>
> </structure>
> </list-property>
> <expression
> name="valueExpr">"Message Number : " + row["MessageNumber"] + " " + "
> Total Messages : " + Total.count()</expression>
> </data>
> </cell>
> </row>
> </header>
> <footer>
> <row id="69">
> <cell id="70"/>
> <cell id="71">
> <data id="105">
> <list-property
> name="highlightRules">
> <structure>
> <property
> name="operator">gt</property>
> <property
> name="backgroundColor">#FF0000</property>
> <property
> name="color">#000000</property>
> <expression
> name="testExpr">Total.count()</expression>
> <expression
> name="value1">5</expression>
> </structure>
> </list-property>
> <expression
> name="valueExpr">"End of message " + row["MessageNumber"]</expression>
> </data>
> </cell>
> <cell id="72"/>
> <cell id="82"/>
> <cell id="88"/>
> </row>
> </footer>
> </group>
> <detail>
> <row id="52">
> <cell id="53">
> <property
> name="borderBottomColor">#C0C0C0</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#C0C0C0</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#C0C0C0</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#C0C0C0</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">thin</property>
> </cell>
> <cell id="54">
> <property
> name="borderBottomColor">#C0C0C0</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#C0C0C0</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#C0C0C0</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#C0C0C0</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">thin</property>
> <data id="76">
> <expression
> name="valueExpr">row["Duration"]</expression>
> </data>
> </cell>
> <cell id="55">
> <property
> name="borderBottomColor">#C0C0C0</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#C0C0C0</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#C0C0C0</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#C0C0C0</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">thin</property>
> <data id="78">
> <expression
> name="valueExpr">row["Description"]</expression>
> </data>
> </cell>
> <cell id="81">
> <property
> name="borderBottomColor">#C0C0C0</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#C0C0C0</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#C0C0C0</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#C0C0C0</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">thin</property>
> <data id="92">
> <expression
> name="valueExpr">row["Area"]</expression>
> </data>
> </cell>
> <cell id="87">
> <property
> name="borderBottomColor">#C0C0C0</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#C0C0C0</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#C0C0C0</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#C0C0C0</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">thin</property>
> <data id="94">
> <expression
> name="valueExpr">row["Source"]</expression>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="56">
> <cell id="57"/>
> <cell id="58"/>
> <cell id="59"/>
> <cell id="83"/>
> <cell id="89"/>
> </row>
> </footer>
> </table>
> </cell>
> </row>
> <row id="20">
> <cell id="21"/>
> </row>
> <row id="24">
> <cell id="25"/>
> </row>
> </grid>
> <grid id="28">
> <property name="width">100%</property>
> <column id="29"/>
> <row id="32">
> <cell id="33"/>
> </row>
> <row id="36">
> <cell id="37"/>
> </row>
> <row id="40">
> <cell id="41"/>
> </row>
> </grid>
> </body>
> </report>
>
>
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04058 seconds