FLAT FILE AS DATA SOURCE

[saradaga]

HI,
CAN ANY ANYONE PLEASE LET ME KNOW IF WE CAN USE A FLAT FILE AS DATA SOURCE FRON CRYSTAL REPORTS 2008.
IF SO PLEASE LET ME KNOW THE PROCEDURE AND HOW IF A NEW FLAT FILE COMES.
CAN WE USE MULTIPLE FLAT FILES AS DATA SOURCES??

PLEASE LET ME KNOW..
THANKS A LOT

RAMS.

 

[chelseatech]

ODBC can create a connection to a txt or csv file. You can use any ODBC source from inside Crystal Reports.

If your data is fixed column position and lenghts you would need to write some code to extract the fields and laod them into a COM data source, which you can then use for reporting. Contact me direct if you need help with this approach.

An easier solution is to load your text file into a MS Access database. You could set up automation for this.

Remember Crystal is a DATABASE report tool. Your data needs to look like a database to create reports from it.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[saradaga]

Thanks a lot chelseatech for your suggession.
How to write code to extract the fields and load them into a COM data source?
How could we automate to load data in MS Access?
Please let me know.
How can I contact you directly.

Thanks,
Rams.