Eclipse Community Forums: BIRT » Missed first row of a fixed length file without column name

Home » Archived » BIRT » Missed first row of a fixed length file without column name

Missed first row of a fixed length file without column name [message #160665]

Fri, 12 May 2006 11:04

Eclipse User

Originally posted by: Pasquale.Rombola.ip-assistance.com

I have a problem with a fixed length file (flat file) without column name.
BIRT get first row as column name but it isn't, so I miss first row in
report. How can I get first row ?

Regards and thanks in advance.

Pasquale

Re: Missed first row of a fixed length file without column name [message #161138 is a reply to message #160665]

Mon, 15 May 2006 14:48

Eclipse User

hi. i didn't had this problem. can you detail a little bit more your
situation please?

Cristian

Re: Missed first row of a fixed length file without column name [message #161300 is a reply to message #161138]

Tue, 16 May 2006 03:34

Eclipse User

Originally posted by: Pasquale.Rombola.ip-assistance.com

Hi Cristian, first of all thanks for your answer to my question, now I'll
try to show you my problem.
I have a fixed length file as data source, that is composed by many rows
of characters like below:

DEND21060504399399210603EUR02148.06.001399
DEND21060504399399210603EUR02148.06.001400
DEND21060504399399210603EUR02148.06.001401
DEND21060504399399210603EUR02148.06.001402

I create Data Source and Data Set without any problem but when I put Data
Set in my report I see all rows less the first row, i.e. I see in report
this:

DEND21060504399399210603EUR02148.06.001400
DEND21060504399399210603EUR02148.06.001401
DEND21060504399399210603EUR02148.06.001402

As you can see first row is missing, indeed BIRT use first row as column
name but it isn't, in my file not exist colunm name but only data. I tried
to get column name in different ways without success. Do you know the
solution or have you any idea to resolve the problem ?

Pasquale

Re: Missed first row of a fixed length file without column name [message #161407 is a reply to message #161300]

Tue, 16 May 2006 09:19

Eclipse User

what data source do you use?

Re: Missed first row of a fixed length file without column name [message #161446 is a reply to message #161407]

Tue, 16 May 2006 10:15

Eclipse User

Originally posted by: Pasquale.Rombola.ip-assistance.com

I use "Flat File Data Source", then I select a folder that contains a txt
file (data file), while charset is "UTF-8" (default charset). Therefore I
create a Data Set using the Data Source just created and Data Set Type:
"Flat File Data Set", so I select the data file with "*.txt" File filter.

Re: Missed first row of a fixed length file without column name [message #161473 is a reply to message #161446]

Tue, 16 May 2006 10:25

Eclipse User

try to use a dummy data as the first row

Re: Missed first row of a fixed length file without column name [message #161501 is a reply to message #161473]

Tue, 16 May 2006 11:02

Eclipse User

Originally posted by: Pasquale.Rombola.ip-assistance.com

That was simplest solution by me rejected because all times I have to open
the data file for insert a dummy row and that isn't fine, furthermore it's
boring. It would be necessary to insert a checkbox (enhancement) in Data
Set Properties with label: "First row has column names". As far as you are
concerned that enhancement is expected in future release?

Re: Missed first row of a fixed length file without column name [message #161509 is a reply to message #161501]

Tue, 16 May 2006 11:09

Eclipse User

sorry, but I'm not part of the BIRT team. I'm a BIRT user.

Previous Topic:	need help - How-to with Birt 2.1RC2
Next Topic:	Chart Engine problem (after upgrading to Fedora Core 5).

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 09 21:39:47 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter