Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Report Problem(Preview problem)
Report Problem [message #661758] Sun, 27 March 2011 14:00 Go to next message
JulioC Missing name is currently offline JulioC Missing name
Messages: 33
Registered: March 2011
Location: Ottawa, Canada
Member
Hi all
I'm new using BIRT
So far I have setup a couple of simple reports
Now I came across with a weird problem
I have a new report, I defined the data source, created the data set
Inside of the data set when I go to preview results I see the data
I don't have any filter or parameter setup
However when I go to preview in the layout tab, I only see just the first record


What I'm doing wrong?

I really appreciate your help

Thanks


Re: Report Problem [message #661937 is a reply to message #661758] Mon, 28 March 2011 14:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report?

Jason

On 3/27/2011 10:00 AM, JulioC wrote:
> Hi all
> I'm new using BIRT
> So far I have setup a couple of simple reports
> Now I came across with a weird problem
> I have a new report, I defined the data source, created the data set
> Inside of the data set when I go to preview results I see the data
> I don't have any filter or parameter setup
> However when I go to preview in the layout tab, I only see just the
> first record
>
>
> What I'm doing wrong?
>
> I really appreciate your help
>
> Thanks
>
>
>
Re: Report Problem [message #662004 is a reply to message #661937] Mon, 28 March 2011 20:08 Go to previous messageGo to next message
JulioC Missing name is currently offline JulioC Missing name
Messages: 33
Registered: March 2011
Location: Ottawa, Canada
Member
Jason Weathersby wrote on Mon, 28 March 2011 10:33
Can you post the report?

Jason

On 3/27/2011 10:00 AM, JulioC wrote:
> Hi all
> I'm new using BIRT
> So far I have setup a couple of simple reports
> Now I came across with a weird problem
> I have a new report, I defined the data source, created the data set
> Inside of the data set when I go to preview results I see the data
> I don't have any filter or parameter setup
> However when I go to preview in the layout tab, I only see just the
> first record
>
>
> What I'm doing wrong?
>
> I really appreciate your help
>
> Thanks
>
>
>

Hi Jason

You mean the rptdesing file?
It has like 2000 lines ,I don't see where to attache it.
Thanks for your reply back

JulioC.

Re: Report Problem [message #662031 is a reply to message #662004] Mon, 28 March 2011 23:30 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Copy the xml and paste it into the reply or use the forums at
www.eclipse.org/forums

Jason

On 3/28/2011 4:08 PM, JulioC wrote:
> Jason Weathersby wrote on Mon, 28 March 2011 10:33
>> Can you post the report?
>>
>> Jason
>>
>> On 3/27/2011 10:00 AM, JulioC wrote:
>> > Hi all
>> > I'm new using BIRT
>> > So far I have setup a couple of simple reports
>> > Now I came across with a weird problem
>> > I have a new report, I defined the data source, created the data set
>> > Inside of the data set when I go to preview results I see the data
>> > I don't have any filter or parameter setup
>> > However when I go to preview in the layout tab, I only see just the
>> > first record
>> >
>> >
>> > What I'm doing wrong?
>> >
>> > I really appreciate your help
>> >
>> > Thanks
>> >
>> >
>> >
>
> Hi Jason
>
> You mean the rptdesing file? It has like 2000 lines ,I don't see where
> to attache it.
> Thanks for your reply back
> JulioC.
>
>
Re: Report Problem [message #662245 is a reply to message #662031] Tue, 29 March 2011 20:30 Go to previous messageGo to next message
JulioC Missing name is currently offline JulioC Missing name
Messages: 33
Registered: March 2011
Location: Ottawa, Canada
Member
Jason Weathersby wrote on Mon, 28 March 2011 19:30
Copy the xml and paste it into the reply or use the forums at
www.eclipse.org/forums

Jason

On 3/28/2011 4:08 PM, JulioC wrote:
> Jason Weathersby wrote on Mon, 28 March 2011 10:33
>> Can you post the report?
>>
>> Jason
>>
>> On 3/27/2011 10:00 AM, JulioC wrote:
>> > Hi all
>> > I'm new using BIRT
>> > So far I have setup a couple of simple reports
>> > Now I came across with a weird problem
>> > I have a new report, I defined the data source, created the data set
>> > Inside of the data set when I go to preview results I see the data
>> > I don't have any filter or parameter setup
>> > However when I go to preview in the layout tab, I only see just the
>> > first record
>> >
>> >
>> > What I'm doing wrong?
>> >
>> > I really appreciate your help
>> >
>> > Thanks
>> >
>> >
>> >
>
> Hi Jason
>
> You mean the rptdesing file? It has like 2000 lines ,I don't see where
> to attache it.
> Thanks for your reply back
> JulioC.
>
>


Hii
Here it is
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build &lt;2.6.2.v20110214-1523></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="523">
<list-property name="privateDriverProperties">
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">org.postgresql.Driver</property>
<property name="odaURL">jdbc:postgresql://stlqadb1:5432/stlreport</property>
<property name="odaUser">postgres</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Data Set" id="524">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">retailernumber</property>
<text-property name="displayName">retailernumber</text-property>
<text-property name="heading">retailernumber</text-property>
</structure>
<structure>
<property name="columnName">transactiontype</property>
<text-property name="displayName">transactiontype</text-property>
<text-property name="heading">transactiontype</text-property>
</structure>
<structure>
<property name="columnName">value</property>
<text-property name="displayName">value</text-property>
<text-property name="heading">value</text-property>
</structure>
<structure>
<property name="columnName">netvalue</property>
<text-property name="displayName">netvalue</text-property>
<text-property name="heading">netvalue</text-property>
</structure>
</list-property>
<list-property name="filter">
<structure>
<property name="operator">eq</property>
<expression name="expr" type="javascript">row["transactiontype"]</expression>
<simple-property-list name="value1">
<value>"BROUGHT FORWARD"</value>
</simple-property-list>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">retailernumber</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">transactiontype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">value</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">netvalue</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="rowFetchLimit">0</property>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">retailernumber</property>
<property name="nativeName">retailernumber</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">transactiontype</property>
<property name="nativeName">transactiontype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">value</property>
<property name="nativeName">value</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">netvalue</property>
<property name="nativeName">netvalue</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select retailernumber,transactiontype,value,netvalue from get_monthlystatement_excel(2011,02)]]></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/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>date</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>date</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>date</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>salesrep</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>salesrep</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>salesrep</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>retailernumber</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>retailernumber</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>retailernumber</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>businessname</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>businessname</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>businessname</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>referencenumber</design:name>
<design:position>5</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>referencenumber</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>referencenumber</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>retailername</design:name>
<design:position>6</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>retailername</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>retailername</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>gamename</design:name>
<design:position>7</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>gamename</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>gamename</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>transactiontype</design:name>
<design:position>8</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>transactiontype</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>transactiontype</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>value</design:name>
<design:position>9</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>value</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>value</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>commission</design:name>
<design:position>10</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>commission</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>commission</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>tax</design:name>
<design:position>11</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>tax</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>tax</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>commissiontax</design:name>
<design:position>12</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>commissiontax</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>commissiontax</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>netvalue</design:name>
<design:position>13</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>netvalue</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>netvalue</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<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="6">
<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>
<grid id="525">
<column id="526"/>
<column id="527"/>
<column id="528"/>
<column id="529"/>
<column id="552"/>
<row id="530">
<cell id="531">
<data id="558">
<property name="whiteSpace">nowrap</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">value</property>
<text-property name="displayName">value</text-property>
<expression name="expression" type="javascript">dataSetRow["value"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="resultSetColumn">value</property>
</data>
</cell>
<cell id="532">
<data id="559">
<property name="whiteSpace">nowrap</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">retailernumber</property>
<text-property name="displayName">retailernumber</text-property>
<expression name="expression" type="javascript">dataSetRow["retailernumber"]</expression >
<property name="dataType">integer</property>
</structure>
</list-property>
<property name="resultSetColumn">retailernumber</property>
</data>
</cell>
<cell id="533"/>
<cell id="534"/>
<cell id="549"/>
</row>
<row id="535">
<cell id="536"/>
<cell id="537"/>
<cell id="538"/>
<cell id="539"/>
<cell id="550"/>
</row>
<row id="540">
<cell id="541"/>
<cell id="542"/>
<cell id="543"/>
<cell id="544"/>
<cell id="551"/>
</row>
</grid>
</body>
</report>



Thanks again
Re: Report Problem [message #662404 is a reply to message #662245] Wed, 30 March 2011 14:46 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

The reason you are getting only one row is because you put the data
items in a grid which does not iterate rows. You have to use a table or
list, which can be embedded in a grid. See the modified example:

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.6.2.r262_v20110209 Build &lt;2.6.2.v20110214-1523></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="523">
<list-property name="privateDriverProperties">
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property
name="odaDriverClass">org.postgresql.Driver</property>
<property
name="odaURL">jdbc:postgresql://stlqadb1:5432/stlreport</property>
<property name="odaUser">postgres</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="524">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">retailernumber</property>
<text-property
name="displayName">retailernumber</text-property>
<text-property
name="heading">retailernumber</text-property>
</structure>
<structure>
<property name="columnName">transactiontype</property>
<text-property
name="displayName">transactiontype</text-property>
<text-property
name="heading">transactiontype</text-property>
</structure>
<structure>
<property name="columnName">value</property>
<text-property name="displayName">value</text-property>
<text-property name="heading">value</text-property>
</structure>
<structure>
<property name="columnName">netvalue</property>
<text-property
name="displayName">netvalue</text-property>
<text-property name="heading">netvalue</text-property>
</structure>
</list-property>
<list-property name="filter">
<structure>
<property name="operator">eq</property>
<expression name="expr"
type="javascript">row["transactiontype"]</expression>
<simple-property-list name="value1">
<value>"BROUGHT FORWARD"</value>
</simple-property-list>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">retailernumber</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">transactiontype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">value</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">netvalue</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="rowFetchLimit">0</property>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">retailernumber</property>
<property name="nativeName">retailernumber</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">transactiontype</property>
<property name="nativeName">transactiontype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">value</property>
<property name="nativeName">value</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">netvalue</property>
<property name="nativeName">netvalue</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select
retailernumber,transactiontype,value,netvalue from
get_monthlystatement_excel(2011,02)]]></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/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>date</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>date</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>date</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>salesrep</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>salesrep</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>salesrep</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>retailernumber</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>retailernumber</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>retailernumber</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>businessname</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>businessname</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>businessname</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>referencenumber</design:name>
<design:position>5</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>referencenumber</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>referencenumber</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>retailername</design:name>
<design:position>6</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>retailername</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>retailername</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>gamename</design:name>
<design:position>7</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>gamename</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>gamename</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>transactiontype</design:name>
<design:position>8</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>transactiontype</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>transactiontype</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>value</design:name>
<design:position>9</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>value</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>value</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>commission</design:name>
<design:position>10</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>commission</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>commission</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>tax</design:name>
<design:position>11</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>tax</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>tax</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>commissiontax</design:name>
<design:position>12</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>commissiontax</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>commissiontax</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>netvalue</design:name>
<design:position>13</design:position>
</design:identifier>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>netvalue</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>netvalue</design:label>
<design:formattingHints>
<design:displaySize>131089</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<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="6">
<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>
<grid id="525">
<column id="526"/>
<column id="527"/>
<column id="528"/>
<column id="529"/>
<column id="552"/>
<row id="530">
<cell id="531">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<table id="560">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">retailernumber</property>
<text-property
name="displayName">retailernumber</text-property>
<expression name="expression"
type="javascript">dataSetRow["retailernumber"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">transactiontype</property>
<text-property
name="displayName">transactiontype</text-property>
<expression name="expression"
type="javascript">dataSetRow["transactiontype"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">value</property>
<text-property
name="displayName">value</text-property>
<expression name="expression"
type="javascript">dataSetRow["value"]</expression>
<property
name="dataType">decimal</property>
</structure>
<structure>
<property name="name">netvalue</property>
<text-property
name="displayName">netvalue</text-property>
<expression name="expression"
type="javascript">dataSetRow["netvalue"]</expression>
<property
name="dataType">decimal</property>
</structure>
</list-property>
<column id="584"/>
<column id="585"/>
<column id="586"/>
<column id="587"/>
<header>
<row id="561">
<cell id="562">
<label id="563">
<text-property
name="text">retailernumber</text-property>
</label>
</cell>
<cell id="564">
<label id="565">
<text-property
name="text">transactiontype</text-property>
</label>
</cell>
<cell id="566">
<label id="567">
<text-property
name="text">value</text-property>
</label>
</cell>
<cell id="568">
<label id="569">
<text-property
name="text">netvalue</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="570">
<cell id="571">
<data id="572">
<property
name="whiteSpace">nowrap</property>
<property
name="resultSetColumn">retailernumber</property>
</data>
</cell>
<cell id="573">
<data id="574">
<property
name="whiteSpace">nowrap</property>
<property
name="resultSetColumn">transactiontype</property>
</data>
</cell>
<cell id="575">
<data id="576">
<property
name="whiteSpace">nowrap</property>
<property
name="resultSetColumn">value</property>
</data>
</cell>
<cell id="577">
<data id="578">
<property
name="whiteSpace">nowrap</property>
<property
name="resultSetColumn">netvalue</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="579">
<cell id="580"/>
<cell id="581"/>
<cell id="582"/>
<cell id="583"/>
</row>
</footer>
</table>
</cell>
<cell id="533"/>
<cell id="534"/>
<cell id="549"/>
</row>
<row id="535">
<cell id="536"/>
<cell id="537"/>
<cell id="538"/>
<cell id="539"/>
<cell id="550"/>
</row>
<row id="540">
<cell id="541"/>
<cell id="542"/>
<cell id="543"/>
<cell id="544"/>
<cell id="551"/>
</row>
</grid>
</body>
</report>


On 3/29/2011 4:30 PM, JulioC wrote:
> Jason Weathersby wrote on Mon, 28 March 2011 19:30
>> Copy the xml and paste it into the reply or use the forums at
>> www.eclipse.org/forums
>>
>> Jason
>>
>> On 3/28/2011 4:08 PM, JulioC wrote:
>> > Jason Weathersby wrote on Mon, 28 March 2011 10:33
>> >> Can you post the report?
>> >>
>> >> Jason
>> >>
>> >> On 3/27/2011 10:00 AM, JulioC wrote:
>> >> > Hi all
>> >> > I'm new using BIRT
>> >> > So far I have setup a couple of simple reports
>> >> > Now I came across with a weird problem
>> >> > I have a new report, I defined the data source, created the data set
>> >> > Inside of the data set when I go to preview results I see the data
>> >> > I don't have any filter or parameter setup
>> >> > However when I go to preview in the layout tab, I only see just the
>> >> > first record
>> >> >
>> >> >
>> >> > What I'm doing wrong?
>> >> >
>> >> > I really appreciate your help
>> >> >
>> >> > Thanks
>> >> >
>> >> >
>> >> >
>> >
>> > Hi Jason
>> >
>> > You mean the rptdesing file? It has like 2000 lines ,I don't see where
>> > to attache it.
>> > Thanks for your reply back
>> > JulioC.
>> >
>> >
>
>
> Hii Here it is
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.6.2.r262_v20110209 Build <2.6.2.v20110214-1523></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="523">
> <list-property name="privateDriverProperties">
> <ex-property>
> <name>disabledMetadataBidiFormatStr</name>
> </ex-property>
> <ex-property>
> <name>disabledContentBidiFormatStr</name>
> </ex-property>
> <ex-property>
> <name>contentBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> <ex-property>
> <name>metadataBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> </list-property>
> <property name="odaDriverClass">org.postgresql.Driver</property>
> <property
> name="odaURL">jdbc:postgresql://stlqadb1:5432/stlreport</property>
> <property name="odaUser">postgres</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="524">
> <property name="nullsOrdering">nulls lowest</property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">retailernumber</property>
> <text-property name="displayName">retailernumber</text-property>
> <text-property name="heading">retailernumber</text-property>
> </structure>
> <structure>
> <property name="columnName">transactiontype</property>
> <text-property name="displayName">transactiontype</text-property>
> <text-property name="heading">transactiontype</text-property>
> </structure>
> <structure>
> <property name="columnName">value</property>
> <text-property name="displayName">value</text-property>
> <text-property name="heading">value</text-property>
> </structure>
> <structure>
> <property name="columnName">netvalue</property>
> <text-property name="displayName">netvalue</text-property>
> <text-property name="heading">netvalue</text-property>
> </structure>
> </list-property>
> <list-property name="filter">
> <structure>
> <property name="operator">eq</property>
> <expression name="expr"
> type="javascript">row["transactiontype"]</expression>
> <simple-property-list name="value1">
> <value>"BROUGHT FORWARD"</value>
> </simple-property-list>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">retailernumber</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">transactiontype</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">value</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">netvalue</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="rowFetchLimit">0</property>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">retailernumber</property>
> <property name="nativeName">retailernumber</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">transactiontype</property>
> <property name="nativeName">transactiontype</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">value</property>
> <property name="nativeName">value</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">netvalue</property>
> <property name="nativeName">netvalue</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[select
> retailernumber,transactiontype,value,netvalue from
> get_monthlystatement_excel(2011,02)]]></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/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>2.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>date</design:name>
> <design:position>1</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2147483647</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>date</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>date</design:label>
> <design:formattingHints>
> <design:displaySize>2147483647</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>salesrep</design:name>
> <design:position>2</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2147483647</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>salesrep</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>salesrep</design:label>
> <design:formattingHints>
> <design:displaySize>2147483647</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>retailernumber</design:name>
> <design:position>3</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>retailernumber</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>retailernumber</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>businessname</design:name>
> <design:position>4</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2147483647</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>businessname</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>businessname</design:label>
> <design:formattingHints>
> <design:displaySize>2147483647</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>referencenumber</design:name>
> <design:position>5</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>referencenumber</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>referencenumber</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>retailername</design:name>
> <design:position>6</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2147483647</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>retailername</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>retailername</design:label>
> <design:formattingHints>
> <design:displaySize>2147483647</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>gamename</design:name>
> <design:position>7</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2147483647</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>gamename</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>gamename</design:label>
> <design:formattingHints>
> <design:displaySize>2147483647</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>transactiontype</design:name>
> <design:position>8</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2147483647</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>transactiontype</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>transactiontype</design:label>
> <design:formattingHints>
> <design:displaySize>2147483647</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>value</design:name>
> <design:position>9</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>value</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>value</design:label>
> <design:formattingHints>
> <design:displaySize>131089</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>commission</design:name>
> <design:position>10</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>commission</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>commission</design:label>
> <design:formattingHints>
> <design:displaySize>131089</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>tax</design:name>
> <design:position>11</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>tax</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>tax</design:label>
> <design:formattingHints>
> <design:displaySize>131089</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>commissiontax</design:name>
> <design:position>12</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>commissiontax</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>commissiontax</design:label>
> <design:formattingHints>
> <design:displaySize>131089</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>netvalue</design:name>
> <design:position>13</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints>
> <design:displayName>netvalue</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>netvalue</design:label>
> <design:formattingHints>
> <design:displaySize>131089</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> <design:criteria/>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="report" id="4">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <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&qu
Re: Report Problem [message #662509 is a reply to message #662404] Wed, 30 March 2011 21:07 Go to previous messageGo to next message
JulioC Missing name is currently offline JulioC Missing name
Messages: 33
Registered: March 2011
Location: Ottawa, Canada
Member
Hi Jason

Thanks a lot that worked.

Sorry for that , It was a silly mistake ..
Just learning, but still not an excuse...


Thanks again, you are the man.






Re: Report Problem [message #662514 is a reply to message #662509] Wed, 30 March 2011 21:28 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

No problem. Glad I could help.

Jason

On 3/30/2011 5:07 PM, JulioC wrote:
> Hi Jason
>
> Thanks a lot that worked.
>
> Sorry for that , It was a silly mistake ..
> Just learning, but still not an excuse...
>
>
> Thanks again, you are the man.
>
>
>
>
>
>
>
Previous Topic:Speed issues & profiling
Next Topic:How to decode column value ?
Goto Forum:
  


Current Time: Sat Oct 25 17:03:32 GMT 2014

Powered by FUDForum. Page generated in 0.08584 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software