Browse by Tags

• BI
• BIDS
• Business Intelligence
• Iif()
• InScope()
• Layout
• Matrix
• MDX
• SQL Server 2005
• SQL Server Reporting Services
• Subtotal

• SSRS – Static column headers in a Matrix

  If you create a matrix with dynamic columns you can create one static heading column over top of your dynamic columns…... Posted Dec 12 2007, 04:36 PM by jorg with | with 1 comment(s) Filed under: SQL Server 2005, SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, BI

• SSRS - Custom expressions for subtotals in a matrix

  If you want custom expressions for your subtotals in a matrix, for example to calculate an average instead of the default sum, you need to use the InScope() and Iif() functions in your data field…... Posted Dec 06 2007, 03:14 PM by jorg with | with 5 comment(s) Filed under: SQL Server 2005, SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, InScope(), Iif(), Subtotal

• SSRS – Matrix that adds a new column each time 5 rows are filled with data

  What if you want a dynamic list of values in a matrix but with a maximum of 5 rows. How do you create a matrix like this? I thought this should be an easy job but I found out it was not really simple…... Posted Nov 23 2007, 05:26 PM by jorg with | with no comments Filed under: SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, MDX