Print Page | Close Window

Paramter Fields Displaying

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13738
Printed Date: 27 Apr 2024 at 11:22am


Topic: Paramter Fields Displaying
Posted By: wan2fly99
Subject: Paramter Fields Displaying
Date Posted: 13 Jul 2011 at 1:36am
I have a parameter field that allows multiple selections for it.
I can put the parameter on the report and see the first value.

 How can I display all the values selects for that parameter?

Thanks for any help


Replies:
Posted By: lockwelle
Date Posted: 13 Jul 2011 at 3:52am
you need to cycle through the array that holds the values.
 
if you are displaying them, you will probably want a stringvar and to loop (CR help for syntax)....probably a FOR loop where the upper limit is found by UPPER({?parameter})-1 (the array starts at index [0] I am pretty sure...again CR help can guide you)
 
Obviously in your loop you will want to concatenate the values together.
 
if you just need to see if a value has been selected, then you will be using the 'IN' command....again CR help, look at arrays or IN, either should give you examples of how to proceed.
 
HTH

Posted By: wan2fly99
Date Posted: 13 Jul 2011 at 3:56am
Thanks  I found out I can do this  if field is alpha

Join ( {?YourCharPrompt} ,  ', ' )

Posted By: lockwelle
Date Posted: 13 Jul 2011 at 4:15am
silly me...I forgot about JOIN, I use split all the time, but JOIN....


Print Page | Close Window