"Add All" button on Parameter Values Input Screen 2

[kbrown73]

Ingres Database, Crystal 8.5, ODBC

Is there any way to include an "Add All" button or command on the "Enter Parameter Values" dialog box upon opening a report? I have included a list of default values that appear in the list. However, the list is quite long (50 entries). The user of the report is having to click the "Add" button for each entry. Need to be able to click a single button to add all entries...

Any Ideas.

 

[IdoMillet]

Add "ALL" as the 1st value in the default value list.

Change record selection criterion to something like:

{?Last_Name} = {employee.lname} OR {?Last_Name} = "ALL"

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kbrown73]

If I do this, it will look for all last names that are "All". I have a list of tool numbers:

518
519
520
....
725

When they select "All" from the selection screen, I want it to pull all tool numbers.

Is there a wild card (*) character?

 

[synapsevampire]

You need to reread Ido's post and follow it more closely.

To rephrase, add a default of All as a choice in the parameter, the in the Report->Edit Selection Formula->Record use:

(
if {?Last_Name} <> "ALL" then
{?Last_Name} = {employee.lname}
else
if {?Last_Name} = "ALL" then
{?Last_Name} = {employee.lname} then
true
)

-k

 

[Turkbear]

Hi,
Synapse - A little correction needed, I believe:

(
if {?Last_Name} <> "ALL" then
{?Last_Name} = {employee.lname}
else
if {?Last_Name} = "ALL" then
then
true
)


Cut and Paste sometimes has a mind of its own...

 

[kbrown73]

The formula editor does not like your formula. I receive an error message that the ")" is missing after the last {employee.lname}

What is the purpose of the last "then true"?

 

[kbrown73]

How would I incorporate a second parameter field into this formula for...let's say Date.

I have the first half of the if statement...see below

(
if {?Tool} <> "*" then
{?Tool} = {ss_hist_base.tool} and {ss_hist_base.start_time} = {?Date}
else
if {?Tool} = "*" then
true
)

What about the else portion?

 

[kbrown73]

A little clarification: the * is for All and the ?Tool is for your example of ?Last_Name.

 

[kbrown73]

Nevermind. I discovered the solution.

Thanks for your help.

 

[synapsevampire]

Thanks, Turk, bad paste job there

-k