Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: make text file as datasource in crystal report Post Reply Post New Topic
Author Message
ankita
Newbie
Newbie


Joined: 13 May 2011
Online Status: Offline
Posts: 37
Quote ankita Replybullet Topic: make text file as datasource in crystal report
    Posted: 18 Jul 2012 at 10:42pm
hi pls tell me how to make text file as data source.

Below data is pasted from text file as i am unable to attach file.Pls do the needful and help me.


Wed Jul 18 00:00:03 2012 SNMPv2-SMI::enterprises.9.9.42.1.2.10.1.1.10 = Gauge32: 40       10.60.6.30 (UWL-DR-IN-Core-Switch-01)
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 19 Jul 2012 at 3:04am
I don't think that a straight text file can be a datasource. I know that xml can be, and excel files, but there is some structure to those files...
but I have been wrong before
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 24 Feb 2014 at 11:22am
was looking for this myself found this and it worked for me.

"You would need to set up a file dsn (in XP it's under Control Panel/Administrative Tools/Datasources (ODBC)) and then use the file dsn (Microsoft Text Driver) for the datasource as an ODBC(RDO) connection."
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 24 Feb 2014 at 1:28pm
I have used test as a data source (formatted as a csv.  Create New Connection, Access/Excel (DAO), Choose Text on the Database Type drop down.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.