Use data from .txt file into Crystal reports
I want to pull data from a .txt file and include in a Crystal report daily. The .txt file is a simple 5 row file with specific fields, I want to use the header and then each item with it's value next to it.
07/25/2016 13:08:22 : BATCH CLOSE SUMMARY
MerchantID - 7216789076309317
BatchNo - 207001
BatchItemCount - 000005
NetBatchTotal - 1236.00
C--Users-JohnPretorius-Desktop-CCTes.txt
07/25/2016 13:08:22 : BATCH CLOSE SUMMARY
MerchantID - 7216789076309317
BatchNo - 207001
BatchItemCount - 000005
NetBatchTotal - 1236.00
C--Users-JohnPretorius-Desktop-CCTes.txt
Last Comment
ASKER
I looked at this and it seems straight forward, I'm having trouble getting the format .txt field configured in ODBC. Below 6 rows shows the content of each text file. Line 1 is the timestamp which will be my header and then I will have 2 columns for rows 3 - 6, Description and Value separated by a '-'
07/25/2016 13:08:22 : BATCH CLOSE SUMMARY
MerchantID - 7216789076309317
BatchNo - 207001
BatchItemCount - 000005
NetBatchTotal - 1236.00
07/25/2016 13:08:22 : BATCH CLOSE SUMMARY
MerchantID - 7216789076309317
BatchNo - 207001
BatchItemCount - 000005
NetBatchTotal - 1236.00
How is the connection showing the data?
It may be easiest to simply treat it as a single column of text and use formulas in Crystal to break it apart if you need to.
mlmcc
It may be easiest to simply treat it as a single column of text and use formulas in Crystal to break it apart if you need to.
mlmcc
I just built a report using your sample data.
The first connection I built I let it choose the datatypes. It worked except the large number apparently is too big for a 32-bit system so it was rounded.
I built a second connection and defined the columns as string/text.
It shows the data just fine.
mlmcc
The first connection I built I let it choose the datatypes. It worked except the large number apparently is too big for a 32-bit system so it was rounded.
I built a second connection and defined the columns as string/text.
It shows the data just fine.
mlmcc
ASKER
All fields are empty when I run the report.
ASKER
Could you kindly share the ODBC text settings, I'm thinking that I probably have this wrongly configured.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank You very much.
ASKER
Thank you
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
First you have to create an ODBC connection to the text file using the Microsoft Text driver.
Once you have that then you can use it as any other ODBC data source.
http://scn.sap.com/thread/1070686
I believe you will have to transpose the data so it is in record format
One record per line
If all you want is to show the data then you could use it in the current format. You will have 2 columns one for the definition the other for the value.
mlmcc