Report Generates Duplicate Rows

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 26 Apr 2006 04:33:01 -0700
Message-ID: <1146051181.729128.283840_at_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 - 13:33:01 CEST

Original text of this message