0
CR.Reset
CR.ReportFileName = "StudentInformation.rpt"
CR.SelectionFormula = "{SPINF.GRNO}=" & Me.txtGRNo.Text & "" And "{SPINF.CMBCAT}=" & Me.cmbCat.Text & ""
CR.Action = 1

m trying to passing two parameter for cr..! bt it always shows the error type mis match.! plz help me

2
Contributors
8
Replies
9
Views
6 Years
Discussion Span
Last Post by AndreRet
0

Mismatch refers to an incorrect field name in your table, incorrect control name, the use of say "Text1.Caption" and not "Text1.Text", incorrect string value etc.

Post your full code here and where the error occurs.

0

dat is the full code sir..!

here is the error occur

CR.SelectionFormula = "{SPINF.GRNO}=" & Me.txtGRNo.Text & "" And "{SPINF.CMBCAT}=" & Me.cmbCat.Text & ""

i dunt know the rite method to pass two parameter in crystal report

0

CR.SelectionFormula = "{SPINF.GRNO}=" & Me.txtGRNo.Text & "" And "{SPINF.CMBCAT}=" & Me.cmbCat.Text & ""

Change to this and try.

CR.SelectionFormula = "{SPINF.GRNO} = '" & Me.txtGRNo.Text & "'" And "{SPINF.CMBCAT} = '" & Me.cmbCat.Text & "'"
0

Have a look at this tutorial on Crystal reports and the "SelectionFormula" statement over HERE.

Edited by AndreRet: n/a

0

This line work for me..! thanx andreRat

VReport.SelectionFormula = "{SPINF.GRNO}=" & Me.txtGRNo.Text & " And {SPINF.GRCAT}='" & Me.cmbCat.Text & "'"
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.