Home » Developer & Programmer » Reports & Discoverer » Duplicate Rolls in report
Duplicate Rolls in report [message #240447] Thu, 24 May 2007 19:30 Go to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
I am currently getting a duplicate row in the followng report. I have attached and highlighted in yellow. Please advise on how to fix in Oracle Reports Builder 6i. In my query I have select distinct....

Not sure on why the report is showing a duplicate row. Any advice will help.

Thanks
Anne
Re: Duplicate Rolls in report [message #240473 is a reply to message #240447] Fri, 25 May 2007 00:26 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd look at it if it wasn't potentially dangerous MS Word document. Could you attach something harmless (JPG, for example).
Re: Duplicate Rolls in report [message #240674 is a reply to message #240473] Fri, 25 May 2007 08:37 Go to previous messageGo to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
See attached file. I put it in notepad...I don't have .jpeg. All you need to do is scan the file before opening it to make sure there are no viruses.

Anne
  • Attachment: report.txt
    (Size: 53.00KB, Downloaded 669 times)
Re: Duplicate Rolls in report [message #240796 is a reply to message #240674] Fri, 25 May 2007 16:52 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, so your Windows are shipped without the Paint program which would allow you to edit a screenshot and save it as a JPG? Shame on Microsoft!

Scanning your files for viruses is definitely something I don't have to do (and I will not do that).

But never mind our little chat; as TXT files don't support highlightning, could you point to those duplicate rows? I looked at the file and didn't find any.
Re: Duplicate Rolls in report [message #240816 is a reply to message #240796] Sat, 26 May 2007 01:31 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
If you run the underlying select statement "solo" in SQL*Plus, does that return duplicate rows too?
Re: Duplicate Rolls in report [message #241403 is a reply to message #240816] Tue, 29 May 2007 08:29 Go to previous messageGo to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
In Sql Plus it does not create duplicate rows.
Thanks for responding and trying to help.

Anne
Re: Duplicate Rolls in report [message #241557 is a reply to message #241403] Wed, 30 May 2007 00:45 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
I can't find any duplicates in the examples you posted, can you point us to them (linenumber or something)?

Edit: found them (in word highlighted, like Littlefoot pointed out, jpeg is a bit more accepted format for examples on this forum... please use it next time).

It looks as if the rows are sort of half-duplicated if the description is word wrapped over a page break. Report-guru's, it's up to you (I don't do Reports, just SQL & Discoverer), what's going on here?

[Updated on: Wed, 30 May 2007 00:49]

Report message to a moderator

Re: Duplicate Rolls in report [message #241712 is a reply to message #241557] Wed, 30 May 2007 08:19 Go to previous messageGo to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Please review the following asset:

SPEX CERTIPREP 03063 6750-115

Anne
Re: Duplicate Rolls in report [message #241716 is a reply to message #240447] Wed, 30 May 2007 08:26 Go to previous messageGo to next message
sandeepshahare
Messages: 20
Registered: December 2006
Location: pune
Junior Member
i think u have to use page protect in propery pallet.
Re: Duplicate Rolls in report [message #241754 is a reply to message #241716] Wed, 30 May 2007 09:59 Go to previous messageGo to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Do you mean Page Protect in Property pallet for the repeating line?

Anne
Re: Duplicate Rolls in report [message #241757 is a reply to message #241716] Wed, 30 May 2007 10:07 Go to previous message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
See attached file to see the Property Palette setup. Page Protect is set to Yes.

Anne
Previous Topic: REP-50004: No report specified on the command line
Next Topic: Can i do this
Goto Forum:
  


Current Time: Sun Dec 04 00:16:56 CST 2016

Total time taken to generate the page: 0.04597 seconds