How to design reports using tab delimited files ?

[nagraj]

I have a tab delimited text file with coulumn heading as
the first row and data beneth it.
i want to have this file as a table (using text odbc driver)
this part is done. but when i try to incorporate this
particular text file it says it does not have fields.
file integrity error!

any idea??

 

[kenhamady]

Are you sure the ODBC is setup correctly?
Can you use this ODBC connection with anything other than CR as a test? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[nagraj]

Yes sir, it works fine for the IQ reports.
we are in transition from IQ (now called Eureka) to CR.
the report is not a output of some simple query.
so, i use the front-end programming logic (CA-openroad)
to get the desired out put in a text file.
and then use the crystal report (thru' ODBC text driver)
to display this outfile formatted in a nice report.
i understand that there is schema.ini which has a mapping
of fields on the report.
but they all look ok.

 

[kenhamady]

That is strange.
It says no fields?

No permissions problems, access to the file is OK?
No field names that have spaces/symbols/etc?

I am stumped. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[nagraj]

the exact error I am getting is as follows
when i open the report, i check the data location.
since that's not the location, i want it to be,
i change it .
it accepts the loaction direcotry
accepts the ODBC driver,(Microsoft text driver)
when i click on define format and click on guess,
it says file cannot be updated. check if the files are read
only.
when i click on Done, it says, the there are no fields
in file xxx.out
*.out is the text file that we use for this perpose.

 

[kenhamady]

"says file cannot be updated. check if the files are read only."

This might be a misleading error, but it sounds like you don't have rights to something here. I am afraid I won't be of much more help. I will have to let someone else weigh in on this one. Someone who has worked more with ODBC-text. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[nagraj]

Thanks a lot for your help on this.

 

[dcm]

nagraj: Define your ODBC text format definition before attempting to use this with Crystal. You should find that you can directly open the ODBC connection through the ODBC Administrator and when you set the file type to *.out remember to Add this to the list of acceptable text file extensions. Set the active extension to *.out before you go to define format and you should see the right hand panel contains F1, F2, F3 .... If you don't see this then there is definitely a file access problem. If you do then proceed to update the F1, F2... with your required field names and definitions.

The next time you use the connection in CR it should open to reveal your entries. If you need any more just ask David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[Guest_imported]

Hi Nagraj,

I have had the same problem with the Text ODBC driver. The file you are trying to make a table can have a maximum of 256 fields, or this message will occur. Try breaking your table into 256 field chunks with multiple text files, each having the same row key. Hope it helps.

 

[ihda]

Hope this helps....

a) In odbcadmin - click the file dsn tab
b) Set the network directory for the location of the odbc dsn (Not required, but good IS practice)
c) Create your user or system text dsn - note the location of your file directory. A file named schema.ini is created. This file contains file information and field names
d) Select Options
e) Select Format
f) Create names for the fields...these are saved to the schema.ini file in the location set in c above

I also had a followup problem with text files in Crystal 8...
I had a problem in CR8 where the only data field that was listed under text table was "FIELD1".

The solution was to rename the p2bbde.dll file to something else.

 

[IdoMillet]

Nagraj,

If the above suggestions don't work,
and if your file name extension is *.log,
try to change it to *.txt

I know this sounds odd, but trust me... )

Cheers,
- Ido