Skip to Content
0

How to range List of number in Crystal Report XI

Jul 26, 2017 at 03:02 PM

16

avatar image
Former Member

ID Series No.

1 501

2 502

3 504

4 505

5 507

Result

From - To

501 - 502

504 - 505

507 - 507

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Jul 26, 2017 at 03:10 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded