Eclipse Community Forums: BIRT » Pass in outer row in Crosstab?

Help

Home

Home » Archived » BIRT » Pass in outer row in Crosstab?

Show: Today's Messages :: Show Polls :: Message Navigator

Pass in outer row in Crosstab? [message #498269]

Mon, 16 November 2009 09:35

Tobias

Messages: 9
Registered: November 2009

Junior Member

Hi,

on normal tables you can pass in data from an outer container into the dataset of a table with the "Dataset Parameter Binding" option in the bindingstab.

Is there any way to do the same on crosstabs (scripts or maybe some kind of trick)? I have a table and in the detail of the table is a crosstab that has a cube based on a joined dataset with a parameter. I need to pass in data from the table into the joined dataset of the cube...

Any ideas? Any possibilitites to do that?

Best regards
Tobias

Report message to a moderator

Re: Pass in outer row in Crosstab? [message #498434 is a reply to message #498269]

Mon, 16 November 2009 21:43

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Tobias,

I did this using a filter on the crosstab.

Take a look at the attached example and look the xtab filter.

Jason

<?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 <2.5.1.v20090917-1447></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 <<Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<list-property name="userProperties">
<structure>
<property name="name">salesbydate.dsOrders.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">salesbydate.dsOrders.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property
name="name">salesbydate.ProductGroup.NewTabularHierarchy.x </property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property
name="name">salesbydate.ProductGroup.NewTabularHierarchy.y </property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">salesbydate.dsOrders.width</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">salesbydate.dsOrders.height</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Data Cube.dsOrders.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Data Cube.dsOrders.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Data Cube.dsOrders.width</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Data Cube.dsOrders.height</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Data
Cube.Group.NewTabularHierarchy4.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Data
Cube.Group.NewTabularHierarchy4.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
</list-property>
<property name="salesbydate.dsOrders.x">251</property>
<property name="salesbydate.dsOrders.y">47</property>
<property
name="salesbydate.ProductGroup.NewTabularHierarchy.x">39</property >
<property
name="salesbydate.ProductGroup.NewTabularHierarchy.y">69</property >
<property name="salesbydate.dsOrders.width">150</property>
<property name="salesbydate.dsOrders.height">200</property>
<property name="Data Cube.dsOrders.x">335</property>
<property name="Data Cube.dsOrders.y">17</property>
<property name="Data Cube.dsOrders.width">150</property>
<property name="Data Cube.dsOrders.height">200</property>
<property name="Data Cube.Group.NewTabularHierarchy4.x">29</property>
<property name="Data Cube.Group.NewTabularHierarchy4.y">143</property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
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="dsOrders" id="9">
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERNUMBER</property>
<text-property
name="displayName">ORDERNUMBER</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTCODE</property>
<text-property
name="displayName">PRODUCTCODE</text-property>
</structure>
<structure>
<property name="columnName">QUANTITYORDERED</property>
<text-property
name="displayName">QUANTITYORDERED</text-property>
</structure>
<structure>
<property name="columnName">PRICEEACH</property>
<text-property
name="displayName">PRICEEACH</text-property>
</structure>
<structure>
<property name="columnName">ORDERLINENUMBER</property>
<text-property
name="displayName">ORDERLINENUMBER</text-property>
</structure>
<structure>
<property name="columnName">ORDERNUMBER_6</property>
<text-property
name="displayName">ORDERNUMBER</text-property>
</structure>
<structure>
<property name="columnName">ORDERDATE</property>
<text-property
name="displayName">ORDERDATE</text-property>
</structure>
<structure>
<property name="columnName">REQUIREDDATE</property>
<text-property
name="displayName">REQUIREDDATE</text-property>
</structure>
<structure>
<property name="columnName">SHIPPEDDATE</property>
<text-property
name="displayName">SHIPPEDDATE</text-property>
</structure>
<structure>
<property name="columnName">STATUS</property>
<text-property
name="displayName">STATUS</text-property>
</structure>
<structure>
<property name="columnName">COMMENTS</property>
<text-property
name="displayName">COMMENTS</text-property>
</structure>
<structure>
<property name="columnName">CUSTOMERNUMBER</property>
<text-property
name="displayName">CUSTOMERNUMBER</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ORDERNUMBER_6</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">REQUIREDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">STATUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COMMENTS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</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">2</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">3</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">4</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">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ORDERNUMBER_6</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">REQUIREDDATE</property>
<property name="nativeName">REQUIREDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">SHIPPEDDATE</property>
<property name="nativeName">SHIPPEDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COMMENTS</property>
<property name="nativeName">COMMENTS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.ORDERS
where CLASSICMODELS.ORDERS.ORDERNUMBER =
CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
]]></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>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTCODE</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTCODE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTCODE</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QUANTITYORDERED</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>QUANTITYORDERED</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYORDERED</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRICEEACH</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRICEEACH</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRICEEACH</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERLINENUMBER</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>5</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERLINENUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERLINENUMBER</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERNUMBER</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERDATE</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERDATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERDATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>REQUIREDDATE</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>REQUIREDDATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>REQUIREDDATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SHIPPEDDATE</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SHIPPEDDATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SHIPPEDDATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STATUS</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STATUS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATUS</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>COMMENTS</design:name>
<design:position>11</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32700</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>COMMENTS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>COMMENTS</design:label>
<design:formattingHints>
<design:displaySize>32700</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERNUMBER</design:name>
<design:position>12</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CUSTOMERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="products" id="10">
<list-property name="columnHints">
<structure>
<property name="columnName">PRODUCTCODE</property>
<text-property
name="displayName">PRODUCTCODE</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTNAME</property>
<text-property
name="displayName">PRODUCTNAME</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTLINE</property>
<text-property
name="displayName">PRODUCTLINE</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTSCALE</property>
<text-property
name="displayName">PRODUCTSCALE</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTVENDOR</property>
<text-property
name="displayName">PRODUCTVENDOR</text-property>
</structure>
<structure>
<property
name="columnName">PRODUCTDESCRIPTION</property>
<text-property
name="displayName">PRODUCTDESCRIPTION</text-property>
</structure>
<structure>
<property name="columnName">QUANTITYINSTOCK</property>
<text-property
name="displayName">QUANTITYINSTOCK</text-property>
</structure>
<structure>
<property name="columnName">BUYPRICE</property>
<text-property
name="displayName">BUYPRICE</text-property>
</structure>
<structure>
<property name="columnName">MSRP</property>
<text-property name="displayName">MSRP</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCTSCALE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRODUCTVENDOR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">PRODUCTDESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">QUANTITYINSTOCK</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">BUYPRICE</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MSRP</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</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">2</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">3</property>
<property name="name">PRODUCTLINE</property>
<property name="nativeName">PRODUCTLINE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCTSCALE</property>
<property name="nativeName">PRODUCTSCALE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRODUCTVENDOR</property>
<property name="nativeName">PRODUCTVENDOR</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">PRODUCTDESCRIPTION</property>
<property
name="nativeName">PRODUCTDESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">QUANTITYINSTOCK</property>
<property name="nativeName">QUANTITYINSTOCK</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">BUYPRICE</property>
<property name="nativeName">BUYPRICE</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MSRP</property>
<property name="nativeName">MSRP</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from CLASSICMODELS.PRODUCTS]]></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>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTCODE</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTCODE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTCODE</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTNAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>70</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTNAME</design:label>
<design:formattingHints>
<design:displaySize>70</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTLINE</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>PRODUCTLINE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTLINE</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTSCALE</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTSCALE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTSCALE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTVENDOR</design:name>
<design:position>5</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>PRODUCTVENDOR</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTVENDOR</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTDESCRIPTION</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32700</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTDESCRIPTION</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTDESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>32700</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QUANTITYINSTOCK</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>QUANTITYINSTOCK</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYINSTOCK</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BUYPRICE</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>BUYPRICE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BUYPRICE</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>MSRP</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>MSRP</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>MSRP</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="outer" id="528">
<list-property name="columnHints">
<structure>
<property name="columnName">STATUS</property>
<text-property
name="displayName">STATUS</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATUS</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">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select distinct status
from orders]]></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>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STATUS</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STATUS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageH

