nested crosstab

Is it possible to nest a crosstab in a table like in the subreport examples. I tried this, but i have problems to restrict the dataset, used by the crosstab, to the parent id.
Setting a filter on the crosstab does work, but it does the filtering in BIRT (and that for every detail), which needs too much time.

Is there another way to use a crosstab as detail?

Find more posts tagged with

Comments

jori

A found a solution in 
 
<a class='bbc_url' href='http://www.birt-exchange.org/forum/eclipse-birt-newsgroup-mirror/9306-values-dataset-used-input-another-dataset.html'>http://www.birt-exchange.org/forum/eclipse-birt-newsgroup-mirror/9306-values-dataset-used-input-another-dataset.html</a> 
 
--> it uses a hidden report parameter to restrict the data dataset eg. of the crosstab.

jori

It seems that you can restrict the dataset this way, but then its restricted by the same value for all detail rows, which is not the desired behaviour.
So my question is:
Is there a way to nest a crosstab into the detail row of a table and restrict the dataset of the crosstab (an therefor the data the crosstab shows) by a field-value of the row?

mwilliams

Hi jori,

So, you have a dataSet for an outer table and a dataSet for the embedded crosstab? What is happening with the use of the hidden report parameter that you tried above?

Edit: Also, what version of BIRT are you using?

jori

The hidden report parameter, which is bound to the dataSet parameter of the crosstable's dataset, is set in the onCreate method of the row (... i also tried to set it in the onCreate method of an dataItem in the row). If I output the value of this report parameter using a dynamic text it has the right value, that changes over the rows.

But for the restriction of the dataSet it seems that it is only used once and then the dataSet restriction stays the same although the dataSet is opened many times (for each row; to see this I put code in the onOpen-method of the dataset that increments the value of a report parameter).

Birt version 2.5.1. I built the report with the corresponding designer.

mwilliams

jori, 
 
The best way I've seen to do an embedded crosstab is with a filter. It would be nice if there was a way to set the dataSet parameter for the dataSet used in the crosstab to a value from the outer table as you would do when you do an embedded table. This is definitely something that could be put in as an enhancement request. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/bug-reporting/'>Report Bugs - BIRT Exchange</a>