How to create multiple tables at the same time.

hey everyone,

I am new to birt and would greatly appreciate it if some one could help me with one of my report design.

Here is the what I want to do
(1) I have a report which shows the detailed information about a product. Let's call it report A.
(2) I want to provide two parameters, begin date and end date for users.

(3) Once users selected the begin date and end date, I would query the database and find all of the products that were purchased during this time slot, and generate multiple tables for each product. (means multiple report A for all of the product) in one report.

Does anyone has any similar experience? How to dynamically generate multiple data tables in one report? Thank!

Find more posts tagged with

Comments

mwilliams

Hi temphan,

If I'm understanding correctly, you should be able to group your table by product and do a page break after the group if you'd like them all on separate pages as well.

temphan

Hey Michael

Your suggestion is a valid solution, just one little thing, if I split the report by pages, it is still one report, I would like to have separate title for each page, which contains the product's name. Any idea how to implement that? Thanks.

mwilliams

temphan,

You can do that in the group header of the report. Then you'll have a unique header for each product.

Saba

Hello there
Can this solution of grouping and adding page breaks apply for cross tab reports. Example - can I have a multiple cross tabs grouped on product on each page?

mwilliams

Hi Saba,

Can you explain more about your report design and what you're looking for, so I can be sure I understand your setup before I respond? Thanks.

Saba

Hello Michael
Example - I have created a crosstab report that shows max and average CPU consumption for the last 90 days grouped on application and region. Now because the resultset crosstab has more than 5000 cells ( guess a limitation in BIRT to display only about 4000 cells) , I want to create individual cross tab report grouped on region for each application in a separate page. This way I probably can overcome the limitation of 5000 cells.
Please let me know if you have and questions?
Thanks
Saba