Crystal v.7 and VB v.6

Can't seem to view reports within my VB code.

At first, I tried:

With crReport
.ReportFileName = App.Path & "\Alert.rpt"
.UserName = "mickeym"
.Password = "minniem"
.ReportTitle = "Alert Report"
.Destination = crptToWindow
.PrintReport
End With

But I get error 20599, Cannot open sql server.

So then I tried:

Set CRApp = CreateObject("crystal.crpe.application")

Report.Database.SetDataSource RS

Call CRApp.LogOnServer("pdssql.dll", "Dev01", "Alert", "mickeym", "minniem")

CRViewer1.ReportSource = Report
CRViewer1.ViewReport

But I get error -2147192184, Server has not yet been opened.

Any ideas?

Thanks,
JeremyDP

I am sorry I can't help you with your problem !

but I hope YOU can help me. I am working on .net and I need to remake and make reports with Crystal Reports, but I never used that program before.

Do you have any help for me, any tutorials or anything like that, that could help me may be ?

thank you !

BTW : I tryed to pm or email you, but you don't authorise it. that's why I write here.

Hi
First of all try calling to "Report.Database.SetDataSource" with a parameter like so: Report.Database.SetDataSource RS,3 (not much documentation on that one but that is way to do it...).
If that doesn't solve the "Server has not yet been opened" error, it could be due to a mismatch in the fields the report is based on and the fields passed in the recordset so check it carefully.

Good Luck

you can always check that book.

It's free and if you register for free you will have access to even more information.

it's more basic stuff but their is still some advanced information that might help you.

http://www.crystalreportsbook.com/Chapters.asp

Some Crystal repost & vb tutorial link: http://www.vbexplorer.com/VBExplore...tal_reports.asp

http://www.freevbcode.com/ShowCode.Asp?ID=4840

http://www.dotnet247.com/247reference/guide/105.aspx

http://www.remedy.com/customers/dht.../06-23-2003.htm

http://codeguru.earthweb.net/forum/...?threadid=24213

Hi,

I am searching for a website. I have a work to do and there was plenty of information on that website.

it was called "free crystal report book" I think it was www.freecrystalreportbook.com but that's not working any more.
and I can't find it anymore

any body know ? it's very important for me.

I can't access this site:www.freecrystalreportbook.com..It maybe doesn't exist!..