OraFAQ Forum: Reports & Discoverer » Supress duplicate in output file

Home » Developer & Programmer » Reports & Discoverer » Supress duplicate in output file (Oracle reports 9i)

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

Supress duplicate in output file [message #443520]

Tue, 16 February 2010 02:17

user201
Messages: 4
Registered: February 2010

Junior Member

In Oracle report, there is no duplicate rows I am seeing in the report output screen but getting duplicate rows in output file generated. Can anyone tell me why?

Report message to a moderator

Re: Supress duplicate in output file [message #443539 is a reply to message #443520]

Tue, 16 February 2010 03:10

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It doesn't make sense. If the same report is executed twice:
- once where output goes to screen and
- next time where output goes into a file,
the same report *must* return the same record set.

Report message to a moderator

Re: Supress duplicate in output file [message #443545 is a reply to message #443539]

Tue, 16 February 2010 03:18

user201
Messages: 4
Registered: February 2010

Junior Member

yes it is the same report.Observed that after each page there was a duplicate rows occured.

Report message to a moderator

Re: Supress duplicate in output file [message #443548 is a reply to message #443545]

Tue, 16 February 2010 03:36

user201
Messages: 4
Registered: February 2010

Junior Member

When tried to debug printing the message in the format trigger code it was observed that the last value of a page was carried forward to the next page and thus got the duplicate two time ie, at the end of the page and the begining of the next page

Report message to a moderator

Re: Supress duplicate in output file [message #443581 is a reply to message #443520]

Tue, 16 February 2010 06:46

user201
Messages: 4
Registered: February 2010

Junior Member

Is there any way to supress duplicate rows in output file?

a format trigger is created and have the out put file generation logic.

out_file:= :a|| :b;

I want to skip the duplicate in format trigger.Is there a way?

Report message to a moderator

Re: Supress duplicate in output file [message #443646 is a reply to message #443581]

Tue, 16 February 2010 12:47

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I think I'm more and more confused with every new message you post, as it reveals some information you never told us.

Would it be possible to explain what this report does and how? Because, now you have a format trigger, concatenate certain values (what are ":a" and ":b"?), etc.

I really wouldn't know what to say.

Report message to a moderator

Re: Supress duplicate in output file [message #561865 is a reply to message #443646]

Wed, 25 July 2012 21:28

ollivier
Messages: 19
Registered: January 2012
Location: chihuahua

Junior Member

I'm using Reports 9i, using DESFORMAT=DELIMITED, and i had same problem !
I don't know how it happend, cause TOAD or SQL displays single rows, and reports duplicate rows,
this rows are not always the same !

If someone know how to resolve it ! Would be great !

Report message to a moderator

Re: Supress duplicate in output file [message #561874 is a reply to message #561865]

Thu, 26 July 2012 00:58

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is this query the only query in the report? Or, is there (at least) another - parent - one (and these two are linked)? If so, maybe the "parent" query is responsible for duplicates?

Report message to a moderator

Re: Supress duplicate in output file [message #561984 is a reply to message #561874]

Thu, 26 July 2012 10:50

ollivier
Messages: 19
Registered: January 2012
Location: chihuahua

Junior Member

i'ts a single query select a || ';' || b || ',' || c || text
from table to check I tried in a 19 rows table, and repeat some rows !
I resolve it. replacing DELIMITED to PDF, and I run it (info OK), then I change to DELIMITED and No duplicated Rows !

It's clear a BUG is present ! May be I need a patch !

Report message to a moderator

Previous Topic:	REP-1213 FEILD REFERENCES COLUMN AT A BELOW ITS FREQUENCY
Next Topic:	How to create directly pdf file in reports 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 11:09:46 CDT 2024