1 Reply Latest reply on Apr 27, 2017 6:25 PM by CatherineR

    Can you use more than one parameter in a ReportDesigner script?


      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.