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

How do I export the merged cells on Jazz Report Builder?

Questions
Tags
Users
Badges
Rohith Kuntumalla
(11●1) Nov 28 '19, 1:28 a.m.

I have merged cells of the same items and the linked items will show as split cells within the parent item in a separate column. 


For e.g. As shown with Req_A.

Report Preview after "Run Report" on Report Builder:
Name  | Attr_X | Attr_Y | Attr_Z | Link_to_Req_L | Link_to_Req_K 
---------------------------------------------------------------------------------------------
Req_A | $$$$$  | %%%  | &&&&  |      Req_D           |        Req_E
            |             |             |            |       Req_F          | 
            |             |             |            |       Req_G          | 
---------------------------------------------------------------------------------------------
Req_B | #####  | #####  | ##### |      Req_D           |        Req_E

However when I try to export this view the merge disappears and is replaced with the text. 

Excel Export from Report Builder:
Name  | Attr_X | Attr_Y | Attr_Z | Link_to_Req_L | Link_to_Req_K 
---------------------------------------------------------------------------------------------
Req_A | $$$$$  | %%%  | &&&&  |      Req_D           |        Req_E
Req_A | $$$$$  | %%%  | &&&&  |      Req_F           |        Req_E
Req_A | $$$$$  | %%%  | &&&&  |      Req_G           |        Req_E
---------------------------------------------------------------------------------------------
Req_B | #####  | #####  | ##### |      Req_D           |        Req_E

So I am left with duplicated rows with slightly different combinations of the linked items.

However s there a way to export the exactly previewed report?

0 votes

3 answers
2,361 views
0 votes

3 answers

Permanent link
Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER (919●6●13) Nov 28 '19, 1:45 a.m.

Hi Rohith,


JRS export provides data for additional analysis and it does not provided formatted layer. You get raw data and you need to use MS Excel feature to format it to be the same as with the JRS. In summary, JRS formatting is available as long as you stay within Report Builder. 

1 vote

Permanent link
Sterling Ferguson-II
(1.6k●14●288●273) Dec 01 '19, 9:38 p.m.

 Hello,


"Sometimes" I am able to copy and paste in to excel from the report builder results page and it keeps the formatting.

0 votes

Permanent link
Jackie Albert
(1.6k●1●49●47) Dec 03 '19, 4:20 p.m.

 You could try to export in another format  (PDF, Word, HTML) and see if that gives you what you're looking for?

0 votes

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: Nov 28 '19, 1:28 a.m.

Question was seen: 2,361 times

Last updated: Dec 03 '19, 4:20 p.m.

Confirmation Cancel Confirm