How to Add a Column Header to an SCRM Report
The following procedure adds a version column to the Add or Remove Programs Inventory Summary report. The version expression from the existing Program Name column is moved to the new column to provide the data source.
To complete this procedure, you must first switch the filter order of an SCRM report. For more information, see How to Switch the Filter Order of an SCRM Report.
To add a column header to an SCRM report
Open the SQL Server Business Intelligence Development Studio project you used in How to Switch the Filter Order of an SCRM Report
In Solution Explorer, double-click the report to open it in Layout view.
In the report matrix, click the Program Name column handle, keep the left mouse button depressed, and highlight the column handle next to Program Name.
Right-click one of the highlighted column handles, and then click Insert Column to the Right.
In the Program Name column, right-click the border of the Version cell, and then click Cut.
Right-click the column header for the newly-created column, and then click Paste.
In the Program Name column, right-click the border of the version expression cell, and then click Cut.
In the new Version column, right-click the last cell in the column, and then click Paste.
Click the version expression cell you just cut, and then simultaneously press the CTRL key and click to the left of the cell to select both cells.
Right-click either of the two selected cells, and then click Merge Cells.
In the report matrix, click the matrix row handle for the row above the version expression you moved to select the entire row.
In Properties, make sure the hidden attribute for Visibility is set to True.
If ToggleItem has a value, clear it.
Repeat steps 10 though 12 for the version expression row.
Click Preview to verify your changes, and then publish the report.
See Also
Tasks
Code Sample: SCRS_GetCompany_CUSTOM SCRM Stored Procedure
Code Sample: SCRS_GetProgramName_CUSTOM SCRM 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
How to Switch the Filter Order of an SCRM Report
Concepts
About SCRM 2006 Report Customization