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

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

    CatherineR Rookie

      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.