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.