[RESOLVED] Crystal Report - Passing parameter

[Binish]

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

[ganeshmoorthy]

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

[Binish]

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

[ganeshmoorthy]

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.

[Hack]

Moved to reporting section

[GaryMazzone]

This is how is setup my report Paramters:

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.

[Binish]

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