Birt Data set - How can I query/filter according to "Planned for" ?

0	Tal Rabinovitch (47●2●16●15) \| asked Nov 25 '12, 4:37 a.m. Hi, Each work Item has a 'Planned for' attribute. How can I use it when creating data sets in birt ? (I didn't see it appears in the available parameters or columns). Thanks, Tal.

Accepted answer

permanent link

Erwin Kunz (946●8●66●86) | answered Nov 25 '12, 5:29 a.m.

Hi Tal

In My Report I wanted to filter on project area and planed for

Doing that I first created a data source connected to work item

Then a parameter data source to work item.

As output project_area_name an iteration_name (an several more)

Then I created a cascading parameter group connected to this parameter data set

First parameter project, second iteration

Then created a other data set on work item an use the two report parameters to link to the parameters of the new data set

In short: planned for is the parameter iteration_name

Hope you can follow the idea

Erwin

Tal Rabinovitch selected this answer as the correct answer