llmclaughlin
Programmer
Can not figure this one out, I have three option button. (1) Show All (2) Active Only (3) Inactive Only.
Getting it to show active and inactive is no problem, but when Show All is used I need to show both active and inactive. It needs to filter on 1 and 0. Where I have the question mark is where I need advice.
If optActive.Checked = True Then
facility1.RecordSelectionFormula = "{Facilities.active}= '1'"
End If
If optInactive.Checked = True Then
facility1.RecordSelectionFormula = "{Facilities.active}= '0'"
End If
If optAll.Checked = True Then
?
End If
CrystalReportViewer1.ReportSource = facility1
Thanks
Louie
Getting it to show active and inactive is no problem, but when Show All is used I need to show both active and inactive. It needs to filter on 1 and 0. Where I have the question mark is where I need advice.
If optActive.Checked = True Then
facility1.RecordSelectionFormula = "{Facilities.active}= '1'"
End If
If optInactive.Checked = True Then
facility1.RecordSelectionFormula = "{Facilities.active}= '0'"
End If
If optAll.Checked = True Then
?
End If
CrystalReportViewer1.ReportSource = facility1
Thanks
Louie