Home » Developer & Programmer » Reports & Discoverer » ERROR IN REPORT GROUP
ERROR IN REPORT GROUP [message #623246] Sun, 07 September 2014 07:54 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
hi,
my report have a query with two fields for group fields.
two fields in two level(see file attachment).
but in output have a error. Confused
In fact, a value of fields group Is repeated(and this is error).
This will be important when we use aggregate functions for each group.
please see file attachment......
What should I do??? Sad

Report message to a moderator

Re: ERROR IN REPORT GROUP [message #623254 is a reply to message #623246] Sun, 07 September 2014 08:37 Go to previous messageGo to next message
Littlefoot
Messages: 21765
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use DISTINCT?

Report message to a moderator

Re: ERROR IN REPORT GROUP [message #623277 is a reply to message #623254] Sun, 07 September 2014 22:57 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
no

Report message to a moderator

Re: ERROR IN REPORT GROUP [message #623302 is a reply to message #623277] Mon, 08 September 2014 03:10 Go to previous messageGo to next message
cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you want a useful answer you need to supply more information.
What is the query?
Which columns are in each group?

Report message to a moderator

Re: ERROR IN REPORT GROUP [message #623881 is a reply to message #623302] Mon, 15 September 2014 16:54 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
If you take the query out of Reports and run it in SQLPlus/SQL Developer do you still have a duplicate entry for the 1393/05/30 - 691 rows? Can you show us your query?

Craig...

Report message to a moderator

Previous Topic: set format trigger=return(false) for a parent frame
Next Topic: Rep-1401: '' Fatal PL/sql error, issue with Clob and varchar2 in Oracle 11.2.0.4.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 30 19:04:30 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.