Related Information Examples & Tutorials
Want new features? Check out the news on the latest version of Collect! available. Members can download new enhancements FREE! Interested in new features available but not currently on a Membership? Please contact us for pricing. Enhancements may be purchased separately.
“ Comtech's website has been very helpful in our training department. ” Craig W.

How To Exclude Multiple Transaction Types From Reports

This code snippet will exclude multiple transaction types from a report.

You can exclude more than one transaction type using the same transaction loop. There are two ways to do this.

1. When the transaction types are sequential, you can use a range.

Example:

@tr no total WHERE ( @tr.ty != 101 .. 109 )

This WHERE clause will skip all transactions with Type 101 up to and including 109.

2. When the transaction types that you want to exclude are not sequential, you can use multiple WHERE clauses in the same loop.

Example:

@tr WHERE (@tr.ty != 101) WHERE (@tr.ty != 398)

With these two WHERE clauses, this code will skip all transactions with Type 101 or Type 398.

See Also

- Report Topics Index

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org

Collection Advisor
HIPAA One® Certified Seal
ACA Member DBA RMA