Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Syntax


1. Can someone please tell me whats the error in the below statement:

if ({w.LOGIN} = CurrentCEUserName) then (region := {w.fk_client_region_id};)

The check says its missing a ) .

2. Also , how do I add mysql queries to such group formulas, for ex:

I want to bring all users based on some criteria


level := {w.level};

if(w.user = CurrentCEUSERNAMe) then

select * from w where w.level =level;

Thanks for your time

Former Member
Former Member replied

change from this

if ({w.LOGIN} = CurrentCEUserName) then (region := {w.fk_client_region_id};)

to this- put your semi colon on the other side of the )

if ({w.LOGIN} = CurrentCEUserName) then (region := {w.fk_client_region_id}) ;

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question