Problems with group table [message #1771990] |
Sat, 02 September 2017 18:14 |
Sayu Yagami Messages: 2 Registered: September 2017 |
Junior Member |
|
|
Hi all,
Unfortunately I can't upload my raport but I will try to visualise my problem.
For simplicity, suppose I have two tables in the database People and Departments, Departments looks like
/ ID / NAME / MAYOR_DEPARTMENT_ID
| 1 | University | NULL
| 2 | Faculty1 | 1
| 3 | Faculty2 | 1
| 4 | Institute1 | 2
| 5 | Institute2 | 2
| 6 | Cathedra1 | 4
| 7 | Cathedra2 | 5
| 8 | Cathedra3 | 5
and People looks like
/ ID / NAME / DEPARTMENT_ID
| 1 | Person1 | 6
| 2 | Person2 | 7
| 3 | Person3 | 8
My SQL query return People.NAME,Departments.Name for all entry in database and all grouping stuff i must do in birt. Simple grouping by column Departments.Name i get something like this
/ ID / p.NAME / d.NAME
=======Cathedra1=========
| 1 | Person1 | Cathedra1
=======Cathedra2=========
| 2 | Person2 | Cathedra2
=======Cathedra3=========
| 3 | Person3 | Cathedra3
But i must choose level of grouping by parameter that has value like i.e level1, level2, level3....
When I choose level1 it should print
/ ID / p.NAME / d.NAME
=======Faculty1=========
| 1 | Person1 | Cathedra1
| 2 | Person2 | Cathedra2
| 3 | Person3 | Cathedra3
if it is selected level2:
/ ID / p.NAME / d.NAME
=======Institute1=========
| 1 | Person1 | Cathedra1
=======Institute2=========
| 2 | Person2 | Cathedra2
| 3 | Person3 | Cathedra3
etc...
I hope you know what i mean, anyone know how to achieve such effects using group table in birt or another way except changing queries in sql
|
|
|
Powered by
FUDForum. Page generated in 0.02451 seconds