It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,837
×103

question asked: Dec 21 '16, 5:59 a.m.
question was seen: 1,941 times
last updated: Dec 21 '16, 10:00 a.m.

Related questions

Duplicate values appearing in the BIRT Report

0
Abhilash M M (13●1●7) | asked 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

Accepted answer

0
permanent link
Miguel Tomico (500●14●23) | answered 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
Comments
Abhilash M M commented 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 commented 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 commented 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 commented 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 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.