Crystal Report XI having an Error Access Denied .SetReportVariableValue("parameter","value") Please Help Urgent... [modified]

[vbDiggerz]

Public crxApp As CRAXDRT.Application Public crxReport As CRAXDRT.Report Public crxDataBase As CRAXDRT.Database Public crxTable As CRAXDRT.DatabaseTable Public crxTables As CRAXDRT.DatabaseTables Public strSelectionfrm As String Public strCRSourcePath As String Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.MdiParent = frmMain crxApp = New CRAXDRT.Application crxReport = crxApp.OpenReport(strCRSourcePath, 0) crxReport.RecordSelectionFormula = strSelectionfrm crxDataBase = crxReport.Database crxTables = crxDataBase.Tables For Each crxTable In crxTables crxTable.Location = DataSource crxTable.SetLogOnInfo("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & reportPath, "myDatabase.mdb", "", "password") Next crxTable 'Error occur here! i dont know why im access denied.. but if i will ommitt the .SetReportVariableValue() then it works just fine without committing access denied but then i have to set some variable i've declare inside the report..:confused: crxReport.SetReportVariableValue("varEduc", "Hello Crystal World") AxCRViewer1.ReportSource = crxReport AxCRViewer1.ViewReport() crxDataBase = Nothing crxTable = Nothing crxTables = Nothing crxReport = Nothing crxApp = Nothing Catch ex As Exception MsgBox(ex.ToString()) Finally End Try End Sub *************** crxReport.SetReportVariableValue("varEduc", "Hello Crystal World") the varEduc is already declare inside the report which means it is existing variable inside report.. is anybody there who have a good idea or solutions about this??? please??? :sigh: Anybody there Please help me with this headache... :doh: -- modified at 3:00 Wednesday 26th September, 2007