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

Report studio

Hello Team,

how to display the linked task summary with CR in Cognos Report studio?

0 votes



2 answers

Permanent link
Hello Pankaj,

I'm not sure if I fully understand your request, but if you want to see the links between 2 work items (1 change request and 1 task) you can do like this:

Drag and dropped the following items:
  • Operational Data Store > Request Area >  Request > Reference ID (this is the work item id in RTC)
  • Operational Data Store > Request Area >  Request > Name (this is the summary field in RTC)
  • Operational Data Store > Request Area >  Request Related Requests > Reference ID
  • Operational Data Store > Request Area >  Request Related Requests > Name
This is a sample of how the report looks like and the output:


Best Regards,

Francesco Chiossi

0 votes

Comments

Hi francesco,
Thanks a lot for your response.

can you please let me know if i want to display summary of CR linked with task summary , i.e. in my report i want summary of CR and summary of linked Task of same project.

awaiting response.

Regards,
Pankaj


Permanent link
Hello Pankaj,

if by summary you mean the Summary field in RTC that is the Name field in the example above.
if you mean the Description (longer text field), this is not available in the data warehouse for reporting, as all the larger fields (more that 1000 characters, I think) have not been included for performance reasons.

Best Regards,

Francesco Chiossi

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.

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
× 7,501

Question asked: Feb 13 '14, 5:08 a.m.

Question was seen: 4,525 times

Last updated: Feb 13 '14, 8:11 a.m.

Confirmation Cancel Confirm