| How to indent each group? [message #57124] |
Wed, 13 July 2005 05: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 #57151 is a reply to message #57124] |
Wed, 13 July 2005 05:40  |
| Eclipse User |
|
|
|
Originally posted by: ps1.perfectsoft.com.hk
hope this can help you
" " + row["rowname"]...
wins
"chris" <none@none.none> wrote in message
news:db27fe$7pj$1@news.eclipse.org...
> 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 #57200 is a reply to message #57151] |
Wed, 13 July 2005 07:04 |
| Eclipse User |
|
|
|
Originally posted by: none.none.none
Hi wins,
Thanks for the response. That might be the only way to do it, but it's not
quite what I was hoping for. That will push the data in the cell over rather
than pushing the entire row/cols over. So what may happen, for example, is
data in that cell gets wrapped onto a second row causing me to have to
resize the column (not a big deal), but then my subtotals in the footers are
not aligned anymore, so then I have to go add a bunch of padding to those as
well... plus column headers, etc.
I can just see this turning into a layout & maintenance nightmare. I'm
wondering if there are any more 'concrete' ways of doing this to have BIRT
manage the alignment and keep everything happy. Otherwise, your suggestion
may work for the time being. Thanks!
"wins" <ps1@perfectsoft.com.hk> wrote in message
news:db29hj$9g8$1@news.eclipse.org...
> hope this can help you
>
> " " + row["rowname"]...
>
> wins
|
|
|
| Re: How to indent each group? [message #57507 is a reply to message #57124] |
Wed, 13 July 2005 13:31 |
 Michael McRoberts
Messages: 9
Registered: July 2009 |
Junior Member |
|
|
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 23: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.32169 seconds
] 
Search
Help
Register
Login
Home