Report message to a moderator

Re: Pass in outer row in Crosstab? [message #498469 is a reply to message #498269]

Tue, 17 November 2009 07:47

Tobias

Messages: 9
Registered: November 2009

Junior Member

Hi Jason,

thanks for taking the time to answer. The XML-struncture of your example looks rather incomplete, perhaps you could zip your report design and attach that zip file.

Kind regards
Tobias

Report message to a moderator

Re: Pass in outer row in Crosstab? [message #498604 is a reply to message #498469]

Tue, 17 November 2009 16:17

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

This is a multi-part message in MIME format.
--------------020800070403040707020905
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Tobias,

It looks all there to me.

I am attaching zip as well.

Jason

Tobias wrote:
> Hi Jason,
>
> thanks for taking the time to answer. The XML-struncture of your example
> looks rather incomplete, perhaps you could zip your report design and
> attach that zip file.
>
> Kind regards
> Tobias

--------------020800070403040707020905
Content-Type: application/x-zip-compressed;
name="xtabtable.zip"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="xtabtable.zip"

UEsDBBQAAAAIAAlacTs4BI6UzhkAAKleAQATAAAAeHRhYnRhYmxlLnJwdGRl c2lnbu1de3Pb
OJL/P1X3HXS6qqvdq7Mefso5RVO2rGx8G9sZP7I1lZpK0RJsc4ciNSQVx/vp Fw8+QLBJACRt
URJxddmxyG40fkA3GkCjOfzl59xq/UCuZzr2h3a/02u3kD11Zqb9+KF9d/tx Z9D+ZfRu6KKF
4/ot/LLtfWg/+f7ifbf7/PzcQVPLXHio47iP3XvT9bu7vd5Bd4Y889Fux4z3 OrudXczbnOFK
2qN3LVyGC9dZINd/adnGHH1oT11k+Gh2+tIeTRjX1un59W3rjDJDbusr49ba 7Rx0+p0fuKZj
/H97rdOlac1a/235/5d40j/a6e/vH42G3bAiuN6lbfpee2TashenznyObPLu 2Fm8uObjk9/6
y/SvLVzdEa2e/P9vztJtjZ35wrBfWpeYrvWEXDRKS/Hkz60doQaM29Q1Fz5u Ja6E4uG1jNa9
Zdh/tII+eDb9p5bttBYumqEH00az1tSxfSxYZ9hNMA0qskzPFytaesj9wn4y kRd0CH3b893l
1F9ikaPfICzIv+2RZ1jIu3+ZYTk7M+/KneEe6vwUm5rFw39ZIIK7jx6Rq0pk el9Nz7y3MOWD
YXkIoht2gVZU0LKXTWsZHgIzTPk311kuOpfo+da4X1qG+8lEruFOn142ry+l Ld64Po5G77M5
8582tnVPiNjjTWjemeEbrfHyftNMKtCujVA2oF0bo2pA2zZR0TKng/1NU72c ltZQGYfdhPMa
/Chwhp3Q9mj3oC9WokSK1x/7RzqUX6ReVHu0d1wpRyzjoRbHpGlqj/oHvULk TPsxuD0pPTSP
YSD2DgoQ4vb2pX2SZYiVWptp6TTbmmdKMCtpp6mpKm7S/l6KlY9+plZ6M9Nb WMbLJbUDp3Qh
eU0XksNu4nVYGhMvLT+aRGnx23PMCC9Iu3Q5+p0tRzuP5oOsSbh6Z+l/cdED XgnbU8zMWPpO
i/2cIsbjzdjx8Cp6ijzONDgzY4d71MKyI5tsB5yffWg77mO0E0F2ITqBcISg gyk7/5zdT9s8
wjeUC9uQOOTWv5D8mMGZa/5A7tgyPLxYltbmGRgqNLvvMDJVE4lJ764/t0dE 2PdTUpc5nTsz
ZHnvQ446rPASvz0aMzYXlA1scwVkQ8ub7oega5AP9wvyC3RK5//xPzfIQlOf 9MsN8sNuCtWQ
9dGx2EfQrsbUsZZz+5NJ92gSr1OSjCkzeg5yY4pzdX02ub68uzidXGd1QcRG qoUJZoASJrhB
k3/0sESLvlxfnd2Nb8dXZ5PyLUowW1WLfr07ubw9v/2Nwjs5K9+qFMPV9dX5 eDI5GX+qoqci
VqtqDYXz8/nlpFJ94hmutGVMiO+HG2InqBBnJ7cVWAmO1apacz359e4c63I1 DUpyW1Wbbj6d
f/lSVZMSzFbWotuT27ubChoT8FlVO8ZXFxeTy9sKWhJzWllb7m5ury6qc4JE fkXbBW4RRA8h
L3FhuPh/feJalofIpo2hLL+nthvkxD5eHzA8dGmJF31LN2KwxKb9WKzus4hL f1eXw8LxTHZS
KW84+rlwkUdPbwPx0YOxtPyvhrXEqzCyo0SGm+35ho1X3GMDLxMtvOAZdmNK NalM74qenxpW
e4S7EtxnyqM3LMt5vlxaBclN79xeLP2ixFdLn1JnbpFFpMX0ISIKNdyYPqHZ BfINMhIgfYA0
CHcI7juyVstol0SJ6DvFRxNEzvRQY5kGMYl1SrK5GTHIs7b0hVJISFUSImdI aCzvICba1uV1
gUhtdamQMyA0V4UQo7oNi/0yw0JxJQmxiHF4sBwj8wgoIn9dFFLbyCrknJlQ X4FCjOo2JqTL
TYg8ZTTlq1aITd2wSB0UqJBzWKispCAWMQ7kzGTFIAyKg6CzSIa41AqH1IGL CjnDQWNhDTGp
FQz91BGWCn2Ag9JyHKKvmRvRL+Faqq7lIQ51g6GEX6m3DQDxqXa2yF/uZC6S AJmCE8ERdzyY
JZn2okh3V0FnaQ12k855VYpBvClRgo1+N4NyxBsUuV5vpdteGgswGH2ds7Uc 9EuwedvdoVdC
X7rqg9HXPQfM6YGSrDZCB6SrzSwdUD2zzNWAgkx0l6oS3HOd6VfCXbq+zbH8 GqerOeiXZFX5
6M9F5JV6QX6Mm90LyifBsj7Y4hlYupbPwV/pRFSGfREmmis/CezHuT7gK+Eu 3T6Acdc6X8+B
vgyfDUBfumkBo68TCZADfgk2G4C9fKckA3y1oIU83Atx2AhXX74zA4OuHGGR A3tRHpsBfMEl
rmY4SB78pTjVxMnJ34b6mb7p/ecSuS+36KffHg3/89sY29qTbx4Ng279z7sH 15m3xp9Pbm7O
xxd49f/5psN8kcntyfnnm/+Fnt28eyYXzcFHHc6LbH14l82Zf/GdYc9azCR9 +OXd77+Pht2f
qcvleU2cBff2aYyHx7VzqJR04D/eDWnw+3t2/59xYRkI3jPWmYkIyKDwHcfy ulPHtjGm5g/T
fyGB7lFmAsaHVpCfz4AFrXfpm11jZix85BJONKK+jaXEjQ8SE4xwS4bd8A/6 hFX3ngyvG+R/
iSKP6NP4eRSSdEZu9FPVDF+JXzLtq6VPqh2d28Nu6kfxdcPHVul+6aOYU/yQ 9NAoYkL/Sr8U
WgmyCSn+BLHkFWlMRCLGJfspUKGLpiZD8iCuMvoxTeBNDQuNetG77G9AtqVl GfemhUfB6JL+
t4Vi0biHEYjhQwDFuD8WS/8kD2WszyRhBPhO/JYTxCsFIUPirxzbrpQvNy4g 4WJQswZc9AY8
ZEOZr8PNbq81Q+SSSxRD9KFNmtEWBni0OZ43wKOXxjTuEEKUvcKeQ6z4d0EF 4F+gwz6xwIb1
gadR04lkLamRv6+mFol6Y9WIhzukGjyRTD0SYuqqSJJ8adJrN8LT+DkX+wlC zj8XaujmVJGn
p3z1S894RJCE4Qu4ecgCJWNPYKoHx53jmvG8pdT6G/NfiLq6wM8Zjc6rIUYG al30VK4zr6dd
iSMMDe2KJw597VKddRIVq848PFFN1QvCvB7qBUlWuXodiI3eYPVKnU9pqNhe M4Hx5DoalgV7
PbQsS7pmIiuhadxJpIaOxXqir2ODbZ/FRMDrMoeJclWtV7u7YpM3WK9SZ8wa 2sWNcW3tOuBq
0tautVeuLNRrtAoDpKta0Q63Tc8K6FiMUeMlFlGyZptja7SLnZdr6NZRCd06 7nNVbatyJRCv
kWol5KpcsXpikzdYsZJxQBq6Fa+eGt3S1S0Q9HqoFyhao2ElNCwR7KWhYMeN giXIdRQMwrwe
+gVJ1qhXGfUKYvo0NIsf383hl65qJfGuiVYlhapcobbpyCuO1tRRqTLRGuVU am/3qLf2E1YK
9HroVUqsqjUr2XlboFxCLK6OipUJ2djyncIM2GuiZLBwG79fKLyYCktMP8+M pYyjJfHvw246
rHmUE17NJ+hGPvf7q2XeXrCvDwSZt/u91abe3rxE1YEQlycX1bWIMVtxi8iZ XWUtYsxW3KKb
8cnn6poUcFtxm75OLs+u5BdtVBsVsltxq84mN+Pr8y+351eXlTUtwXNV7QvD uc4v8Tw8/nv5
xqUYrqplp3e/0Wia8k2KOa2qLRc311/Kt4NxeZ1UyBFRKP1mpX7drISn0luZ EHkCCBXvAmJS
MyBKZH7VcEogJjUDolTSV3VfBuJSMyRKJH7V8oAgNjWDokTWV323CeJVMzxK ZH7VdLMgRjEY
Zi3y4JZIAavqmkEcYhjqkCa6RP5XFZ8Ooq4SgCa/ZZ71ajIs0oeF0S+Y/ENn A0uOfhE2G4F+
wfyWOpttcvSLsNkI9AvntdTYGJTDX4jPRuBfML+l3iamvAOKMdqIHiiY27LA hqu8G0pw24i+
KJjnUndzOKcjSrLSX/xIumEV2UYLZr1U3sjOgb8oD93FhgT1VWQ6LpjtUmnL PQfxIvS1QPvV
k82FvsnbJ31bi5xvGAQ45Rt5kAr5yEqQRaEc5sWQBGCn3gnjUKLOkAWEcb0G xIMl+zQMcMK9
mVwe8w9AkjgULB0JllGHZqwlXG1+9DJIA8eBwUKqhoGB1GF8lqDcUBAYBDb/ XDAB2RVA8V/A
COCio0DRLUnKHpBIjMvKb3de9DLc3Bz+UNjXu9RDqYq8si6xzQ51XQKiKt9E l46goMp106UE
2LXRpYRU1eoS12tboEts60pdl4CMV2+iSweboEsJsGujSwmpqtWlg63SpWAf Ul2ZgNRWb6JM
YLT/uilTEu3aaFNSrIrdvK1Sp3BXWV2fgGRWb6JPGzE5CXDXRqEEuZoJKvmq jkYlDgjU1QrI
X/UmapV17XPdNAuCvTbqBQlXrY5lXwDdNDVLHf+o6xiQx0pVx3IvfkpUbL09 wSy8V69cWZJV
7A/C9z03Ta3iYz11fQJyV6nqU27SYJk+rfX2eQro1StSSqRqNSgjT/CmaRA7 plXXHiAxVaM9
0GNeQRIgr15zEuJssNYI74lnu+nHAo/oBS7DwBokGHDw6HBZdoGD3cFq0wso fnRTenUz5NNc
3swEESK3NToBoo8DchSD/5rLFtqBVlv+Zdsqw62wycCzCf4Pzzf8pceCrxx3 hlyvCbba7mAr
KFMk+HYTZ5Wm1nB1czJECmqfzbtSZxfMDgm+v+7RVbV1d4fd8O9QlOnynu/T oW/cLy3D3SG/
B9aXzu1j/DfzZPcPD0VPNuUvzpkLDfqwYQ3RWwHVFZkdcF3ob66zXIR1HWW5 cEKdpneL+bH5
z6ffl9Wcg9GDgaH+ZCLXcKdPL+3RJXq+ZaJGP2pfI3wKKE0EQRFRhZCEr4fk kAghMOJyIsVU
EMVCP5CVJ0VEGEpDKQLqF2S4Yc3HCkxIKX1zQiwAQ0R6/TMRlHEmcmqzhRzT 2OAptpYUlXUF
VGB39Cxonm57wpKNPwFuxy/IWnqPXSy5fmVWyVvKct+eUGeKV6z8uC6oB38u DTda0+8fiSkD
s8oqVCEQtdEGVhptSDDU0Qal/YpuahLLmCJzl6Yp50DDgbh5Mhei/3DUr5P/ oH0Rvnr/YS8E
ZndV/sPRXuM/ZJTGYkKlcouZ+PjHij2I/caDyC6NPkBlLfVhTXyIhO+QtdAt NPdrp2Gpfu7f
Dxo2kC1bqp37uSssoQBZXplYslVO7aRELHlaoJEnKMGyklmBu34aYiRz0MKy AoxUk89GLKu2
FPQ9oN30IHERpPVfl2ULPSFjvX54qLpeUbI5qzc5YbPedrXBThrCusuvN6pX JPVAgIjbes62
WcQiOHNkeNgDovNv7rFB8OLOI3kz7O/lfG64L62PJrJm/SDgpnegqEoBR6Uh H7wbUIYRxHQL
ZnIW1SwekKTYoZ8LXCFnBAK+k+h36lQSe3btPH8TK2r/PuzGLPTNpPbCIe7m QNAyIyXRg8VG
S2TrZx49Nsq09eBaJBqqY8eesVM3aMTJwk8g1v90zHyuEbWi058yIst79Hf0 UmgqzjL3L0UY
ytPZqixTMkXS96H141riIUlQZb8Pu9yJKO6kFytxPEp/CLvCdTwPc9iZIssK vDahx8Xm3dMQ
mFPH95352LEctz36rzEtqiOf53BDhMGzk2OZsyL0/zBn/lN71F9k5neCqT+j B7+M9IS+uOyE
uqjk1+bjUynRKYPislPyosLfOosyomPy4oJj4nyxifa98DEvoKoEE2SjJY2W yMi3UEvwjMfq
ZnOJbDKZBs3s4fLxo351M+QbZjBx9QfiKinVQmP6B/HY7FkI7+nJ+GSSGRIj 0j84tv/RmJsW
ntrbJ65pWG0dUhLNhftkbliWKtnCmJE4UNwp7VFv8VOTjChQETpmNIpQ0mGf SZjfl0/IwOPv
wXGio4X+QOqMpHq019vvDXr17VFC9g/EYLp3LGXtDDXlIy366NKVCoM4BFc6 hwHgDjLUFKLf
HnB9EgG7ww/dvX0x6k+O7mAwxjasCLqeYXs7HnLNh5oDfHxwvHcEZhNXAZgf vnv7qctIDcBl
Aean07198exIDvB4MOkdZybKfS2Af+5oQSyHCqKCHPpJ72xyukqH3n8ybT1y 3qMvIn5lHr2+
6AmXvojsFbr0+tJzPn0R2Svy6bPkVvAd+knze5D61LTUOkzGk9MzZYVbS/Pb o6WMTcl2QWQc
amFTiohfF5tSRPa62JQistfBpiR85gPx5FjBpmjZ0q31mcNjvVSsnhzhw97R 4HQr13wQ1TZt
yPCr2mgA6W8aNANouwcQW1RGA0h28xKw8YeT8RvvOmkuKatwG9U3LbdvCFFn IZjKdqKRVGCH
rXesoaqNKcojW99xxGa0eBwV2EhsxtGWjiNvgaa4AxN7IQepKHv5CFqBUzRH M3M5b4bQqodQ
FHPF77YfpC40yMdQ4xc1gyhpiFKXUmppiJqprBZDaP5CQpDDkbOrFqnjuIb9 CN4RTFQW/BHG
oC6MR0Qy9vCx0kPPnC+wTzY3POKNkVeCqm7og9YFffAF/85klEnoO4sLw300 SfI89Z1UC/dZ
RNbZPdDZgyW9VqBKl3Saap0EOeawJp/QpySBJds6VbwnMMXahGyfBc8/+fNM NYwYQMk0Ay58
ErsfJJfTjvMwstFzi9xS/ctfh93oR5riSZptk7wgNL8Lth+PrtTYCcedONSG 986MH6V0IcBu
1RzLHP9yIfr3xMxiKIwxS5xVJD5fYEn+DbJlXN5dnE7k30KX5kJNMJN0EeWY uveBMi58cJxV
LntA4Ctf8shPFVoIZY27BHKUE8wqRZm/dVkKZfkFsVcAWbgUVB7oFMNKwS5w h6l+w/p8PJmc
jD9VMagjVhUP6YBvOXylX/1+BXTpwCDXrys1zzzD6k10zH0dxzM3y3w/XJPp 8Pvh2iKtkmBD
EWXGqnqMCd9y+JJcKG8M7vXk17vza7UEJnJ8k9wqhZhnvXYoa2SJUfiKAM+s Uow5zusH8dt+
o4EyUweWJVVYPz95fHVxMbm8rQDXmFOlyIZs1xHbu5vbq4vqVtQiv2pxTjBf nRuR/6GFKd3x
oLssR4e77a7wmO1ZA7W5znOwNZOZt4pcVGeMe3kpoIY0NXvwoixVE9inPv0o hK4/SNl1gbzw
8UPSAghp3HgRYwioIcsaQlsGpt4TO5y+z4Ymy0dgsRQluV8YEZmQseL+MKz2 yHbs/DlFoPQc
1z8zXfLhCTKYDW+aS53ShD/QywT/1h656hY8NgRhZzrTrAGVo3o0Qb1exbnm SUDGRQtk+J/Y
AY40Y6tI/WTO0Bk7QRw9GJanRUx2SU9dZPxx8kDCb0fG0ncK0Z+iB8dFJRic 2x5uiAKDLKNB
H4aG4ygVn5h4LTYeqTC01LvETtJ3B1L7Qd9PdW7iswm66ZLYVw7ybAxsRtiz lClhP2fa3awD
BvowwnaQl6+fw3Ygy66Pdc5H9gzNdkwfzePPlV1S5MZRooXowdfw6zi7nQPy fRzWLeKBEFiV
0C0KiZL4ki/pBWP21UTPgUx7qlkBScmQLbWJqfSxLrGkpv3AVCgzICW/+SeP jy56NIhdH0fp
YwZ7Kt0iFlFaI2Z9ZWPHB6sPTTHX1U86JpbcqiJl5fNwdwsmkeWLWGt0hKbN iRTOOO2ppoaD
itRoiSPxe6IbvlcOEyky05dVitZLZnRulGuoWAVqGYRvVKmWof3kdRLyE2Wl 4iEbO+SDvbxJ
WlZynPW03VT02PNKrjefV2o/HrUr0qkgZVqc52om3XB4c7NuX/VzPqSIgv3A fHQSepOSL+FZ
mJuPE3FX9TMrfEnN4SHj9oha3ConJOVspVDJx4OmY2dYsLrwMpT+1iI/7ocI 6bhOYgFbE6DU
LZgVOauk3bb5vbYJF4u2Sd8t4maJpVoTLxbmpTDOqQTag90yjotYpI5MxWOA L0X9FbFUJVfh
+UMs5R25CgQpY1oOwqFWxP0Ji4pp0U0mnlVqYlrKuGdheXPTEuedH+zKNnd0 iqppqWoM8KUx
LRmltCBv7pyTUsBtzPp2aF7JcRvZ8n0j/MbDECLZV0TzSoZxr2yzKSxiPQ+m 5Zc37IzLzjRM
1r2DLIS72i/HlhT4VIQdReoco+sUESPyh+GTSwfozyoNa3jxIOS4Q04yw8Ug OfEpsxDhCwuK
p5h1vjtL3FU8dOxhBaYdak5ZM1/9yNog90hntyGrvJ17xH9IZLBXZBsiq1R8 5KVaGqcoo6yf
U1TrHctp5rUdqGhvWvZ0FqWr2bTM/PxMXsnxPuklqui8aCO80BCpMivODCc0 iVa3yGddoVKP
SbRXZGEjlrebRONv/w56ZdYbYpFOoVX1Ol+aCTSjrHzDsh+OsTIuppo5qeiw npR6WJR+Fa7t
21mUxDeUB/2q1pykSI1KhX3Pl8auZJRt2a3sVxH6xe9W8uFFG+Eu7oZIVRm1 FW5aJoKxNstd
7Jc5wQvL27qL4Vzer+I0LSxK/uL3QgGjeaWx7Bll5R7jXjjKXmEB+irRnaTU xKas1xI0wD8y
K2+6DA0qbyyLcmk2c2XlTTdzteKs9Xez9sQ7jiDbMpvRy3vUHp0RczDG/6nF qmByKqjIbthC
RWwK+bf4xpbkqmy4ePjWTu53tH//xjbxCh5ap1YpOrdooZJ7UxAq1UFfYiYv gX644dF0QAkn
XRn/hO/WDP7U4H9r+JvRH/VAyVBs5T6IsOdjzyvHX56yAiqrh79ouGph+FUz FEJlg+AvHhOj
bnxo9CKBvlyg3gah/lb3WPP7KLjgncoj2a/NtEBKXnxkeFkaXdm60Scs3lGI rC0QBBkygrtM
k2HZ6EmxAyJ8Pi7tIOHJzd3FqypKbiae9MuKa+5C+SWgNBLDLs0/I/zIshEA PKJkE5l3drhE
E7kXVeI78kfS+yDS/S+NlMuUX86ullYCIAinzGwdMXipTzdHr8TgHfSgPQtQ inT+bZpFm/0w
7LIM25gSLRwXK8+/AVBLAQIUABQAAAAIAAlacTs4BI6UzhkAAKleAQATAAAA AAAAAAEAIAAA
AAAAAAB4dGFidGFibGUucnB0ZGVzaWduUEsFBgAAAAABAAEAQQAAAP8ZAAAA AA==
--------------020800070403040707020905--

Report message to a moderator

Re: Pass in outer row in Crosstab? [message #499058 is a reply to message #498604]

Thu, 19 November 2009 16:07

Tobias

Messages: 9
Registered: November 2009

Junior Member

Thanks for the example, but in my case such a Filter won't work... too
bad. So I actually need a way to pass in a parameter into the datasets
used by a datacube.

Is there anything possible with scripting? Can I set the dataset
parameter values in a script on a cube or anything like that?

Tobias

Jason Weathersby wrote:
> Tobias,
>
> It looks all there to me.
>
> I am attaching zip as well.
>
> Jason
>
> Tobias wrote:
>> Hi Jason,
>>
>> thanks for taking the time to answer. The XML-struncture of your
>> example looks rather incomplete, perhaps you could zip your report
>> design and attach that zip file.
>>
>> Kind regards
>> Tobias

Report message to a moderator

Re: Pass in outer row in Crosstab? [message #499072 is a reply to message #499058]

Thu, 19 November 2009 17:44

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Tobias,

I do not think this is possible currently. The cube is created at the
beginning of the report I believe.

Jason

Tobias wrote:
> Thanks for the example, but in my case such a Filter won't work... too
> bad. So I actually need a way to pass in a parameter into the datasets
> used by a datacube.
>
> Is there anything possible with scripting? Can I set the dataset
> parameter values in a script on a cube or anything like that?
>
> Tobias
>
> Jason Weathersby wrote:
>> Tobias,
>>
>> It looks all there to me.
>>
>> I am attaching zip as well.
>>
>> Jason
>>
>> Tobias wrote:
>>> Hi Jason,
>>>
>>> thanks for taking the time to answer. The XML-struncture of your
>>> example looks rather incomplete, perhaps you could zip your report
>>> design and attach that zip file.
>>>
>>> Kind regards
>>> Tobias

Report message to a moderator

Previous Topic:	Web Viewer ClassCastException
Next Topic:	BIRT with Word 2002 compatibilty modee

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:19:02 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter