VBBRett
asked on
How do I get a count in Crystal Reports til the report reads all of the records. I need a loop function in Crystal Reports see inside
i am developing a Crystal Report and I want to be able to provide the following function, but I need help writing this function in VB.
groupcountnumber = 0
if( {Command.Status} <> "PRS" or {Command.ACTIONCODE} = "ZDEC" or {Command.ACTIONCODE} = "ZCLO") Then
groupcountnumber = groupcountnumber +1
End If
Formula = groupcountnumber
What I need is for a loop to read through all the records and keep on counting with an increment of 1 as long as the above If statement is accomplished. I am not sure exactly how to write out this function in VB for Crystal Reports. Can anybody help?
groupcountnumber = 0
if( {Command.Status} <> "PRS" or {Command.ACTIONCODE} = "ZDEC" or {Command.ACTIONCODE} = "ZCLO") Then
groupcountnumber = groupcountnumber +1
End If
Formula = groupcountnumber
What I need is for a loop to read through all the records and keep on counting with an increment of 1 as long as the above If statement is accomplished. I am not sure exactly how to write out this function in VB for Crystal Reports. Can anybody help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
mlmcc