OraFAQ Forum: Reports & Discoverer » duplicate data in discoverer from a Group By

Home » Developer & Programmer » Reports & Discoverer » duplicate data in discoverer from a Group By (Discoverer 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

duplicate data in discoverer from a Group By [message #659767]

Mon, 30 January 2017 06:42

lyon08ben
Messages: 3
Registered: January 2017

Junior Member

Hi,
I have to display data in Discoverer. In my request I have a group by clause , but I want to display all data that the group by hide for each row.
the result of my report is like this:

City    dept_id  sum(product)
----    -------  -----------
Paris     1          5
          2          6
          3          1
lille     1          5
          2          2
          3          1
          4          9

But I want in the report discoverer this display:

City  dept_id  sum(product)
----  -------  -----------
Paris     1          5
Paris     2          6
Paris     3          1
lille     1          5
lille     2          2
lille     3          1
lille     4          9

So I want to duplicate all dada that the group by hide for each row.
thanks

[EDITED by LF: applied [code] tags to preserve formatting]

[Updated on: Mon, 30 January 2017 07:09] by Moderator

Report message to a moderator

Re: duplicate data in discoverer from a Group By [message #659772 is a reply to message #659767]

Mon, 30 January 2017 07:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use Discoverer so I don't know the answer; however, if it is similar to Reports, see whether you can create a "break group" by dragging the CITY column out of its current group; then you'd have to re-create the layout. In Reports' Data Model window, it looks like this:

/forum/fa/13438/0/

Moreover, Reports' Wizard offers to create "Group Left" (or "Group Above") types of a report and asks you to define which columns should be used as "group fields". Maybe there's something similar in Discoverer.

If nothing of this makes sense, then I put some useless effort into solving something I know nothing about; sorry.

Attachment: orafaq_rep_break.png
(Size: 5.61KB, Downloaded 2966 times)

Report message to a moderator

Re: duplicate data in discoverer from a Group By [message #659773 is a reply to message #659772]

Mon, 30 January 2017 07:28

lyon08ben
Messages: 3
Registered: January 2017

Junior Member

Hi, thank you for your answer, but discoverer is not similar to Oracle reports at all. The break group option is not available in Discoverer.
Many thanks again

Report message to a moderator

Re: duplicate data in discoverer from a Group By [message #659774 is a reply to message #659773]

Mon, 30 January 2017 07:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, as OraFAQ forum lacks in Discoverer users, I don't know whether you'll get the answer here or not. Perhaps you'd rather have a look at OTN forums (if noone answers your question here) ...

Report message to a moderator