Dynamic BIRT Report with Mutiple months Range for Year

Hi,

We are trying to evaluate BIRT and was curious if BIRT Supports the Functionality we have

1. Database which have all the different Products in Product Table.
2. Event table which have the date, product id when the product was sold.

Question

1. When we pass the Paramters say Year and Months (can be multiple) I need to generate a report

* Months and Year are Parameters to BIRT Template

Month1----Month2----Month 3
Product Name :

XYZ

0
ABC

3
123

0
098

3

Can this be possible in BIRT? What is the Best Approach

Find more posts tagged with

Comments

mwilliams

Hi userjava,

At first glance, this looks pretty standard for BIRT to be able to do. Your simple example of the output looks like you'd probably use a crosstab since your year and month are dynamic.

userjava

Any Example to start with?

BTW the Product table is not single its Multiple tables like Product Table for Department like..,

Product table for Cosmetics, Electronics etc..,

I started with Datacube but was not going further any example will be really helpful.

mwilliams

userjava,

What version of BIRT are you using?

userjava

I am using birt 2_3_0 version.

Thanks
U

mwilliams

U,

Here is an example of a crosstab using the sample database. You could easily add a dataset/report parameter to limit the data by month and year. The crosstab would then adjust itself dynamically to the available data.

Hope this helps.