Hi expert,
I have a such requirement. A report select condition, need display client code and client name(just use client code, user can't remember client's code,on the other hand,just display client name, maybe 重名)。 I created index on client code. I want to use client code to retrieve data, but list client code:client name to let user select.
my syntax is :
@Select(Project\Client Code) IN left(@prompt('Client','A','Project\Client Code:Client Name',Multi,Free,Persistent,,User:4),4) -- to get the fist 4 char
but always syntax error.
if change to
@Select(Project\Client Code) = left(@prompt('Client','A','Project\Client Code:Client Name',Mono,Free,Persistent,,User:4),4) -- to get the fist 4 char
then can pass syntax check.
But user need to select multi value, please tell me the solution, thank you very much!
Regards,
Tony