Home » Developer & Programmer » Reports & Discoverer » duplicate data in discoverer from a Group By (Discoverer 11g)
duplicate data in discoverer from a Group By [message #659767] Mon, 30 January 2017 06:42 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21240
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:

./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.
Re: duplicate data in discoverer from a Group By [message #659773 is a reply to message #659772] Mon, 30 January 2017 07:28 Go to previous messageGo to next message
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
Re: duplicate data in discoverer from a Group By [message #659774 is a reply to message #659773] Mon, 30 January 2017 07:51 Go to previous messageGo to next message
Littlefoot
Messages: 21240
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) ...
Re: duplicate data in discoverer from a Group By [message #659776 is a reply to message #659774] Mon, 30 January 2017 07:56 Go to previous messageGo to next message
lyon08ben
Messages: 3
Registered: January 2017
Junior Member
I think so!
thx
Re: duplicate data in discoverer from a Group By [message #660247 is a reply to message #659776] Mon, 13 February 2017 07:34 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 497
Registered: August 2002
Senior Member
https://docs.oracle.com/cd/E12839_01/bi.1111/b40105/appendix.htm#BIDPU1597

https://docs.oracle.com/cd/E17904_01/bi.1111/b40106/advance.htm


https://docs.oracle.com/cd/E23943_01/bi.1111/b40106/pivdrl.htm

[Updated on: Mon, 13 February 2017 07:36]

Report message to a moderator

Re: duplicate data in discoverer from a Group By [message #660293 is a reply to message #660247] Tue, 14 February 2017 04:33 Go to previous messageGo to next message
jaganerp
Messages: 1
Registered: February 2017
Junior Member
hello, if you are not using any group functions in your work book it will display the out put as you expect.
Re: duplicate data in discoverer from a Group By [message #660309 is a reply to message #660293] Tue, 14 February 2017 09:50 Go to previous message
shahzad-ul-hasan
Messages: 497
Registered: August 2002
Senior Member
paste the query which you are using.
Previous Topic: CELL ALIGNMENT
Next Topic: Discoverer workbooks merging
Goto Forum:
  


Current Time: Wed Nov 22 21:44:21 CST 2017

Total time taken to generate the page: 0.06124 seconds