Select Criteria Hiding from the end user

[julsails]

I have the following statement in my select criteria.

{CV3EnumReference.ColumnName} = "AuditType"

I do not want this to be prompted to the user but when I compile the report it gives a prompt with the default AUDITTYPE (before the parameter form appears).

Does anyone know how to prevent this?

 

[DanR]

when you pull up the compiled report in runtime (.exe file), there is a check box in the bottom left hand coner that says "Modify Selection Formula". Uncheck that box, and the selection formulas will not appear.

If you have certain selection formulas that the user does need to select, make parameters out of those formulas.

 

[julsails]

It's not that I don't want the all selection parameters not to appear. I do not want this particular selection criteria to appear.

I am confused on how creating this criteria as a parameter would prevent the user from being prompt? Is it possible to get more detail or point me to the documentation. Any help is greatly appreciated.

 

[DanR]

For any selection criteria you do want to appear, create a parameter for that selection criteria.

For example, if you have a selection formula that says:

{table.date}=Date(2002,04,18), you can create a parameter called {?Date} and change your selection criteria to say {table.date}= {?Date}. The compiled report will prompt you for a parameter, but it will not display the selection formulas.

For those selection formulas that you "HARD CODE" into the report, and do not want the user to see, just do not build parameters for those criteria.

For additional information, refer to the online help under parameter fields, using, in record selection.