| How to indent each group? [message #57124] |
Wed, 13 July 2005 01:05  |
Eclipse User |
|
|
|
Originally posted by: none.none.none
Hello,
I think this is hopefully an easy question for somebody. I have a table
with a couple groups embedded in it. I want each group to be indented
further inward. There's an example (image only, no source) in the BIRT Help
under "Grouping Data". The image is about 3/4 of the way down in a row of 3
reports samples. I'm trying to make one like the one titled "Customer
Orders".
Something like this...
GROUP 1 TITLE
GROUP 2 TITLE
Colum1 Column2 Colum3
a b c
c d e
f g h
I've got my headers and data coming out correctly, but I can't figure out
how to indent the "detail" row.
Any ideas?
Thanks!
|
|
|
|
|
| Re: How to indent each group? [message #57507 is a reply to message #57124] |
Wed, 13 July 2005 09:31  |
| Eclipse User |
|
|
|
This is a multi-part message in MIME format.
--------------080700040407050503090705
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Attached is an example report that I think does the group indenting you
are looking for. To recreate, create a report, add a table, drag in your
detail columns. Then right click on the table and insert your groups.
Once they have been added, make sure the columns you defined the groups
over are in their own column with the top level group in the first
column, and the next level group in the second column, etc. Then select
the cell for the top level group and all of the cells to the right of
it, right click and select merge. Do the same with all of the remaining
groups. You can then resize the columns to get the groups to overlap and
be indented.
To get the detail row headers to appear below all of the group breaks,
at the lowest level group right click on the row and select
Insert-Row-Below. Now move your detail row headers to this group header row.
Michael
chris wrote:
> Hello,
> I think this is hopefully an easy question for somebody. I have a table
> with a couple groups embedded in it. I want each group to be indented
> further inward. There's an example (image only, no source) in the BIRT Help
> under "Grouping Data". The image is about 3/4 of the way down in a row of 3
> reports samples. I'm trying to make one like the one titled "Customer
> Orders".
>
> Something like this...
>
> GROUP 1 TITLE
> GROUP 2 TITLE
> Colum1 Column2 Colum3
> a b c
> c d e
> f g h
>
> I've got my headers and data coming out correctly, but I can't figure out
> how to indent the "detail" row.
>
> Any ideas?
>
> Thanks!
>
>
--------------080700040407050503090705
Content-Type: text/xml;
name="groups.rptdesign"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="groups.rptdesign"
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 1.0 -->
<report xmlns=" http://www.eclipse.org/birt/2005/design" version="1">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.0 Build <20050601-0809></property>
<property name="units">in</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.sampledb" name="Data Source"/>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Data Set">
<property name="dataSource">Data Source</property>
<property name="queryText">select *
from CLASSICMODELS.CUSTOMERS</property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Customer Orders">
<property name="dataSource">Data Source</property>
<property name="queryText">select *
from CLASSICMODELS.ORDERS</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage">
<page-footer>
<text>
<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>
<table name="table1">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<column>
<property name="width">0.2in</property>
</column>
<column>
<property name="width">0.2in</property>
</column>
<column>
<property name="width">1.687in</property>
</column>
<column>
<property name="width">2.572in</property>
</column>
<column>
<property name="width">1.989in</property>
</column>
<group>
<property name="groupName">Country</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COUNTRY"]</expression>
<header>
<row>
<cell>
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<data>
<property name="fontWeight">bold</property>
<expression name="valueExpr">row["COUNTRY"]</expression>
</data>
</cell>
<cell/>
</row>
</header>
</group>
<group>
<property name="groupName">State</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["STATE"]</expression>
<header>
<row>
<cell/>
<cell>
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<data>
<property name="fontWeight">bold</property>
<expression name="valueExpr">row["STATE"]</expression>
</data>
</cell>
<cell/>
</row>
<row>
<cell/>
<cell/>
<cell>
<label>
<text-property name="text">Name</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">Address</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">Credit Limit</text-property>
</label>
</cell>
</row>
</header>
</group>
<detail>
<row>
<cell/>
<cell/>
<cell>
<data>
<expression name="valueExpr">row["CUSTOMERNAME"]</expression>
</data>
</cell>
<cell>
<data>
<expression name="valueExpr">row["ADDRESSLINE1"]</expression>
</data>
</cell>
<cell>
<data>
<expression name="valueExpr">row["CREDITLIMIT"]</expression>
</data>
</cell>
</row>
</detail>
</table>
</body>
</report>
--------------080700040407050503090705--
|
|
|
| Re: How to indent each group? [message #57897 is a reply to message #57507] |
Wed, 13 July 2005 19:03 |
| Eclipse User |
|
|
|
Originally posted by: none.none.none
Thank you very much. That was a huge help. It all makes sense now and
things are lining up nicely.
"Michael McRoberts" <mmcroberts@spss.com> wrote in message
news:db352l$bqr$1@news.eclipse.org...
> Attached is an example report that I think does the group indenting you
> are looking for. To recreate, create a report, add a table, drag in your
> detail columns. Then right click on the table and insert your groups.
> Once they have been added, make sure the columns you defined the groups
> over are in their own column with the top level group in the first
> column, and the next level group in the second column, etc. Then select
> the cell for the top level group and all of the cells to the right of
> it, right click and select merge. Do the same with all of the remaining
> groups. You can then resize the columns to get the groups to overlap and
> be indented.
>
> To get the detail row headers to appear below all of the group breaks,
> at the lowest level group right click on the row and select
> Insert-Row-Below. Now move your detail row headers to this group header
> row.
>
> Michael
|
|
|
Powered by
FUDForum. Page generated in 0.04218 seconds
Home