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

Parameters no longer optional in Crystal Enterprise?

Status
Not open for further replies.

PleaseGiveHelp

Programmer
Oct 29, 2002
131
US
We just upgraded to Crystal Enterprise (previously were using Crystal 7 with the web component). It seems that all of the parameters that were once optional are no longer optional. If you do not supply a parameter the report bombs out. Is this a Crystal Enterprise thing? Can I create optional parameters?
 
Those are 2 different products, so try not to compare functionality.

IN CE, you can select whether to prompt for a parameter, but you're record selection criteria should allow for a default value, such as "ALL"

An example is:

(
if {?promptName} <> &quot;ALL&quot; then
{table.field} = {?promptName}
else if {?promptName} = &quot;ALL&quot; then
true
)

This also helps to ensure SQL pass through.

-k


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top