Help required in dynamic tables

Hi All,

i need a report something like this.

APP1 | Icon of APP1 | Licenses#

No of Active Licenses | 50
No of Inactive Licenses | 30
Total | 80

APP2 | Icon of APP2 | Licenses#

No of Active Licenses | 20
No of Inactive Licenses | 30
Total | 50

.
.
.

and so on. APP1, APP2,APP3 are coming from databases so there can be n APP with different data. Now how can i iterate over the table? or create a BIRT table on the fly? Please Help me in this regards.

Find more posts tagged with

Comments

mwilliams

Hi zkhalid,

Initially, it looks like you could do this with a table grouping on APP#.

zkhalid

Table Grouping is working but how to get the id or name of the group in inner table? To elaborate i want the APP1,APP2... value in my inner dataset query so that i can get the license info of that particular APP.

The inner query would be
select * from licenses where appId=?
Need to replace ? with the value of APP group. This query will run for every application.

mwilliams

zkhalid,

If you have a sub-table that you need to use the group value as the parameter, just select the table and go to the binding tab under the property editor. There should be a button that says "DataSet Parameter Binding...". This shoul allow you to set up the outer tables group value as the parameter to your inner query. Let me know if you have questions.

mani_03

can any one help me I want put a grid with in table but When we put the grid with in table then it not visible , when we resizing it then it visible I mean , that table column overlap to grid

mani_03

I am new to birt can any body help me how we create dyanamic report using cross table , As

Suppose there are many column which can not be defind At starting point of time they can increase or decrease user required

I am showing some mock data what I want

serialNo. | Student name | mark1 | mark2 | mark3 | mark4 ...| Toatal

1 | s1 | 2 | 4 | 3 | 6 | 2+4+3+ 6

1 | s2 | 3 | 7 | 4 | 2 | 3+7+4+2

value asssocited to each column As mark1 is 2 & 3 these value should be as how manu student will be there but No. of column is not defind that it can be increase or decrease

I think it is possible by crosstab but I dont know how it will work I have tried but not get success Please me.....