How to Add a New Filter to an SCRM Report
The following procedure adds the SMS site code as a filter on the SCRM 2006 Software Update Status for a Specific Software Update report.
To complete this procedure, you must first add a dataset column in an SCRM report. For more information, see How to Add a Dataset Column in an SCRM Report.
How to add a new filter to an SCRM report
Open the SQL Server Business Intelligence Development Studio project you used in How to Add a Dataset Column in an SCRM Report.
In Solution Explorer, right-click the report and then select View Code.
In the code, search for the node <
DataSet Name="LocationParameter">.Copy the node and paste it directly below the source node.
In the copied node, change the
<DataSet>node name to <DataSet Name="SMSSiteCode">.Change the child element
<CommandText>to<CommandText>SCRS_GetSMSSiteCode</CommandText>.Delete the child node
<QueryParameter Name = "@Location">.In the child node
<Fields>, change the child node<Field Name="LocationParameter">to<Field Name="SMSSiteCode">.Change the child element
<DataField>LocationParameter</DataField>to<DataField>SiteCode</DataField>.In the child node
<Fields>, change the child node<Field Name="LocationParameterLabel">to<Field Name="SMSSiteCodeLabel">.Change the child element
<DataField>LocationParameterLabel</DataField>to<DataField>SiteCodeLabel</DataField>, and then save the report.In the code, search for the node
<ReportParameter Name="LocationParameter">.Copy the node and paste it directly below the source node.
In the copied node, change the
<ReportParameter>node name to <ReportParameter Name="SMSSiteCode">.Delete the child node
<DefaultValue>.Change the child element
<prompt>to<prompt>Site Code:</prompt>.In the node
<ValidValues>, change the child element<DataSetName>to<DataSetName>SMSSiteCode</DataSetName>.Change the child element
<ValueField>to<ValueField>SMSSiteCode</ValueField>.Change the child element
<LabelField>to<LabelField>SMSSiteCodeLabel</ValueField>.Save and preview the report.
In Solution Explorer, right-click the report, and then select View Code.
In the code, search for the node
<commandText>SCRS_SWUStatusSpecificUpdate_CUSTOM</CommandText>.Copy the child node
<QueryParameter>Name="@Location Parameter"</QueryParameter>and then paste it below the source node.Change the copied node to
<QueryParameter>Name@SMSSiteCode"</QueryParameter>.Change the child element
<Value>to<Value>=Parameters!SMSSiteCode.Value</Value>.Change the stored procedure
SCRS_SWUStatusSpecificUpdate_CUSTOMto accept the new parameter@SMSSiteCode NVARCHAR(255)='<ALL>'. For a completed example, see Code Sample: SCRS_SWUStatusSpecificUpdate_CUSTOM SCRM Stored Procedure.Verify and publish the report.
See Also
Tasks
Code Sample: SCRS_SWUStatusSpecificUpdate_CUSTOM SCRM Stored Procedure
How to Add a Dataset Column in an SCRM Report
How to Create an SCRM Report Server Project
How to Create an SCRM Stored Procedure
How to Obtain the Report Definition Language File for an SCRM Report
How to Publish an SCRM Report
How to Switch the Filter Order of an SCRM Report
Concepts
About SCRM 2006 Report Customization