duplicate data in discoverer from a Group By [message #659767] |
Mon, 30 January 2017 06:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1356972f21f902bfbc5abcf781a28fe7?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|
|
|