I have compile a report and slated it for distribution on the network.

[dellyjm]

I have compile a report and slated it for distribution on the network.

The problem i'm having is that values that I have hard coded in the Edit Selection Formula --> Record are prompting me when I run the EXE.

Can someone tell me how to turn it off (get rid of it!)?

Thanks.

dellyjm
dphilips@gleanerjm.com [sig][/sig]

 

[kenhamady]

The launch window has a check mark in the lower left. This controls the feature, but of course this is a runtime checkbox not a developer checkbox.

To completely prevent these items from showing you must write the formula differently. Crystal will only prompt for literals on rule that use:

Greater than
Less than
Equal to
or between

However, you can write most formulas using different operators (i.e. substitute 'like' for 'equal to' and don't use any wild cards.) This will give the same result and skip the prompts. If all else fails, you can create a formula field that is boolean, putting the selection formula in the field, and then use that one field as your entire selection formula.

Just keep in mind that some of these techniques may have an impact on how the SQL is generated, and therefore how the report performs. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]