HI. Ive been trying to get report Designer to work, and finally got a query such as
Select * from [user] where firstname = @fn
to work.. (by making the sql varname @fn).
When I change the query to
Select * from [user] where firstname = @fn and Authorityid = @authId
I get syntax errors .
Im new to xtraction, just trying to see what I can and cannot do.
figured it out myself. It was an SQL syntax , different to prev version Ive used. Needed ( ) around the whole where condition.
Retrieving data ...