Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Grouped Crosstab Report
Grouped Crosstab Report [message #254694] Fri, 07 September 2007 02:07 Go to next message
Eclipse UserFriend
Originally posted by: agar_janna.hotmail.com

Hello,

I am new comer to BIRT and exploring different reporting options. I am
struck while I wanted to create a grouped cross tab report, though. I
created a plain crosstab report. My requirement is as follows

Let us say I have 2 groups
Group 1 = Company Name and Group 2 = Country Name

I need the following output.

Company 1
Country 1
Crosstab Report Filtered for Company 1 and Country 1
Company 2
Country 2
Crosstab Report Filtered for Company 2 and Country 2
and so on..

I tried by first creating a group report with Group 1 and 2 and inserting
Crosstab Report in detail section of this report. Though it works I do not
know how to filter this data for the group combination.

Any help on this is much appreciated..

Regards,
Janna
Re: Grouped Crosstab Report [message #254698 is a reply to message #254694] Fri, 07 September 2007 03:12 Go to previous messageGo to next message
Eclipse UserFriend
You can add a table or list, and group on the company and country, add
your cross table in detail, and set the filter as country equal to
data._outer["COUNTRY"].

But now has a bug on https://bugs.eclipse.org/bugs/show_bug.cgi?id=188532,
data._outer can not be used now.
Re: Grouped Crosstab Report [message #254726 is a reply to message #254698] Fri, 07 September 2007 07:37 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: agar_janna.hotmail.com

Sure,

I think the crosstab has to come in the footer for the country group.

Where do I need to describe the filter?

1. Inside Cube definition for Cross Tab Report
2. Inside dataset definition for crosstab?

Please let me know..

Thanks,
Janna

"Sure" <ysun@actuate.com> wrote in message
news:41fe8cd4c3301fa7266448e44d49a164$1@www.eclipse.org...
> You can add a table or list, and group on the company and country, add
> your cross table in detail, and set the filter as country equal to
> data._outer["COUNTRY"].
>
> But now has a bug on https://bugs.eclipse.org/bugs/show_bug.cgi?id=188532,
> data._outer can not be used now.
>
Re: Grouped Crosstab Report [message #254959 is a reply to message #254726] Mon, 10 September 2007 20:52 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: fachinet.osb.pf

Hi,
I've got the same issue.
Any help on how to make grouped crosstab ?

Thanks.

Fred
Re: Grouped Crosstab Report [message #255788 is a reply to message #254694] Wed, 19 September 2007 04:19 Go to previous messageGo to next message
Eclipse UserFriend
The filter can be set on the cross tab that in table detail row.

And the xml of table is( Only a sample ):

<table id="14">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">OFFICECODE</property>
<expression
name="expression">dataSetRow["OFFICECODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">TERRITORY</property>
<expression
name="expression">dataSetRow["TERRITORY"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="21"/>
<header>
<row id="15">
<cell id="16"/>
</row>
</header>
<group id="22">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COUNTRY"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["COUNTRY"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="23">
<cell id="24">
<data id="27">
<property name="color">blue</property>
<property
name="resultSetColumn">COUNTRY</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="25">
<cell id="26"/>
</row>
</footer>
</group>
<detail>
<row id="17">
<cell id="18">
<extended-item extensionName="Crosstab" id="28">
<property name="measures">
<extended-item extensionName="MeasureView"
id="34">
<property
name="measure">OFFICECODE</property>
<property name="detail">
<extended-item
extensionName="CrosstabCell" id="35">
<property name="content">
<data name="OFFICECODE"
id="37">
<property
name="resultSetColumn">OFFICECODE</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item
extensionName="CrosstabCell" id="36">
<property name="content">
<label id="38">
<text-property
name="text">OFFICECODE</text-property>
</label>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item
extensionName="CrosstabView" id="29">
<property name="views">
<extended-item
extensionName="DimensionView" id="30">
<property
name="dimension">Group</property>
<property name="levels">
<extended-item
extensionName="LevelView" name="NewLevel View" id="31">
<property
name="level">Group/COUNTRY</property>
<property
name="filter">

<filter-condition-element>
<expression
name="expr">data["COUNTRY_1"]</expression>
<property
name="operator">eq</property>

<simple-property-list name="value1">

<value>data._outer["COUNTRY"]</value>

</simple-property-list>

</filter-condition-element>
</property>
<property
name="member">
<extended-item
extensionName="CrosstabCell" id="32">
<property
name="content">
<data
name="COUNTRY" id="33">

<property name="resultSetColumn">COUNTRY_1</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">Data Cube</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">COUNTRY_1</property>
<expression
name="expression">dimension["Group"]["COUNTRY"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">OFFICECODE</property>
<expression
name="expression">measure["OFFICECODE"]</expression>
<property
name="dataType">string</property>
</structure>
</list-property>
</extended-item>
</cell>
</row>
</detail>
<footer>
<row id="19">
<cell id="20"/>
</row>
</footer>
</table>
Re: Grouped Crosstab Report [message #255791 is a reply to message #254726] Wed, 19 September 2007 04:20 Go to previous message
Eclipse UserFriend
The filter can be set on the cross tab that in table detail row.

And the xml of table is( Only a sample ):

<table id="14">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">OFFICECODE</property>
<expression
name="expression">dataSetRow["OFFICECODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">TERRITORY</property>
<expression
name="expression">dataSetRow["TERRITORY"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="21"/>
<header>
<row id="15">
<cell id="16"/>
</row>
</header>
<group id="22">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COUNTRY"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["COUNTRY"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="23">
<cell id="24">
<data id="27">
<property name="color">blue</property>
<property
name="resultSetColumn">COUNTRY</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="25">
<cell id="26"/>
</row>
</footer>
</group>
<detail>
<row id="17">
<cell id="18">
<extended-item extensionName="Crosstab" id="28">
<property name="measures">
<extended-item extensionName="MeasureView"
id="34">
<property
name="measure">OFFICECODE</property>
<property name="detail">
<extended-item
extensionName="CrosstabCell" id="35">
<property name="content">
<data name="OFFICECODE"
id="37">
<property
name="resultSetColumn">OFFICECODE</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item
extensionName="CrosstabCell" id="36">
<property name="content">
<label id="38">
<text-property
name="text">OFFICECODE</text-property>
</label>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item
extensionName="CrosstabView" id="29">
<property name="views">
<extended-item
extensionName="DimensionView" id="30">
<property
name="dimension">Group</property>
<property name="levels">
<extended-item
extensionName="LevelView" name="NewLevel View" id="31">
<property
name="level">Group/COUNTRY</property>
<property
name="filter">

<filter-condition-element>
<expression
name="expr">data["COUNTRY_1"]</expression>
<property
name="operator">eq</property>

<simple-property-list name="value1">

<value>data._outer["COUNTRY"]</value>

</simple-property-list>

</filter-condition-element>
</property>
<property
name="member">
<extended-item
extensionName="CrosstabCell" id="32">
<property
name="content">
<data
name="COUNTRY" id="33">

<property name="resultSetColumn">COUNTRY_1</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">Data Cube</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">COUNTRY_1</property>
<expression
name="expression">dimension["Group"]["COUNTRY"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">OFFICECODE</property>
<expression
name="expression">measure["OFFICECODE"]</expression>
<property
name="dataType">string</property>
</structure>
</list-property>
</extended-item>
</cell>
</row>
</detail>
<footer>
<row id="19">
<cell id="20"/>
</row>
</footer>
</table>
Previous Topic:Please help with this critical issue for my project
Next Topic:Data export from crosstab
Goto Forum:
  


Current Time: Sat Nov 08 12:35:16 EST 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly