Home » Developer & Programmer » Reports & Discoverer » Supress duplicate in output file (Oracle reports 9i)
Supress duplicate in output file [message #443520] Tue, 16 February 2010 02:17 Go to next message
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?
Re: Supress duplicate in output file [message #443539 is a reply to message #443520] Tue, 16 February 2010 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 19536
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.
Re: Supress duplicate in output file [message #443545 is a reply to message #443539] Tue, 16 February 2010 03:18 Go to previous messageGo to next message
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.

Re: Supress duplicate in output file [message #443548 is a reply to message #443545] Tue, 16 February 2010 03:36 Go to previous messageGo to next message
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
Re: Supress duplicate in output file [message #443581 is a reply to message #443520] Tue, 16 February 2010 06:46 Go to previous messageGo to next message
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?


Re: Supress duplicate in output file [message #443646 is a reply to message #443581] Tue, 16 February 2010 12:47 Go to previous messageGo to next message
Littlefoot
Messages: 19536
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.
Re: Supress duplicate in output file [message #561865 is a reply to message #443646] Wed, 25 July 2012 21:28 Go to previous messageGo to next message
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 !
Re: Supress duplicate in output file [message #561874 is a reply to message #561865] Thu, 26 July 2012 00:58 Go to previous messageGo to next message
Littlefoot
Messages: 19536
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?
Re: Supress duplicate in output file [message #561984 is a reply to message #561874] Thu, 26 July 2012 10:50 Go to previous message
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 !
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:
  


Current Time: Mon Sep 01 22:18:49 CDT 2014

Total time taken to generate the page: 0.08795 seconds