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

Paramters selected not showing on report

Status
Not open for further replies.
Mar 10, 2004
53
US
Hi,

How do I make all the values selected for a parameter to show up on a report?

I have several paramters that can take multiple values and have dropped them in the report header. Problem is only the first value is showing even though I've selected multiple values.

Thanks in advance.
 
I should have known this wasn't going to be as simple as dragging and dropping the parameter onto the report.

I did, however, find the code to display multiple values.

Stringvar s:=""; //a string to accumulate the parameter values
Numbervar i; // to use a counter

For i :=1 to count({?Assignee}) step 1 do s :=s + ", " + {?parmName} ;

s [3 to length(s)]; //

-------------
I do have a follow up question though. Is there a way to have an object (ie. textbox, etc.) dynamically move? For example,

Parm Label1: {display the multiple values here}
Parm Label2: {display the multiple values here}
etc.

and all are set to "auto grow". How can I have the parm labels and it's values to automatically move down the page so the text boxes doesn't overlap?
 
Hi

Correct me if i haven't understood your problem properly. You have Parm Label1 and Parm Label2 one after the other. When there are multiple entries in Label 1, then the values overlap Label 2? If this is what is happening then you can put Label1 and label2 in a seperate section. The section will grow to however many entries there are for each parameter but will never over lap the next section.

Hope this makes sense and helps
 
Thanks MadCatmk2.

It did make sense and helped. Only been using CR for a few weeks and there still a lot of basic stuff I haven't encountered and/or done.
 
Your example uses Crystal Basic, which is by far the minority of code examples, so consider using Crystal syntax (Basic-like).

A quick cheat is a formula containing:

join({?MyParm},chr(13))

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top