How to set query column value as BIRT variable and use it later for calculation [message #1743323] |
Wed, 14 September 2016 10:57 |
Laxmi Vuppla Messages: 1 Registered: September 2016 |
Junior Member |
|
|
Hi Friends,
I am new to BIRT and stuck with this report. Please help me.
I have 4 queries- Query1, query2, query3, query4.
I have created 4 tables with these queries.
Now I need one more table which is like below-
Row1 Count(query1)
Row2 Count(query2)
Row3 Count(query1) - Count(query2) ------ Var1
Row4 Count(query3)
Row5 Count(query4)
Row6 Count(query3) - Count(query4) ------Var2
Row 7 Var1/Var2
So count variable of each query need to stored somewhere in BIRT and VAR1 and Var2 are again that need to stored as some variable in BIRT.
I have no idea on how to do this.
Can someone explain me how to do this in detail. PFA of layout design file attached.
Thanks in advance.
Regards,
Laxmi.V
|
|
|
Powered by
FUDForum. Page generated in 0.03724 seconds