Adding a suppression condition to a group.

[Tenloe]

I am writing an upgrade utility in VB so that people don't have to do all of the upgrade manually. I am on Crystal 11.

I have added this code for the group.

Private Sub AddOccGroup(objRpt As CRAXDRT.Report)

Dim strGroup As String
strGroup = "XXXPCLM.OCCURNUM"

objRpt.AddGroup 5, strGroup, crGCAnyValue, crAscendingOrder

I need to know how to add a suppression to the gourp that says {@OCCURRENCE} = 'N'

Does anyone know how I would do this? Can't quite find what I am looking for.

 

[Madawc]

I don't know VB, but since no one else has answered, I'll try.

In Crystal, choose Reports > Selection Formulas > Group

A formula of {@OCCURRENCE} <> "N" should do what you want.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Tenloe]

Yes, in Crystal that is correct, but I need to know how to do it from VB. It is so we can upgrade Crystal reports without the user having to change all of theirs manually.