Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display Parameters

Status
Not open for further replies.

dbinfoweb

Technical User
Nov 20, 2001
59
US
I have a parameter to allow users to enter as many values as they want and they will be used in Record Selection. I would like to print these parameter values on the report. I know I can use maximum and minimum for the upper and low bounds, What about those in between? say the user enters 10 values in the prompt. How do I capture them as well? Thanks in advance for any help.
 
What version of crystal are you using? The answer to this question varies highly based upon version.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
If you have a string parameter, you can use:

join({?yourparameter},", ")

If you have a number parameter, then create a formula:

Local NumberVar i:= 1;
Local NumberVar loops := UBound({?yourparameter});
Local StringVar Display := "Selected Values: ";

For i := 1 to loops do
(
Display := Display & totext({?yourparameter},0,&quot;&quot;) & iif(i<loops, &quot;, &quot;,iif(i=loops-1, &quot; and &quot;, &quot;.&quot;))
);
Display;

This is an adaptation of a formula in another post by JEX.

-LB
 
Awesome, it works! I actually had to use both. I had one param is a string and the other one is number. So...thank you so much for your help. It definitely has been a big help! Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top