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

Reporting: Export of Epic, Story & Task to Excel has duplicate record id's

Questions
Tags
Users
Badges
Vikash Singh
(42●30●65) edited
Jan 27 '16, 4:22 a.m.
Hi,

I created a report in CCM which gives the list of Epic, Story and Task in  tabular format. while exporting that report in the excel spreadsheet it includes duplicate id's of the parent record, e.g., if there are 3 stories for an epic, there are 3 rows with the Epic ID. How we can remove this kind of repetition while export to excel spreadsheet . 

0 votes

2 answers
4,312 views
0 votes

2 answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) Jan 27 '16, 2:43 a.m.
This is obviously no repetition, but represents the fact that each of the stories have the epic as a parent (because they are children). If you don't want to see that information, just remove the column "Parent" from the exported ones.

0 votes

Comments
Vikash Singh
Jan 27 '16, 3:27 a.m.

Hi Ralph,


When we export data into excel spreadsheet  then it shows the repeated ID of the epic. Is there any way while export it will merge the similar rows data for same ID? In CCM report it shows the record as per requirement but when we export same report into excel then it shows repeated data.

Vikash Singh
Jan 27 '16, 3:28 a.m.

 Hi Ralph,


When we export data into excel spreadsheet  then it shows the repeated ID of the epic. Is there any way while export it will merge the similar rows data for same ID? In CCM report it shows the record as per requirement but when we export same report into excel then it shows repeated data.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 27 '16, 3:53 a.m.

I think you don't understand what you are seeing and that causes the issue. Maybe I am wrong. In that case, paste the header and the lines containing the stories and the epic here.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 27 '16, 3:55 a.m.

Ideally export as CSV file, open it with a text editor and paste the content for the header and the lines of interest.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 27 '16, 3:57 a.m.

Please note again, if you select links such as parent as column to export, they will contain the ID of the work item that is referenced. so if you have an epic 1 that has three children 2,3,4 you will see a column

ID; Parent
1;
2; 1
3; 1
4; 1

This is as designed.

Naveen Tyagi
Jan 27 '16, 4:14 a.m.

Hi Ralph,

I think, This is what he is getting in excel format :


And this is what he needs:

I have also tried  this using JRS 6.0 but failed to do so. :(

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 27 '16, 4:20 a.m.

Ah, dang it, I missed that it is a Reporting question and it is also not tagged that way either. Not sure how to group it that way.

showing 5 of 7 show 2 more comments
Permanent link
Kenji Sarai
(960●3●9) Mar 27 '19, 12:37 a.m.
Does anyone have an idea how to do this? See the desired format in Naveen's comment. Thanks

Note: it is fine in the table report in Report Builder, problem happens after Excel export.

0 votes

Comments
Kenji Sarai
May 03 '19, 12:25 a.m.

Confirmed with dev member. Unfortunately it is not possible to merge cells in exported Excel file as of version 6.0.6.1.

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: Jan 27 '16, 1:09 a.m.

Question was seen: 4,312 times

Last updated: May 03 '19, 12:25 a.m.

Confirmation Cancel Confirm