Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Problems with group table
Problems with group table [message #1771990] Sat, 02 September 2017 18:14
Sayu Yagami is currently offline Sayu YagamiFriend
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
Previous Topic:execution time report
Next Topic:SSAS usage based optmisation
Goto Forum:
  


Current Time: Mon May 28 01:42:46 GMT 2018

Powered by FUDForum. Page generated in 0.02084 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top