Display Values of a Range or Varios Discrete Value Parameter 4

[jcmv007]

Using CRW 8.5.0.217

I want to display my parameter info in a report. Users need to input a range of values or different individual values. How can I do this?

Thanks,

 

[synapsevampire]

What type of parameter?

If you're using a string:

Join({?mymultiparm},",&quot

If a date range:

"From " + totext(minimum({?Mmydaterange}))+" to "+ totext(maximum({?Mmydaterange}))

If you need something else, please share some specifics.

-k

 

[jcmv007]

Hi Synapsevampire,

It's a number. I did convert it to a string and tried using the Join() function but I got an error message that it needed an array.

Thanks for your prompt response.

 

[synapsevampire]

OK, we'll need a loop for multiples, just use the minimum and maximum above for a range.

whileprintingrecords;
numbervar x := ubound({?MyNumericParm});
Stringvar MyOutput := ""
if x > 0 then
For x := 1 to ubound({?MyNumericParm}) do(
MyOutput := MyOutput+totext({?MyNumericParm}[x],0,"&quot
);
MyOutput

-k

 

[jcmv007]

Synapsevampire,

I'm getting an error message saying "A Number, currency amount, boolean, date, time, date-time, or string is required here."

This are the setting on my parameter:

Value type; Number

Under Options
------------------------
Allow multiple values: Checked
Discrete and Range Values: Checked

 

[dgillz]

Please post your formula

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[jcmv007]

Hello dgillz

Here is the formula:

whileprintingrecords;
numbervar x := ubound({?Localidad});
Stringvar MyOutput := "";
if x > 0 then
For x := 1 to ubound({?Localidad}) do(
MyOutput := MyOutput+totext({?Localidad}[x],0,"")+", "
);
MyOutput

 

[mbarron]

You are getting the error because the parameter is set to allow ranges or multiple values. Change this line:
MyOutput := MyOutput+totext({?Localidad}[x],0,"&quot+", "
to
MyOutput := MyOutput+totext(minimum({?Localidad}[x]),0,"&quot+", "



A little extra. The following formula will display multiple ranges and discrete values - with each range/value on it's own line. You would have to add totext's where applicable.


whileprintingrecords;
numbervar loop;
numbervar times:=ubound({?param});
stringvar out;
stringvar hold;

for loop:=1 to times do(
if loop<times then (
if minimum({?param}[loop])=maximum({?param}[loop]) then
hold:= minimum({?param}[loop])&chr(13) else
hold:= minimum({?param}[loop])&&quot; to &quot; &maximum({?param}[loop]) &chr(13)) else

(if minimum({?param}[loop])=maximum({?param}[loop]) then
hold:=totext (minimum({?param}[loop])) else
hold:=minimum({?param}[loop])&&quot; to &quot; &maximum({?param}[loop])) ;
out:=out + hold
);

out


Mike

 

[jcmv007]

mbarron Thanks for your response it worked great.

Thanks also to everybody else who responded or showed interest.

James :-~