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

Duplicate values appearing in the BIRT Report

Questions
Tags
Users
Badges
Abhilash M M
(13●1●7) Dec 21 '16, 5:59 a.m.
 I am Using RTC 6.0.2 and BIRT 6.0.2 
Writing Report to show all work Items for a Specific Team
whenever i am trying to fetch data same work Item appears multiple Times with same Parameters 
is there any way to avoid this

Thanks for help
Abhilash

0 votes

1 answer
2,245 views
0 votes

Accepted answer

Permanent link
Miguel Tomico
(500●14●23) Dec 21 '16, 7:23 a.m.

Can you provide more information, please?

https://jazz.net/forum/questions/203755/how-should-i-ask-a-question-in-the-forum-if-i-want-to-receive-useful-answers

You are probably selecting certain special columns and not filtering as you should, but can't be sure without more detail.

Try to select only the ID in the Data Source and see if you get duplicates.

Abhilash M M selected this answer as the correct answer

0 votes

Comments
Abhilash M M
Dec 21 '16, 7:53 a.m.

Data Source is  Jazz Data Source
in the Report layout 

the Table Contains
WI_NAME,SUMMARY,TEAM_AREA_NAME,ITERATION_NAME ( from a single Data set )
filters in Dataset are 
WI_ARCHIVED = false
TEAM_AREA_ARCHIVED = false
and i have Report Parameter for ITERATION_NAME

in the Result Report i have same Work Item appearing 7 Times 

Miguel Tomico
Dec 21 '16, 8:33 a.m.

I understand you are also filtering by Project Area? Can you please also display the ID to make sure they are duplicates?

What's the Table name you are querying the data from? I don't think it's the WORKITEMS table, as WI_NAME is not present there. Actually I don't recognise that.

I would suggest to simplify the report or even start from scratch. Just select the WORKITEMS table, filter by Project Area, display just the ID and the Summary, and go from there.

Please review all above comments.

Abhilash M M
Dec 21 '16, 9:49 a.m.

Earlier i was Using APPROVAL  Table
now i selected Data from WORKITEMS Table so now the Issue is Resolved 

Thanks for help

Still not sure how it was Displaying data Multiple Times with that Table

Miguel Tomico
Dec 21 '16, 10:00 a.m.

It makes perfect sense. You were retrieving the APPROVALS, and NOT the WORKITEMS. The relationship between Work Items and Approvals is 1 -> n (this is, a work item can have several approvals). Therefore, you probably were looking at approvals that belonged to the same work item.

Maybe you need some more self-training in BIRT and RTC to better understand the Table Names in BIRT and how to create reports.

Please mark the relevant response as the Correct Answer if that helped you to fix your issue. Thank you.

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.

Ask a question
Guidelines
FAQ
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

Question asked: Dec 21 '16, 5:59 a.m.

Question was seen: 2,245 times

Last updated: Dec 21 '16, 10:00 a.m.

Confirmation Cancel Confirm