1 Reply Latest reply: Apr 13, 2012 8:21 AM by Simon Ma RSS

    Add Multiple parameters on Report Designer

    Rookie

      Hi All,

       

      I am going to create a report to show all the computer names that in a provided IP range.

       

      On the report, user will find two input boxes that ask for the ip range.

       

      e.g. input box 1 = 192.168.001.001, input box 2 = 192.168.001.100.

       

      The report will show me  the computer names within this ip range.

       

      My question is how can I add two parameters in the query? If there is only one parameter, I can use 'Address LIKE ?',

       

      but how about two parameters? 'Address BETWEEN LIKE ? and ?' ?

       

      Regards,

       

      Terry

        • 1. Re: Add Multiple parameters on Report Designer
          Simon Ma Employee

          Hello,

           

          Yes, it exactly the way to do it.

          You need to create 2 parameters (input 1 and input 2), then declare both of them in your DataSet.

          The order of declaration of the parameters is important here ! Because the 1st parameter will be the 1st "?" in your query, and the 2nd one will be the 2nd "?".

           

          Then your query should be something like :

          "select .... from ... where Addresse BETWEEN ? AND  ?"

           

          The result should be someting like this

          Screen_DeviceWithinIPRange.png

           

          Simon