.Net and crystal report RecordSelectionFormula

[llmclaughlin]

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

 

[Bhavna13]

Try leaving the RecordSelectionFormula property blank (i.e. "" ). if you want them seperated then group by Facilities.active and it should put all the active ones together and all the inactive ones together but still show all of them.

hope this helps.