Saturday, August 15, 2009

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.

No comments:

Post a Comment