How to create BIRT report with custom parameters?

hello ....
im using Rational quality manager 2.0.1
and Rational Team Concert 2
and Birt ...
how can i display work item discussion/comment field in BIRT Report???
thank you :?:

Hi,

i am created three datasets.

1. client_initiative
2. Task
3. Link

I want to link this three data set using script.

Hi,

i am created three datasets.

1. client_initiative
2. Task
3. Link

I want to link this three data set using script.

General way is:
1) Declare hash variables in "Initialize" method of template
2) Fill every hash in desired way in "onFetch" method of every data set
3) "Run" data sets in script by binding it to hidden dynamic text (order is important)
4) Make 4th "linked" dataset using "Scripted" data source and fill it like you wish using hashes from previous steps

However, for your specific needs approach may be different.

James,
Do you have an example of this case with the javascript? I am having a very hard time (being a javascript newbie) trying to determine how and where to put the necessary code.

I am basically trying to transpose my custom attributes from rows into columns.

Thanks for any help you may have.

Paul

On 1/29/2010 12:08 PM, anjalidjain wrote:

When i create a data set, I get work items row repeated, how do i get
a distinct set of work items pulled from the data set.
I am trying to create a data set and query it based on a custom
filter which can have value 1 or value 2
In case the work item has value assigned to field 1 and field 2 , it
brings in that work item twice.

Also is there a place where I can get a desciption of different RTC
tables and what gets stored in where?

Hi,

You can get a description of each of the data warehouse tables here:

https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20

So, just to understand the case, you need to select two different custom
fields, and in the case where a work item has values for both of those
fields, you get two rows back, when you really want just one. The
behaviour is expected, because of the generic way we store custom
attributes, but you can work around this quite easily.

The simpliest thing for you to do might be to store the work items, as
well as all the custom attributes, in a javascript map, and then create
a scripted data set on that map, and create your chart/table from the
scripted data set.

So, assuming your existing data set is "A", and the new scripted data
set is "B":

In report initialize, declare a variable to hold all the data.

workItems = [];

We'll be using the work item id as the key, and an object with the
attributes as the value.
In A's onFetch, you need to look up the value from workItems to see if
it already exists, and create it if it doesn't. Roughly:

var id = row;
var workItem = workItems;
if (workItem == null) {
workItem = [];
workItems = workItem;
workItem = row;
... (fill in the other stuff like creation date, project area name,
team area name, category name, wi_type, etc).
}
Then fill in the custom attribute data that you've fetched specifically
with this row:
workItem] = row; // or BOOLEAN_VAL, or
whatever

Then, create scripted data set B, and implement its fetch method to
return one of these workItem objects, which is now all flattened out to
a single row.
Then create your chart on data set B.

Hope this helps, please let me know if this isn't clear.

james
RTC Reports Team Lead