CRXI, SQL Server.
My user wants to choose multiple projects. In the parameter Value Options, I chose Allow Multiple Values.
My Record selection Formula is:
if {?ProjectID}>0 then {EntryLog.ProjectID} = {?ProjectID} else not isnull({EntryLog.ProjectID})
But it gives error:
The array must be subscripted. For example: Array
Can you please help me with the syntax of array for project for this selection formula?
Thanks very much!
My user wants to choose multiple projects. In the parameter Value Options, I chose Allow Multiple Values.
My Record selection Formula is:
if {?ProjectID}>0 then {EntryLog.ProjectID} = {?ProjectID} else not isnull({EntryLog.ProjectID})
But it gives error:
The array must be subscripted. For example: Array
Can you please help me with the syntax of array for project for this selection formula?
Thanks very much!