Compartilhar via


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:

To add a dataset column to an SCRM report

  1. Open the SCRM Report Server project you created for Software Update Status for a Specific Software Update.

  2. In the Datasets window, open Report Datasets, right-click SoftwareUpdateStatus, and then click Add to display the Add New Field dialog box.

  3. In the Name textbox, type SMSSiteCode.

  4. In the Database field: textbox, type SMSSiteCode and then click OK.

  5. In the report matrix, make room for another column by using the column handles to resize the existing columns.

  6. In the final matrix column, right-click the column handle, and then click Insert Column to the Right.

  7. Copy the header cell for Percentage Compliance, and then paste it into the header cell for the new column.

  8. Right-click the new column header, and then click Properties to display the Textbox Properties dialog box.

  9. On the General tab, in the Value: text box, type SMS Site Code

  10. 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.

  11. Click the new SMS Site Code expression cell, change the expression to read =Fields!SMSSiteCode.Value, and then save the report project.

  12. 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.

  13. In Solution Explorer, right-click the report and then click View Code.

  14. Search for SCRS_SWUStatusSpecificUpdate and then replace it with SCRS_SWUStatusSpecificUpdateDataset_CUSTOM.

  15. In Solution Explorer, double-click the report to switch to Layout view, and then click Preview to verify the changes.

  16. 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

Other Resources

Sample SCRM Stored Procedures
SCRM 2006 Stored Procedures