Refreshing of parameters from a database field. 1

[selvin1]

Hi All,

I need to refresh my popup parameter screen from a databse field in oracle. I am not using any kind of front end for passing the parameters. I went to the parameter creation screen, create the parameter and link the parameter to the database field (a numeric field) using 'set default value' . Then it displays the current values in the database. If there is any change in databse value the values in the parameter popup window is not refreshing automatically. Also I need to display 'ALL' in the same parameter selection. But its not allowing me to add 'ALL' because its not a numeric value. What can I do for this?

Thank you.

 

[rosemaryl]

Dear Selvin,

Crystal does not automatically refresh these....something we have been asking for for years! The only way to do that is programmatically (asp or vb) or with a tool from one of the following contributors:

Ido Millet's (

http://www.milletsoftware.com)

Good Tool

I don't have any experience with the offerings from the following, but they both have excellent reps here at tek-tips:

ChelseaTech may also have something:

http://www.chelseatech.co.nz

Howard Hammerman may also have something:

http://www.hammerman.com

As far as the number, create something outrageously large number like 99999999 as a default and the description ALL

In your formula:

If {?NumericParam} <> 9999999 then {Table.Myfield} = {?NumericParam} else True

Hope that helps,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[IdoMillet]

My DataLink Viewer utility:

http://www.milletsoftware.com/DataLink_Viewer.htm

provides this functionality.

It &quot;pops&quot; other Crystal reports to allow
the user to select parameter values.

In your case, you would show the values to be selected in detail or group footer sections and add &quot;ALL&quot;
to the report header or footer. The user would see a list starting or ending with &quot;ALL&quot;

Each &quot;clickable&quot; (determined according to its name) formula may have a corresponding &quot;Value&quot; formula (visible or suppressed) and in such a case one acts as &quot;Description&quot; and one as &quot;Value&quot;. So your &quot;ALL&quot; description could have
a corresponding 9999999 value as per Rosemary's suggestion.

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

http://www.MilletSoftware.com