Text file input to Crystal Reports
I am evaluating Crystal Reports as a reporting tool for our company. One requirement is that it be able to take a delimited or fixed format text file as input (much like SAS) and create reports directly from the data in the text file. Is this possible? If so, how is it done?
Thanks in advance.
Prathamesh Acharya replied
1)First you will need to create a System DSN to point to the text file(s).
2)Go to Start>>Administrative Tools>>Data Sources(ODBC).
3)Go to System DSN tab in the "ODBC Datasource Administartor" dialogue box.
4)Click on Add and then choose Microsoft Text Driver(.txt,.csv).
5)And then follow the rest of the steps as mentioned in previous thread
6) Once you are done with this DSN configuration,then you will be able to see this DSN under ODBC connection option in crystal reports.
Let me know if more explanation is required