CR11 and wild card parameter

[lgmin]

Is there a trick to get CR XI to open a report created in CR 10?

Also, is there a way to create a wildcard or "ALL" parameter. I have a parameter that has numerous services in it. User want to be able to select them all without having to range them from beginning to end. So for instance, the first selection in the list would be "ALL" or "*", or they could select a specific service. Is this possible?

Thanks.

lg

 

[dgillz]

Sure, make the default value of your parameter 'ALL', then be sure to allow additional input, so they could input any value.

The write a record selection formula:

If {?MyParm}='ALL' then true
else {?MyParm}={MyDatabaseField}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[lgmin]

I cannot get this to work. I added 'ALL' as a selection in my parameter list, then created the record selection formula. It works for all the services in my list, but if I select 'ALL' no records return.

Any idea what I am missing? Thanks.

lg

 

[jdemmi]

Here's what I do. If the user selects/enters a value in the parameter then it will be used. If not all are selected.

(if (not isnull({?PARAMETER1})) then {TABLE1.FIELD1} = {?PARAMETER1}
else
true)

-- Jason
"It's Just Ones and Zeros

 

[Turkbear]

Hi,
To use ALL as a parameter and have it return all the records, use something like this in your record selection formula:

If Trim({?param}) <> ""     // test for Null first
  Then 
 ( if {?param} = 'ALL' 
    then 
        True                // Get all the records
  else if {?param} <> 'ALL' then
       {Table_Field} = {?param})

 else                      // If Param IS Null
  True                       // Get all records as well

Should handle most inputs..










To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lgmin]

That works. Thanks.