Adding SQL Parameterization
In the SQL query created in Step 1, add parameter tags using the [
$paramName] syntax. The ReportRender object treats these parameters as macros. Note the added INTO clause.
For more information about the available parameters, see Analysis/Reporting Schema.
Step 2
SQL Query =
"SELECT [$TopCount] UserId rcp_guid, DateCreated, DateRegistered, Email
rcp_email, FirstName, LastName, TelephoneNumber, UserTitle, UserType
INTO [$ResultTable]
FROM RegisteredUser
WHERE [$DateRange] AND [$Expression] AND [$SingleValue]
ORDER BY rcp_email ASC"
Copyright © 2005 Microsoft Corporation.
All rights reserved.