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!

Parameters, how to display in Report Header

Status
Not open for further replies.

BillPeck

Programmer
Feb 25, 2004
18
US
I'm working on Ch 14 of the Crystal 9-Complete Reference (George Peck), specifically p. 386.

I've created three parameter fields but can't get the entered values to display on the Preview tab as they do on the screen shot on p. 386.

Here's what my Preview tab displays:
Customer Name includes bik (ok, this is what I entered)
Regions include AL (only AL displays, I entered about 5 regions)
Orders placed between (this is blank but I entered two dates)

Here's my selection formula:
{Customer.Customer Name} like "*"&{?Customer Name}&"*" and
{Customer.Region} = {?Region(s)} and
{Orders.Order Date} in {?Order Date(s)}

Why don't my parameters display?

Thanks !

Bill
 
To display multiple value and range parameters, you have to use formulas.

For {?Region(s)}:
[tt]
//@dispStringParam
"Regions include " + join({?Region(s)},", ")
[/tt]
For the dates, you can create a formula like:
[tt]
//@dispDateRangeParam
"Order placed between " + totext(minimum({?Order Date(s)})) + " and " + totext(maximum({?Order Date(s)}))
[/tt]
-dave
 
Dave,

that worked, thank you very much !

Bill
 
Hello All,

I've one problem while using parameter values in CR7.
When i select the month and year range suppose from yr 03 to 04 i get the error "minimum cannot be larger than maximum".
Is there any solution for this problem,i wanted to print the data from say apr-03 to mar-04.

Regards,
Prashant
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top