Skip to Content
avatar image
Former Member

How to range List of number in Crystal Report XI

ID Series No.

1 501

2 502

3 504

4 505

5 507

Result

From - To

501 - 502

504 - 505

507 - 507

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 26, 2017 at 03:10 PM

    I assume range will be for each two records.

    Suppress alternate records by placing this in suppress formula of details section expert

    whileprintingrecords;

    global numbervar n:=n+1;

    Remainder(n/2) <> 0;

    This should suppress each odd numbered record.

    Create formula and place in details

    @Range

    Previous(yourfield) &' - '&yourfield

    If your field is a number you will need to convert to text first

    tiotext(yourfield, 0, "") // removes decimals and thousand separator.

    Ian

    Add comment
    10|10000 characters needed characters exceeded