OraFAQ Forum: Reports & Discoverer » Duplicate Rolls in report

Home » Developer & Programmer » Reports & Discoverer » Duplicate Rolls in report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Duplicate Rolls in report [message #240447]

Thu, 24 May 2007 19:30

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

Attachment: PLANS Assets By Department report.doc
(Size: 227.50KB, Downloaded 2049 times)

Report message to a moderator

Re: Duplicate Rolls in report [message #240473 is a reply to message #240447]

Fri, 25 May 2007 00:26

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Duplicate Rolls in report [message #240674 is a reply to message #240473]

Fri, 25 May 2007 08:37

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 2017 times)

Report message to a moderator

Re: Duplicate Rolls in report [message #240796 is a reply to message #240674]

Fri, 25 May 2007 16:52

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Duplicate Rolls in report [message #240816 is a reply to message #240796]

Sat, 26 May 2007 01:31

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

If you run the underlying select statement "solo" in SQL*Plus, does that return duplicate rows too?

Report message to a moderator

Re: Duplicate Rolls in report [message #241403 is a reply to message #240816]

Tue, 29 May 2007 08:29

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

Report message to a moderator

Re: Duplicate Rolls in report [message #241557 is a reply to message #241403]

Wed, 30 May 2007 00:45

skooman
Messages: 913
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

Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA

Senior Member

Please review the following asset:

SPEX CERTIPREP 03063 6750-115

Anne

Report message to a moderator

Re: Duplicate Rolls in report [message #241716 is a reply to message #240447]

Wed, 30 May 2007 08:26

sandeepshahare
Messages: 20
Registered: December 2006
Location: pune

Junior Member

i think u have to use page protect in propery pallet.

Report message to a moderator

Re: Duplicate Rolls in report [message #241754 is a reply to message #241716]

Wed, 30 May 2007 09:59

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

Report message to a moderator

Re: Duplicate Rolls in report [message #241757 is a reply to message #241716]

Wed, 30 May 2007 10:07

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

Attachment: Property Palette.JPG
(Size: 263.64KB, Downloaded 748 times)

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:27:50 CST 2024