Disable "Modify Selection Criteria" checkbox on Compiled Reports 1

[dgillz]

Does anyone know how to disable the "Modify Selection Criteria" checkbox on a compiled report?

Please advise Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Thyssen]

It is in your parameter field. Uncheck the box that says "Allow editing of default values when there is more than one value"

Hope this helps.

LT

 

[Roadkill150]

Hi Don,
I don't know a way of disabling the box but there is a workaround to this.

The workaround is to place the hard coded value into a formula, then reference this formula in the Record Selection Formula.

Example:
Record Selection
{Database.Field} = "Your Name"

replace with:
@Test
"Your Name"

Record Selection
{Database.Field} = @Test

Hope this helps!
-Bruce



Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[dgillz]

Thyssen-

I am not able to get to that checkbox to unselect it if I have a single value parameter with no default values.

There has to be a way to do this. I will use Bruce's workaround if I have to. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Roadkill150]

The only other workaround that I know about is for versions prior to 8.. you could use a date in xxx to xxx statement in your selection formula which would grey out the box.. the reason being that it was too complex of a query statement for crystal to generate. This has since been overcome with newer versions of Crystal Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[kenhamady]

This is a hard coded feature of compiled reports using the compile feature in CR, not VB applications. You can't control the check box, but you can make it irrelevant. Checking this box will only show you rules that have:

Equal
Between
Greater than
Less than

You can write your selection formula to not use these (ie - user One Of with a single value instead of equal ), or you can embed your boolean test in a formula field and put the formula in the select expert. Now, no matter how they check the box, nothing will happen.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com