How to Add a Serial Number in a Matrix
In a matrix, a serial number refers to a unique identifier assigned to each group of rows or columns. This serial number has various uses, such as organizing or labeling the groups within the matrix.
To add a serial number to a matrix, you need to assign a unique identifier to each element in the matrix structure. This serial number allows for easy referencing and access to individual elements. Follow these steps to add a serial number column to the Matrix in Bold Reports:
Locate the cell in the matrix where you want the serial number to appear.
Click on the cell to select it. In the properties panel or toolbar, find the
Expressionoption for the cell.
Click on the Expression option to open the expression editor. Enter the following expression to generate the serial number and click
=RunningValue(Fields!ProductID.Value, CountDistinct, "DataSet1")
Note: This expression uses the RunningValue function to calculate a running total or aggregate within a specified scope. It generates a unique number for each row in the matrix.
- Save and preview the report to see the serial number column in action.
By following these steps, you will be able to add a serial number column to a matrix in Bold Reports using the RunningValue function. The serial numbers will be generated based on the specified field and the running value calculation.