Select with "startswith a through h" 1

[UHsoccer]

How do I create a select statement that lets me select companies names starting with a,b,c,etc through whatever.

I typically would need do select: a-h, then i-n, then o-z


I am running V8.5

 

[dgillz]

Insert, field object, parameter field, and make the parameter field a text datatype that accepts range values.

Step 2 is to write a record selection formula for the report.:

{Table.Namefield} in {?RangeParmField}

From then on the parameter will prompt the user when the report is run and the user would pick the range.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[synapsevampire]

Slight adjustment to the proposed notion:

left({Table.Namefield},1) in {?RangeParmField}

-k

 

[UHsoccer]

Thanks this works great