Dynamic Parameters generation?

vnguyen

Dynamic Parameters generation?

I have reviewed many of the posts related to dynamic parameters generation as well as samples from different BIRT sites but I have not been able to come up with a solid solution to my problem, hoping the experts can help.

Goal: to generate a report that has dynamic data columns (like for product attributes key/value, etc..) and these attributes can be added/edited/deleted dynamically, so for this report, I need to ability to query the database (well it will be a web service, but an example with database will suffice), to pull out the attributes and display them as parameters to the reports and then based on what was chosen, those columns will be included in the report content. So here is an example:

Attributes columns in database:
Id ItemId Name KeyName KeyValue ?.
1 1 item1 color red
2 1 item2 size 10
3 1 item3 price 10
?.
and so on and so forth?

Filter1: Color (text-box)
Filter2: Size (text-box)
Filter3: Price (text-box)
?.
and so on and so forth?

Thanks so much!

mwilliams

Hi vnguyen,

Do you know all the different "KeyName" values? Or are those dynamic?