on 05-08-2009 7:44 PM
Hi
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
ex:
level := {w.level};
if(w.user = CurrentCEUSERNAMe) then
select * from w where w.level =level;
Thanks for your time
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}) ;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As for the adding your sql to a formula you can't because a sql expression require only one value to return.
You may have to use a subreport to get the desired results
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.