Retrieving multiple custom attributes in BIRT report

There could be many ways to do this:

You could create a data set for each key value. So if you are fetching custom attributes att1 and att2, you end up with two data sets where you pass the hard coded value att1 as a parameter to data set 1 and the hard coded value att2 to data set 2. If you only have two custom attributes, you could use a joint BIRT data set to join the two. If you have many more, it is better to store all the data from the various data sets into one javascript data structure and then expose it using a BIRT scripted data set.

You could also fetch the key value pairs in one data set. Store the contents of the data set in a javascript data structure, then expose it to BIRT using a scripted data set that makes the custom attributes look like real columns.

Here is an example:

(work item 1, att1, val1)

(work item 2, att1, val2)

(work item 1, att2, val3)

The java script data structure to expose the above will be an array containing two objects:

[ {id: work item 1, att1: val1, att2: val3}, {id: work item 2, att1: val2, att2: null} ]

A BIRT scripted data set can easily expose the above data structure as a table with three columns.

A third way to do the above is to fetch the custom attributes individually for each work item by dynamically passing the work item id and the custom attribute key to a data set for each work item.