Read a text file in Crystal Reports

I wonder if anyone could help me.

I have a text file and want to read this file using Crystal Report 10. This text file is like a database.

The question is... Can I make a connection to this file and if so how is it done. I want to be able to put certain fields from the text file on the report etc.

If this cannot be done like above, Has anyone got any ideas how I could acheive this.

Thanks in advanceA suggestion might be to set up a quick database in access and import all the data from your text file and then make a conection to it.

As far as I am aware connection to a text file as it were a database is not possible as it has no tables or fileds

RDO or ADO

I am using Crystal Report 10 connected to SQL Server 2000
for report writing. I have the option to choose from ODBC
RDO and OLE DB ADO.
I would like to know which one should I choose ?
What is the difference between them and which one is more
efficient ?
Thanks
I suggest you use ADO since it is the successor to RDO.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:68a701c493bb$35cb4d60$a301280a@.phx.gbl...
>I am using Crystal Report 10 connected to SQL Server 2000
> for report writing. I have the option to choose from ODBC
> RDO and OLE DB ADO.
> I would like to know which one should I choose ?
> What is the difference between them and which one is more
> efficient ?
> Thanks
|||Peter,
Definitely ADO. Even though ADO is now obsolete (superceded by ADO.NET),
RDO is worse than obsolete. ADO replaced RDO years ago.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Peter wrote:
> I am using Crystal Report 10 connected to SQL Server 2000
> for report writing. I have the option to choose from ODBC
> RDO and OLE DB ADO.
> I would like to know which one should I choose ?
> What is the difference between them and which one is more
> efficient ?
> Thanks

RDO or ADO

I am using Crystal Report 10 connected to SQL Server 2000
for report writing. I have the option to choose from ODBC
RDO and OLE DB ADO.
I would like to know which one should I choose ?
What is the difference between them and which one is more
efficient ?
ThanksI suggest you use ADO since it is the successor to RDO.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:68a701c493bb$35cb4d60$a301280a@.phx.gbl...
>I am using Crystal Report 10 connected to SQL Server 2000
> for report writing. I have the option to choose from ODBC
> RDO and OLE DB ADO.
> I would like to know which one should I choose ?
> What is the difference between them and which one is more
> efficient ?
> Thanks|||Peter,
Definitely ADO. Even though ADO is now obsolete (superceded by ADO.NET),
RDO is worse than obsolete. ADO replaced RDO years ago.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Peter wrote:
> I am using Crystal Report 10 connected to SQL Server 2000
> for report writing. I have the option to choose from ODBC
> RDO and OLE DB ADO.
> I would like to know which one should I choose ?
> What is the difference between them and which one is more
> efficient ?
> Thanks

RDL Generator

I need more information of RDL Generator, i need to convert Crystal reports
to Reporting Services.an RDL file is an XML file and the entire definition is available on the MS
web site (and RS help)
There is a company dedicated to this job convertion:
http://www.rpttosql.com/
I don't remember the name of another company which has created a tool to do
this.
"Inés" <Inés@.discussions.microsoft.com> wrote in message
news:66F3FAF7-4EE1-40BD-8CB4-5C0062D4C48A@.microsoft.com...
>I need more information of RDL Generator, i need to convert Crystal reports
> to Reporting Services.

RDC Connection string data

I am using RDC for the Crystal Report 8. I use VB6 and connect to a MSSQL 2000 DB. I currently connect to the database by:

CRReport.Database.Tables(1).SetLogOnInfo sCRServer, sCRDatabase, sCRLogin, sCRPassword

and that works fine, but I would like to be able to pass the Workstation ID(WSID) and App name(APP) like can be done in a standard ado connection string.

i.e.
Cn = "uid=sa;pwd=admin;driver={SQL Server};server=NTSERVER5;WSID=" & Trim(sUserName) & "-" & getUserComputerName() & ";APP=" & App.EXEName & "-" & sServerName & ";database=" & sDatabaseName & ";dsn=,,connection=adConnectAsync"

Any ideas on how to pass that information for crystal to use it, when logging in?I also connected to crystal using :
CRReport.Database.LogOnServerEx "pdssql.dll", sCRServer, sCRDatabase, sCRLogin, sCRPassword, "uid=sa;pwd=admin;driver={pdssql.dll};server=" & sCRServer & ";WSID=" & Trim(sUserName) & "-" & getUserComputerName() & ";APP=" & "CR" & App.EXEName & "-" & sServerName & ";database=" & sDatabaseName & ";dsn=,,connection=adConnectAsync"

but MS SQL in the Prodcess Info, when the report runs stilll doesn't show the WSID and APP information on the server. I passed it above, but??

Any ideas.

thanks,

Dean

Rate() and PMT()

If you are familiar with Crystal reports or Visual basic, you may be familiar with the Rate and Pmt functions.

I need to duplicate them in SQL sever 7.

Anybody have code for this already? I hate re-inventing the wheel.

More (Unnecesary) details:
I have a client who has handed me the formula that I need to use for calculating Interest rates. Unfortunatly, the formula was written in Crystal reports, so now I need to pick it apart and do the work that CR does automaticly. Any help?Check this site, it should contain what you're looking for:

http://www.wheatworks.com/formula.htm