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!

getting parameters to display

Status
Not open for further replies.

7jennyh

IS-IT--Management
Oct 18, 2004
4
GB
I'm trying to get the chosen parameters included in my report footer... any ideas?
 
Unless you're dealing with Range or Multiple Value parameters, you can just drag them into the footer.

Here's a FAQ on displaying range and multi-value parameters: faq767-1206

-dave
 
From the field explorer, simply drag it to the report footer.

Without more specific information, not sure if this is what you need

Crystal Version
Database
Connectivity
Sample Data
Expected output


 
If you are working with string parms, then use:

join({?parm},", ")

If you have multiple number parms, use:

numbervar counter;
numbervar i := ubound({?parm});
stringvar display;

for counter := 1 to i do(
display := display + totext({?parm}[counter],0,"") + ", ");
left(display,len(display)-2);

If you have discrete and range parms, try:

numbervar counter;
numbervar i := ubound(?parm);
stringvar display;

for counter := 1 to i do(
display := display + if minimum({?parm}[counter]) =
maximum({?parm}[counter]) then
totext(minimum({?parm}[counter]),0,"") else
totext(minimum({?parm}[counter]),0,"") + " to " +
totext(maximum({?parm}[counter]),0,"") + ", ");
left(display,len(display)-2);

-LB
 
LB,

I am trying to make use of your number formula to display multiple diagnosis codes and when error checking the formula I get the following message:

Too many arguements have been given to this function

I am usinge CR 8.5 with an ODBC hook into a DB2 database.
 
I appologize, please ignore my previous post I found the issue. Thanks...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top