Home » Developer & Programmer » Reports & Discoverer » Reports doesnt show same values (Reports 6i)
Reports doesnt show same values [message #349521] Mon, 22 September 2008 02:32 Go to next message
manimee
Messages: 13
Registered: August 2007
Junior Member
Hi friends,

I have more than one same value rows in a table and i want to show all rows in oracle reports 6i. But, as result, detail section of the report eleminating the rows and displays only one row of it. Looking for solution. Thanks
Re: Reports doesnt show same values [message #349545 is a reply to message #349521] Mon, 22 September 2008 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there the DISTINCT keyword in the query?
Did you set "Maximum records per page" repeating frame's property to "1"?

If you create a test case (CREATE TABLE and INSERT INTO sample data, along with the RDF file), someone might even take a look.
Re: Reports doesnt show same values [message #349570 is a reply to message #349545] Mon, 22 September 2008 04:30 Go to previous messageGo to next message
manimee
Messages: 13
Registered: August 2007
Junior Member
'NO' for the both questions.

Thanks
Re: Reports doesnt show same values [message #349596 is a reply to message #349570] Mon, 22 September 2008 05:33 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome, but - we have solved nothing. Being kind of blind, if you know what I mean. It is YOU who has the data, query, report ... our knowledge is limited to what you choose to tell us. As it wasn't much (so far), I'm afraid I can not help you any further.
Previous Topic: How Record Data Center in Report
Next Topic: DRILL DOWN REPORTS
Goto Forum:
  


Current Time: Wed May 01 15:18:20 CDT 2024