Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to create BIRT report with custom parameters?

Hello All,

I am trying to create some reports using BIRT in RTC, I want to include some of the custom fields, can somebody help me on the same.

Thanks,
-Kiran

0 votes



14 answers

Permanent link
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 :?:

0 votes


Permanent link
Hi,

i am created three datasets.

1. client_initiative
2. Task
3. Link

I want to link this three data set using script.

0 votes


Permanent link
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.

0 votes


Permanent link
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

0 votes

1–15 items
page 2of 1 pagesof 2 pages

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 482
× 324

Question asked: Jan 06 '10, 6:59 a.m.

Question was seen: 28,444 times

Last updated: May 15 '14, 11:33 a.m.

Confirmation Cancel Confirm