CODEWITHSUNDEEP
sqlvb.netcrystal-reports
Fred Lorenz
Fred Lorenz

Reputation: 13

Crystal Report, how to use two condition selection formula?

Crystal Report, how to use two condition selection formula?

i want to use my Employee ID and the Date for the condition. how can i combine the two?

CrystalReportViewer1.SelectionFormula = "{PayrollHistory.ID} ='" & txtempid.Text() & "'"

and

CrystalReportViewer1.SelectionFormula = "{PayrollHistory.EndDate} ='" & txtDate.Text() & "'"

Upvotes: 0

Views: 549

Answers (1)

Boris Serafimov
Boris Serafimov

Reputation: 635

You can concatenate conditions with AND :

CrystalReportViewer1.SelectionFormula = "{PayrollHistory.ID} ='" & txtempid.Text() & "' AND {PayrollHistory.EndDate} = '" & txtDate.Text()

Upvotes: 0

Related Questions