Adding Crystal Report component

[John Reynolds]

Is it possible to use Crystal Report designer with data from file, or must it come from a database? I wanted to use it to print an amortization schedule from user data that resides in memory and is saved to a file.

Also, can anyone suggest a web site or good book to get up to speed using Crystal Reports?

Thanks for your input!
John

[JennyM]

Hi,

I was searching for something to do with crystal reports and came acrosee this piece of code which may help you:

recordset = CreateObject("ADODB.Recordset.2.0")
recordset.Open "EXEC OPEN LIBRARY/FILE(""NAMES.DAT"")", connection, adOpenDynamic, adLockOptimistic, adCmdText

And then just add the recordset to your report document through .SetDataSource

Dont know if this will help you, but, thought I would send it to you anyway,

Jenny

[John Reynolds]

Jenny,

Thanks very much. I will certainly give it a try. Looks like it should work!

John

[JennyM]

That's alright, just hope it helps you!