How to Add a Dataset Column in an SCRM Report
The following procedure updates the SCRM 2006 Software Update Status for a Specific Software Update report to display the SMS site code in a new column. The stored procedure result set is updated to return the SMS site code.
To complete this procedure, you must first perform the following tasks:
- Obtain the report definition language file for the Software Update Status for a Specific Software Update SCRM report. In SCRM 2006 Report Manager, the Software Update Status for a Specific Software Update report is in the folder named Microsoft System Center Reporting, SMS Reports, Software Update. For more information, see How to Obtain the Report Definition Language File for an SCRM Report.
- Create an SCRM Report Server project. For more information, see How to Create an SCRM Report Server Project.
To add a dataset column to an SCRM report
Open the SCRM Report Server project you created for Software Update Status for a Specific Software Update.
In the Datasets window, open Report Datasets, right-click SoftwareUpdateStatus, and then click Add to display the Add New Field dialog box.
In the Name textbox, type SMSSiteCode.
In the Database field: textbox, type SMSSiteCode and then click OK.
In the report matrix, make room for another column by using the column handles to resize the existing columns.
In the final matrix column, right-click the column handle, and then click Insert Column to the Right.
Copy the header cell for Percentage Compliance, and then paste it into the header cell for the new column.
Right-click the new column header, and then click Properties to display the Textbox Properties dialog box.
On the General tab, in the Value: text box, type SMS Site Code
Copy the expression cell for the Percentage Compliance column to the cell immediately below the new SMS Site Code column header cell, and click OK.
Click the new SMS Site Code expression cell, change the expression to read =Fields!SMSSiteCode.Value, and then save the report project.
Using SCRS_SWUStatusSpecificUpdate, create a stored procedure named SCRS_SWUStatusSpecificUpdate_CUSTOM to add the SMSSiteCode to the procedure's result set. For a complete example, see, Code Sample: SCRS_SWUStatusSpecificUpdate_CUSTOM SCRM Stored Procedure.
In Solution Explorer, right-click the report and then click View Code.
Search for
SCRS_SWUStatusSpecificUpdateand then replace it withSCRS_SWUStatusSpecificUpdateDataset_CUSTOM.In Solution Explorer, double-click the report to switch to Layout view, and then click Preview to verify the changes.
Save and publish the report.
See Also
Tasks
Code Sample: SCRS_SWUStatusSpecificUpdateDataset_CUSTOM Stored Procedure
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
Concepts
About SCRM 2006 Report Customization