nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help with group by

Juwan

Hello everybody, 
 
I've got a Table who should list information about "Departement". Each "departement" has a name, a creation date ... and many "communes" . 
 
Here is the report I want : 
 
DEPARTEMENT 1 
NAME 
DATE 
... 
Communes linked : 
COM1 
COM2
 
Page break 
 
DEPARTEMENT 2 
NAME 
DATE 
... 
Communes linked : 
COM3 
COM4
 
I have put a "group by DEPARTEMENT" but I obtain this report : 
 
DEPARTEMENT 1 
NAME 
DATE 
... 
Communes linked 
COM1
 
DEPARTEMENT 1 
NAME 
DATE 
... 
Communes linked 
COM2
 
DEPARTEMENT 2 
NAME 
DATE 
... 
Communes linked 
COM3
 
DEPARTEMENT 2 
NAME 
DATE 
... 
Communes linked 
COM4
 
 
It doesn't match very well with the wanted report... If somebody would help me... 
 
thanks

Find more posts tagged with

Comments

Hans_vd

Do you have all the data in one dataset?
In that case, make sure you have all department data in group header rows, the communes in detail rows.

Juwan

Thanks for your answer. It's what I've done but with a table it doesn't work and with a list it's good.

Juwan

if anyone needs, here is the link i used : <a class='bbc_url' href='http://download.eclipse.org/birt/downloads/examples/reports/2.1/subreport/subreport.html'>video</a>

dsoon

<blockquote class='ipsBlockquote' data-author="'Juwan'" data-cid="109551" data-time="1348058564" data-date="19 September 2012 - 05:42 AM">
if anyone needs, here is the link i used : <a class='bbc_url' href='http://download.eclipse.org/birt/downloads/examples/reports/2.1/subreport/subreport.html'>video</a> </blockquote>
 
Can you post your sample? This looks like just a linkage issue with the outer table. 
 
:Dez

Juwan

Thanks but i succeed.

The problem was i used "DataSetRow["..."] instead of "Set["..."]