Browse by Tags

• MS BI Exams
• SSAS
• SSIS

• Blog moved!

  For a number of reasons, I have moved my blog to http://sqlblog.com/blogs/jorg_klein/ Please change your bookmarks ;-) RSS: http://sqlblog.com/blogs/jorg_klein/rss.aspx Many thanks to Tony Rogerson and Simon Sabin for making this blog possible here at... Posted Dec 13 2009, 10:02 PM by jorg with | with 14 comment(s) Filed under: SSAS, SSRS, SSIS, MS BI Exams

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

  This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/ This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx Posted Jan 06 2009, 08:02 PM by jorg with | with 5 comment(s) Filed under: SSAS, SSRS, SSIS

• 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: SSRS

• 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 7 comment(s) Filed under: SSRS

• 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: SSRS

• 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: SSRS