Report Management - Professional SQL Server 2005 Reporting Services - page 443

C#

localhost_RS.ExtensionSettings extset = new localhost_RS.ExtensionSettings();
extset.Extension = “Report Server Email”;

Now we move on to the extension-specific properties of the ExtensionSettings object. The
ParameterValues property is set to an object of type ParameterValueOrFieldReference and is
a five-element array. You also create five corresponding ParameterValue objects. For each of these
objects, you set the Name and Value properties and then add them to the array.

VB

'-- Create Parameter Values array
Dim ParamVals(5) As localhost_RS.ParameterValueOrFieldReference
extset.ParameterValues = ParamVals

'-- Populate the Extension Parameters
Dim pvTo As New localhost_RS.ParameterValue
pvTo.Name = “TO”
pvTo.Value = Me.txtEMailTo.Text
extset.ParameterValues(0) = pvTo
Dim pvIncludeRpt As New localhost_RS.ParameterValue
pvIncludeRpt.Name = “IncludeReport”
pvIncludeRpt.Value = “True”
extset.ParameterValues(1) = pvIncludeRpt

Dim pvRenderFormat As New localhost_RS.ParameterValue
pvRenderFormat.Name = “RenderFormat”
pvRenderFormat.Value = Me.cboRenderFormat.Text
extset.ParameterValues(2) = pvRenderFormat
Dim pvPriority As New localhost_RS.ParameterValue
pvPriority.Name = “Priority”
pvPriority.Value = “NORMAL”
extset.ParameterValues(3) = pvPriority

Dim pvSubject As New localhost_RS.ParameterValue
pvSubject.Name = “Subject”
pvSubject.Value = “@ReportName was executed at @ExtensionTime”
extset.ParameterValues(4) = pvSubject

C#

//-- Create Parameter Values array
localhost_RS.ParameterValueOrFieldReference[] ParamVals = new
Subscriptions_CS.localhost_RS.ParameterValueOrFieldReference[5];
extset.ParameterValues = ParamVals;

//-- Populate the Extension Parameters
localhost_RS.ParameterValue pvTo = new localhost_RS.ParameterValue();
pvTo.Name = “TO”;
pvTo.Value = this.txtEMailTo.Text;
extset.ParameterValues[0] = pvTo;

localhost_RS.ParameterValue pvIncludeRpt = new localhost_RS.ParameterValue();
pvIncludeRpt.Name = “IncludeReport”;