How to pass parameters to subreport frm vb.net code?
-
hi, i m calling crystal report frm my vb.net(winforms) form. my report contains 1 subreport & both main & sub report contains the parameter, on which record selection depends. it is ok with my code to pass value to main report. but tell me please how to pass parameter value to subreport? i m passing parameter values by following code-? Dim myReport1 As New CRptTimesheetPerEmp Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues() Dim crParameterDiscreteValue As New ParameterDiscreteValue() crParameterDiscreteValue.Value = frmTimeSheetRpt1.cmbEmpId.Text crParameterFieldDefinitions = myReport1.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item(0) crParameterValues = crParameterFieldDefinition.CurrentValues crParameterValues.Clear() crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) CrystRptVEmpTimeSheet.ReportSource = myReport1
"The Difficult i can do it now... The Impossible will take a little longer."
-
hi, i m calling crystal report frm my vb.net(winforms) form. my report contains 1 subreport & both main & sub report contains the parameter, on which record selection depends. it is ok with my code to pass value to main report. but tell me please how to pass parameter value to subreport? i m passing parameter values by following code-? Dim myReport1 As New CRptTimesheetPerEmp Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues() Dim crParameterDiscreteValue As New ParameterDiscreteValue() crParameterDiscreteValue.Value = frmTimeSheetRpt1.cmbEmpId.Text crParameterFieldDefinitions = myReport1.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item(0) crParameterValues = crParameterFieldDefinition.CurrentValues crParameterValues.Clear() crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) CrystRptVEmpTimeSheet.ReportSource = myReport1
"The Difficult i can do it now... The Impossible will take a little longer."
its easy to set parameter in the crystal report rather than passing the parameter to subreport through coding jus try this first take a parameter as a field in the crystal subreport and link the subreport to the original report u can simply do that by right clicking on a subreport and establish a link