Adding Horizontal Gauges for SQL Server 2008 Reports

• First add a matrix to the report
• Then delete the row group and add rows as required
• After that open the column group property box and add the below expression to the "Group On" under general tab

=RowNumber(Nothing)

• Then add the values to the data row cells
• After that add a list to the design
• For the List get the Row Groups property window and add the below expression

=Ceiling(RowNumber(Nothing)/3)

• Then change the "Nothing" in the column group properties to the Name of the Row group of the List
• Then drag the matrix inside to the List
• That's all. You will get the 3 Gauges for each row.