How do I add an all/* to a report selection formula 1

[JoseffB]

Hello I'm trying to do a report selection based on parameters and I've forgotten how to pass the * field. I may have it right but could someone remind me how to pass this all value. Thanks.



//This will check if the persons name is in the
//Project contact table or not. Since there are only two
//groups if its not a project member we want all of the
//records to pass, so we can sort for the other group later.
//since it's too much for the server if you place the other
//group in the formula too.

if ({GDContact.GDProjectMngr} = {?People})=true then {GDContact.GDProjectMngr} = {?People} else {GDContact.GDProjectMngr} = "*" ;

 

[MColeman]

if {GDContact.GDProjectMngr} = "*"
or ({GDContact.GDProjectMngr} = {?People}) then true

 

[synapsevampire]

Try:

(
if not({GDContact.GDProjectMngr} in ["All", "*"]) then
{GDContact.GDProjectMngr} = {?People}
else if {GDContact.GDProjectMngr} in ["All", "*"] then true
)

-k

 

[JoseffB]

synapesevampire has a feasible idea, but I already got it using:

if ({?People} = "" or {?People} = "ALL") then {Site.SiteNumber} like "*" else ...

Thanks guys

PS I'll try the in ["All", "*"] in another report later and post results.

 

[synapsevampire]

Joseff: As you progress with more advanced record selection formulas you'll find that some combinations will stop passing the SQL to the database, meaning that performance will suffer.

Hence the aforementioned formula uses a fully qualified ELSE condition (repeates the IF), and it makes use of parentheticals, which should exist around every disparate condition.

-k

 

[JoseffB]

Thank you. I changed it and it is much faster. Agin Thank you lots.

//use Array[1] to check the first entry to see if ALL or *
//is there
(
if not({?People}[1] in ["All", "*"]) then
{GDContact.GDProjectMngr} = {?People} or {RFEngineer.RFEngineer} = {?People}
else if {?People}[1] in ["All", "*"] then true
)