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

  • 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

  • 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

How the transformed data is written to an output file with column headers in U-SQL...

While working with U-SQL language, I noticed that there are few ways of writing data to an output file. Let's assume the SalesDetails....