Browse by Tags

• BI
• BIDS
• Business Intelligence
• Expressions
• Iif()
• InScope()
• Layout
• Matrix
• MDX
• Rendering reports
• Row height
• SQL Server 2005
• SQL Server Analysis Services
• SQL Server Integration Services
• SQL Server Reporting Services
• SSAS
• SSIS
• Subtotal

• Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file

  A lot of developers have SQL Server and its different services running on their PC or notebook to develop or test BI solutions. Unfortunately this slows down your system quite a lot. To speed things up when not using SQL Server, I used to stop and start... Posted Jan 06 2009, 08:02 PM by jorg with | with 4 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, SSAS, SSRS, SSIS, BI

• 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

• SSRS – Invalid row heights, BUG?

  It seems that SSRS renders row heights of matrices wrong when a row contains one or more empty cells. This can be solved by changing the padding property…... Posted Nov 19 2007, 10:56 PM by jorg with | with no comments Filed under: SQL Server 2005, SQL Server Reporting Services, BIDS, Rendering reports, Layout, Row height, SSRS