Hi all,

This is Padma
I have a problem regarding crystal reports.

I have added a crystal report designer into my project.I have used MSaccess as the database and when I have added crystal report as a designer,code has been automatically added with CRViewer9 control to view the report.

Now my problem is that i have to change the datasource of the report at runtime

Code is like this

Dim Report as CrystalReport1

CRViewer91.Source=Report
CRViewer91.ViewReport

I have tried adding a line of code to change the database

Report.Database.SetDataSource(App.Path & "\DB.mdb")

but not working

If anybody can help me i would be thankful

hai,
  try this. this may help you.

Dim appl As New CRAXDRT.Application
Dim rep As New CRAXDRT.Report
Dim cpars As CRAXDRT.ParameterFieldDefinitions
Dim cpar As CRAXDRT.ParameterFieldDefinition

rep.Database.Tables(1).Location = App.Path & "\DataBase.mdb"

CRViewer91.ReportSource = rep

rep.DiscardSavedData
rep.EnableParameterPrompting = False
'If you use any parameter
rep.ParameterFields(1).AddCurrentValue "Instring"

rep.Database.SetDataSource rs
CRViewer91.ViewReport

regds
harish