Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Report Generates Duplicate Rows

Report Generates Duplicate Rows

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 26 Apr 2006 04:33:01 -0700
Message-ID: <1146051181.729128.283840@g10g2000cwb.googlegroups.com>


Each,

I have a report which when generated and run as 9i report on Linux generates duplicate rows. Whereas the same report running on 6i client server works perfectly fine. Running against the exact same database.

The report generates a delimited CSV file.

On Client Server
Reports 6.0.8.12.1
Windows XP

On 3 tier
Reports 9.0.2.3.0
Red Hat Linux

Database 9.2.0.4.0

Examples Here. This line generated in client server.

Feb-06 ELDC DATA TRANSFER 0 0 0 0 0 0 0 0 0

Yet on 3 tier 9i. Also note the asterisk.

Feb-06	ELDC	DATA TRANSFER	0	0	0	0	0	**	0	0	0
Feb-06	ELDC	DATA TRANSFER	0	0	0	0	0	**	0	0	0
Feb-06	ELDC	DATA TRANSFER	0	0	0	0	0	**	0	0	0
Feb-06	ELDC	DATA TRANSFER	0	0	0	0	0	**	0	0	0
Feb-06	ELDC	DATA TRANSFER	0	0	0	0	0	**	0	0	0
Feb-06	ELDC	DATA TRANSFER	0	0	0	0	0	**	0	0	0

Any ideas what is happening here. Received on Wed Apr 26 2006 - 06:33:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US