Skip navigation
815 Views 1 Reply Latest reply: Apr 13, 2012 8:21 AM by simon.ma 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 = 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

  • simon.ma 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

    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

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

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

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software