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

display parameter value in report page heador

Status
Not open for further replies.

BHAT100

Programmer
Dec 5, 2002
115
CA
Crystal 9.0
I have set up (?location) as parameter. it has following option;

-Allow multiple value
-Range values
-set up location default from iv40700 table

I want to print the range whatever user enters in parameter on the report
but when Place parameter on page header it does not return any value

Thanks for your response

-bhat
 
You didn't say whether the parameter was a number or a string. The following assumes it is a number with 3-digits. If it is a number, change the "000" to reflect the longest number of digits in an ID. If it is a numeric string, then remove totext(,"000") from the formula.

numbervar i;
numbervar j := ubound({?ID});
stringvar parmdesc;

for i := 1 to j do(
parmdesc := parmdesc + totext(minimum({?ID}),"000") +" - " +
totext(maximum({?ID}),"000") + chr(13));
parmdesc;

After placing the formula in the page header, right click on it->format field->common->check "can grow".

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top