It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788
×10,908
×4,289

question asked: Jul 11 '14, 8:31 a.m.
question was seen: 3,193 times
last updated: Jul 11 '14, 11:12 a.m.

Related questions

FAQ - How this Forum works

How to group and combine JAZZ data source result lines in BIRT?

0
Alexandr Emelyanov (6●1●1) | asked Jul 11 '14, 8:31 a.m.
edited Jul 11 '14, 8:32 a.m.
Hello. I have a join data source in my BIRT report. Some filtered by plan_id data from this data source is represented here (some query fields are hidden):
EWI_COUNT        PLAN_ID         STATE
1                          1387               NotRun
1                          1387               InProgress
2                          1387               Paused
53                        1387               Passed
5                          1388               InProgress
4                          1388               Paused
35                        1388               Passed

How to group and combine result lines like this by one query execution?
PLAN_ID         NOTRUN    INPROGRESS    PAUSED   PASSED
1387               1                1                         2               53
1388               0                5                         4               35

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Vladimir Amelin (704●7●22●26) | answered Jul 11 '14, 10:41 a.m.
Hi Alexander,

It should be possible by adding Data Cube and CrossTab in Layout editor.
Comments
Vladimir Amelin commented Jul 11 '14, 10:42 a.m.

 Just one moment to remember - self-authored BIRT reports in RQM are not supported(

Alexandr Emelyanov commented Jul 11 '14, 11:12 a.m.

  hi, thank you, I will try it!)

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.