Eclipse Community Forums: BIRT » Span group data across detail rows?

Home » Archived » BIRT » Span group data across detail rows?

Span group data across detail rows? [message #366407]

Mon, 22 December 2008 11:57

Eclipse User

I have a dataset that is being grouped, and needs some of the grouping
information to appear on the detail row - however, this group info needs
to be in a single cell spanning across all of the detail rows for each
group. As such:

Group A
--------|-------|-------|-------
group A | 1 | 1 | 1
info | 2 | 2 | 2

I have tried using a filtered embedded crosstab or table for this effect
- in both cases the performance suffered tremendously for larger
datasets. Is there a way to do rowspan merge in a single table via
scripting? Or perhaps does anyone know of a way to filter an embedded
table without the performance hit (this is a 4th level group)?

Re: Span group data across detail rows? [message #366416 is a reply to message #366407]

Tue, 23 December 2008 09:58

Eclipse User

I believe the solution (using the embedded table technique) would be to
leave the inner table as unbound statically - and then bind dynamically
for each group header instance in the outer table. This would avoid the
need for filtering completely, and would probably perform much better.
However, I'm not quite sure how (or if) I can access the collection of
dataSetRows contained within the current group - can anyone provide some
code that does something similar?

> I have a dataset that is being grouped, and needs some of the grouping
> information to appear on the detail row - however, this group info needs
> to be in a single cell spanning across all of the detail rows for each
> group. As such:
>
> Group A
> --------|-------|-------|-------
> group A | 1 | 1 | 1
> info | 2 | 2 | 2
>
> I have tried using a filtered embedded crosstab or table for this effect
> - in both cases the performance suffered tremendously for larger
> datasets. Is there a way to do rowspan merge in a single table via
> scripting? Or perhaps does anyone know of a way to filter an embedded
> table without the performance hit (this is a 4th level group)?

Re: Span group data across detail rows? [message #366417 is a reply to message #366416]

Tue, 23 December 2008 10:06

Eclipse User

The solution turned out to be much simpler than that :) - leaving the
inner table as unbound and referencing the outer table items directly
(without using row._outer) works like a charm. Hope this helps somebody.

> I believe the solution (using the embedded table technique) would be to
> leave the inner table as unbound statically - and then bind dynamically
> for each group header instance in the outer table. This would avoid the
> need for filtering completely, and would probably perform much better.
> However, I'm not quite sure how (or if) I can access the collection of
> dataSetRows contained within the current group - can anyone provide some
> code that does something similar?
>
>> I have a dataset that is being grouped, and needs some of the grouping
>> information to appear on the detail row - however, this group info
>> needs to be in a single cell spanning across all of the detail rows
>> for each group. As such:
>>
>> Group A
>> --------|-------|-------|-------
>> group A | 1 | 1 | 1
>> info | 2 | 2 | 2
>>
>> I have tried using a filtered embedded crosstab or table for this
>> effect - in both cases the performance suffered tremendously for
>> larger datasets. Is there a way to do rowspan merge in a single table
>> via scripting? Or perhaps does anyone know of a way to filter an
>> embedded table without the performance hit (this is a 4th level group)?

Previous Topic:	get/set sql query of a report
Next Topic:	New to BIRT, checking the possibilities

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Oct 23 23:18:30 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter