Formula

[korata]

I have a string field called sign_permit_code in my crystal report.This field will have to choice depending on the user selection one is "conforming" which is "c" in the database and the other is non-Conforming "N" and also return both conforming and non-conforming data together if the user does not want to make a selection.My question would be how could i write a formula that ask a user to make the selection , Conforming C or Non-conforming N and return the write output from the database.please it is urgent.
Cr 8.5 and database oracle 9i
thank you for the help

 

[synapsevampire]

Create a string parameter and set default values to All, Conforming and Non-conforming, and make it a multiple value parameter type.

In the Report->Edit Selection Formula use:

(
if {?MyParameter} <> "All" then
{table.field} = {?MyParameter}
else
if {?MyParameter} = "All" then
true
)

-k