Crystal Reports for Eclipse Designer Guide

Make Range operator (x To y)

Usage
x to y
Creates the range x to y.
Examples
100.00 to 250.00
The range of consecutive numeric values beginning with 100.00 and ending with 250.00, including the end values.
CDate(1990, 09, 01) to CDate(1990, 09, 20)
The range of consecutive dates beginning with September 1, 1990, and ending with September 20, 1990. Both September 1 and September 20 are included in the range.
"Aaron" to "Lusk"
The range of consecutive text values beginning with “Aaron” and ending with “Lusk”, including the beginning and end values.
Comments
  • You cannot create a formula that has a range as a result. Thus, Make Range is always used in conjunction with other operators such as the In Range operator. The combination of Make Range and In Range produces a formula that gives a single TRUE or FALSE value, not a range.
  • The program comes with a number of Date Ranges, such as YearToDate, that are preset for your convenience.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/