Skip navigation
814 Views 1 Reply Latest reply: Apr 13, 2012 8:21 AM by RSS
igsl Rookie 43 posts since
Aug 31, 2011

Has received 1 of 9 achievements.
Currently Being Moderated

Feb 22, 2012 1:00 AM

Add Multiple parameters on Report Designer

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 =, input box 2 =


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 ?' ?





  • Employee 37 posts since
    Oct 6, 2009

    Has received 2 of 9 achievements.
    Currently Being Moderated
    1. Apr 13, 2012 8:21 AM (in response to igsl)
    Re: Add Multiple parameters on Report Designer



    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




More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS®  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software