Hello all,
Well I'm finally getting my 7.1 environment stood up, and at the moment I'm working on reproducing a report we use heavily (as in ~6000 runs per month) called "Computer Locator". Basically it lets you search for all sorts of inventory data (name, user logon history, domain, computer model, IP/subnet info, etc), all from one report. It has some tricky code in it that gets it working, and in particular the 6.x report makes use of the "None" parameter type so that SQL is directly replaced in the query based on the selection of a parameter. For example, the Parameter is called "QueryOperator" which is a "None" type dropdown which contains: Like Pattern (wildcards allowed);LIKE '%SearchValue%'
|In List (comma separator, strings within single quotes);IN (%SearchValue%)
|Equal To (string comparison);= '%SearchValue%'
|Less Than (string comparison);< '%SearchValue%'
|Less Than or Equal To (string comparison);<= '%SearchValue%'
|Greater Than (string comparison);> '%SearchValue%'
|Greater Than or Equal (string comparison);>= '%SearchValue%'
and the code contains:
WHERE %QueryOperator%
%SearchValue% is another parameter; you can see why this is so important in the "In List" Operator type, which allows you to paste in an "IN()" formatted list of items ('Item1','Item2','Etc') and substitute it into the code. I can't find any way so far to make this work in 7.1. From some conversations I understand this may be in an effort to prevent a SQL-injection attack against the reporting engine, which makes sense...but any ideas how to replicate the functionality I'm looking for without a separate report?