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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Placing Multiple Parameters on a report 4

Status
Not open for further replies.

JamesFlowers

Programmer
Mar 23, 2001
97
GB
I have a report that takes a parameter that allows multiple values passed.

I use CR 8.

When I place the parameter on the report to show the values chosen by a user it only shows the first parameter entered.

please any help will be most appreciated

James Flowers

 
Hi,
Are you using Crystal Reports by itself or using a frontend with it? When you hit the "refresh" button, it should allow you to change the values even if you have declared one of the values as the "default."
Brett Please visit my websites!
 
Crystal 8 has a new function: Join (list, delimiter) where list would be the parameter and the delimiter would be a comma or other charater to separate.
 
I have examples of this in my FAQ on common formulas. Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
 
I know this Thread is from a while back but I have a quick question. The join function only allows a maximum of 254 characters (due to limitations of CR). What if your list turns out to be longer than 254, would it be possible to accomplish this?
 
You would have to parse the parameter into several pieces with formulas like this one that prints the first four elements in the parameter array:

if Count ({?param}) > 4
then Join ({?param} [1 to 4] , ',' )
else Join ({?param} [1 to Count( {?sd} )] , ',' ) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top