How to iterate rows of DataSet by script in report design onInitial function?

I want to create tables dynamically depends on DataSet's data.

for example, the dataSet is as:
company name, customers, time
IBM, 100,10:00
IBM, 200, 12:00
Sun, 300,14:00
Sun, 400,16:00

So I will create two tables, as:
Label: IBM
Table:
header: company name customers time
details: IBM 100 10:00
IBM 200 12:00
Label: Sun
Table:
header: company name customers time
details: Sun 300 14:00
Sun 400 16:00

Would you like to give me suggestions?
Thank you very much for your help!

Find more posts tagged with

Comments

Virgil Dodson

Hi bitisony,

In this particular example, you could have the appearance of two different tables by using grouping in a single table by company.

Otherwise, you may find yourself in a catch 22 situation where you can't easily create tables in the initialize method based on data from a BIRT dataset, since that dataset wont actually be called until it is needed by a table in the report.

As a workaround, can you get the data yourself with Java or JavaScript while creating the dynamic tables in the initialize method?