
Passing a variable from VB.NET to a Crystal report parameter or formula with no prompt
sample code (VB.NET)
Dim crParameterFieldDefinition As ParameterFieldDefinition
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterValues As New ParameterValues()
Dim crParameterDiscreteValue As New ParameterDiscreteValue()
crParameterFieldDefinitions = Report.DataDefinition.ParameterFields
crParameterDiscreteValue.Value = Month.GetMonthInWords(Month) + ", " +
CStr(Year)
Try
crParameterFieldDefinition =
crParameterFieldDefinitions.Item("MonthAndYear")
crParameterValues = crParameterFieldDefinition.CurrentValues
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)
Catch
End Try
Note:
Report will be your report.
You have to create the MonthAndYear parameter in your report otherwise it
will throw exception.
anand
Quote:
> Hello!
> All I want to is be able to pass a variable from VB.NET to a field in
> a crystal report (CR.NET) without the prompt being displayed.
> I have looked at
http://support.crystaldecisions.com/library/kbase/articles/c2010251.asp
Quote:
> for an example but this still brings up a prompt!
> Can anyone help me with this simple problem (I hope)!...
> Thanks
> Al.