Solved

Processing a Text File as Input for a Crystal Report 10.2????

Posted on 2007-04-05
9
409 Views
Last Modified: 2010-05-19
This is the first time I've ever had to use a Text File as input for a Crystal Report and I have no idea how to do this. I got as far as creating a new connection using ODBC and then after that it asked for the SQL statement. I'm not sure from that point on.

Please HELP!!!!

Thanks,
Blake
0
Comment
Question by:BlakeMcKenna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 8

Expert Comment

by:MOA81
ID: 18858841
you dont have to go through the ODBC

go to create a new connection  then choose 'Access/Excel' data source
then from the drop down list choose 'Text'
then the report will open as empty and the fields are placed in the fields box
0
 

Author Comment

by:BlakeMcKenna
ID: 18859249
I just tried it and it gave me the Error:

"Logon Failed.
 Details: No database was specified."
0
 
LVL 8

Expert Comment

by:MOA81
ID: 18859275
is your text tab delimited

or its based on semi colons

I mean there has to be a way the text is structured otherwise its not a database

agree?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:BlakeMcKenna
ID: 18859651
Yes, it's not a DB. The input file is a fixed field length text file. It's not comma or tab delimited.
0
 
LVL 8

Expert Comment

by:MOA81
ID: 18859673
then try importing this into Excel and then slice it up as you require
then make the excel your data source

can this help in your scenario
0
 

Author Comment

by:BlakeMcKenna
ID: 18859765
No, because I want to process a text file without having to import into excel or store the data in a DB. There should be a way to do this.
0
 
LVL 8

Expert Comment

by:MOA81
ID: 18859827
can place some of the text content here

some sample data so we can try please

thanks
0
 

Author Comment

by:BlakeMcKenna
ID: 18859912
Can I upload the file?
0
 
LVL 8

Accepted Solution

by:
MOA81 earned 500 total points
ID: 18859942
No need,

Please follow these steps:
1- open a blank report
2- it will ask you for a connection choose Access/Excel
3- click ... to allocate the file and change the type to Text
4- then it should open the file even if its not delimited or spaced or semi colon

I dont know why you are getting the error

did you follow these steps
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question