[RESOLVED] Crystal Report - Passing parameter

Hi,

please tell me the syntax of SetReportVariableValue in crystal report. I am getting Run-time error '70' permission denied when I try this. any other way to pass parameter to the report? (I'm using CR 9 with VB 6)

Thanks in advance!

Binish

to pass parameter to crystal you can use
crystal.formula(0)="<formulaname>"="ganesh"
crystal.formula(1)="<formulaname>"="21"

I am getting a subscipt out of range error. It is not a formula field, I am using a parameter field for the selection criteria

i am sorry why dont you create formula field in the crystal report and name it and pass the value for the field using my earlier post.

Moved to reporting section

This is how is setup my report Paramters:

VB Code:

Set m_Rep = m_App.OpenReport(mRepName, 1)
    m_rep.ParameterFields.GetItemByName("Owner").AddCurrentValue (gstrMarker)

m_rep is a form level variable that is set as the report. Owner is the name of the parameter that I am trying to set and gstrMarker is the value I am setting Owner to.

That works like a charm! :) Thank You very much. thanks to all of u.