display multiple range values in report header

[2012385096]

Hi,

I am using CR Xi. I created a parameter to give the client flexibility to select range of company number they want to include in the report. In the parameter, i did Allow Range Values = True and Allow Multiple Values = True.

Now when i ran the report i passed below values to the parameter:
Start Of Range End Of Range
001 010
020 067
100 135

My report is working fine. It is showing the data between company number 001 to 010 or 020 to 067 or 100 to 135. But my question is now if i want to display all these range values in Report header, how would i get that? i tried couple of ways in 1 case it is showing just 001 to 010 and in one case it is showing 001(min value) to 135(max value).

But i need below result in report header
Range of Company Number: 001 to 010, 020 to 067, 100 to 135

I need immediate help on this. Your response will be greatly appreciated. Thank you so much in advance!!!

 

[lbass]

There is an faq on this: faq767-5684. You can use a formula like this:

whileprintingrecords;
stringvar x;
numbervar i;
numbervar j := ubound({?rangeparm});
for i := 1 to j do(
x := x + minimum({?rangeparm})+ " to " + maximum({?rangeparm}) + ", "
);
left(x, len(x)-2)

-LB

 

[2012385096]

Thank you LB so much for your help!! You save my life today.