AS/400 Report Splitter SQL Selection Samples - Support

AS/400 Report Splitter SQL Selection Samples

From Support

Jump to: navigation, search

To specify a list of values when including criteria for a report to be split, the IN SQL keyword can be used.

Example:

@REP IN("100","200") will include all pages where @REP is either 100 or 200.
Personal tools