waely
Oct 17th, 2006, 03:04 PM
hi,
I have crystal report that I'm trying to pass parameters to it. the below code doesn't generate any errors but I don't see value for my @Name parameter on my report:
crParameterFieldDefinitions = MyReport.DataDefinition.ParameterFields
crParameterFieldDefinition = crParameterFieldDefinitions.Item("@Name")
crParameterValues = crParameterFieldDefinition.CurrentValues
crParameterDiscreteValue = New ParameterDiscreteValue
crParameterDiscreteValue.Value = "Jazmin"
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)
Catch ex As Exception
Dim sMessage As String
sMessage = ex.Message
End Try
'This function will populate my datatable works fine
Dim data As DataTable = dbHelper.GetProjectProfileReport(ids, div, func, funca)
projReport.SetDataSource(data)
' trying to pass @Name Parameter to the report but can't see it
projReport.SetParameterValue("@Name", crParameterDiscreteValue)
Thank you for your help in advance,
Waely
I have crystal report that I'm trying to pass parameters to it. the below code doesn't generate any errors but I don't see value for my @Name parameter on my report:
crParameterFieldDefinitions = MyReport.DataDefinition.ParameterFields
crParameterFieldDefinition = crParameterFieldDefinitions.Item("@Name")
crParameterValues = crParameterFieldDefinition.CurrentValues
crParameterDiscreteValue = New ParameterDiscreteValue
crParameterDiscreteValue.Value = "Jazmin"
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)
Catch ex As Exception
Dim sMessage As String
sMessage = ex.Message
End Try
'This function will populate my datatable works fine
Dim data As DataTable = dbHelper.GetProjectProfileReport(ids, div, func, funca)
projReport.SetDataSource(data)
' trying to pass @Name Parameter to the report but can't see it
projReport.SetParameterValue("@Name", crParameterDiscreteValue)
Thank you for your help in advance,
Waely