I have been trying to browse a Crystal Report with following VB code:

 CrystalReport1.ReportFileName = "C:\Report1.rpt"
 CrystalReport1.ReportTitle = "Title of the Report"
 CrystalReport1.Action = 1

I do not see any change in the title. How can I pass a title from VB to my report?

The way I do this is
1) In you crystal report create a parameter field, here it is called "username"
2) Then in you code use this

crxReport.ParameterFields.GetItemByName("username" ).AddCurrentValue "Printed by: IOates"
crxReport.EnableParameterPrompting = False
crxReport.Database.SetDataSource gRst, 3, 1

With CRViewer
 .Visible = True
 .ReportSource = crxReport
 .ViewReport
End With

Hope this helps
Ian

Thanks Ian
I tried to use your code by opening my Crystal Report file with CrxApplication.OpenReport method. I am getting the error message "Server has not yet opened" while executing CRViewer1.ViewReport

My backend is a Oracle Server. I don't know how to send the password by code.

If you have any suggestions, please let me know.

Regards

Niaz

Hi (sorry for late reply)
First you need to setup your connection string to Oracle (try this link http://www.connectionstrings.com for examples).

My variable gRst in the example is the returned recordset that contains the data, before you even touch CR make sure that your recordset contains data (eg. msgbox gRst.RecordCount),

hope this helps
Ian

Hi there,

I am very interested in the website that ioates told.
Anyway could any one tell me how many way that we can connect from VB to Crystal Report. As i know there are two ways, but i don't know the exact code for that. Hope to get some help....

Pheap