6 Replies Latest reply on Jul 6, 2010 1:42 PM by bshopp

    Custom SQL Report URL

    bwicks

      We have a need to write a custom SQL report and would like to add a varaiable to the report URL.  This would save us from having to write hundreds of reports.  Simple example would be. 

      Custom SQL

      select nodeid,ip_address,caption from nodes where ip_address = @p1

      We need to be able to put the IP in the URL to save us from writing a report for every IP.

      Example

      http://orionServer/Orion/Report.aspx?Report=Examplereport;@p1='192.168.0.1'

      Anyone else need this functionallity? Anyone have a work around?

      Thanks