Rob Farley - All Comments

re: How to format the subtotals of a Reporting Services matrix differently, using InScope

Rob Farley — Tue, 06 May 2008 03:54:02 GMT

Alex,

Yeah - the Previous function doesn't work in a Matrix. Depending the report, I'd be tempted to use a query which returns the data pivotted, and then use a table to display it. You say you're dealing with currencies, which I'm hoping is relatively stable.

I think you'd be able to do this in SSRS 2008, using the Tablix control. I'd have to try it though.

Rob

re: How to format the subtotals of a Reporting Services matrix differently, using InScope

Alex — Tue, 06 May 2008 02:20:29 GMT

Hey Rob,

I'm following up on Catherine's question - it is similar enough to what I want to do. The link to the var function you provided above states that the expression can't be an aggregate, but the data region of a matrix has to contain an aggregate. Is the expression the matrix group, not the data level? Also the Previous function states (in msdn) that is doesn't work in a Matrix :(

My specific requirement is to compare the values of columns in a matrix and format based on the proportion (actuals vs. budget). I am using a matrix because our data is Currency based and I would have to create new columns manually for new or removed currencies. Using a table is an option but not my preference.

Can you let me know if you know of any function that will allow me to reference the values in another column to get the proportion.

Thanks,

Alex

re: Simulation questions in 70-431

selvakumar — Thu, 01 May 2008 05:16:31 GMT

please any one send latest dumbs 70-431 sql server 2005 april 2008 email id- selvakumar222@gmail.com

re: SQL Server 2008 PowerShell SnapIn

Rob Farley — Tue, 29 Apr 2008 01:57:09 GMT

Goodwin - there are some great books around. Pop down to a bookshop and glance through a few to find one that suits your learning style. But also read blogs like blogs.msdn.com/powershell to stay learning!

Aaron - I'm not sure, because I don't run Exchange locally. However, if there's a PowerShell provider at all (through this Exchange Shell you mention), you should be able to see if it's treated as a snapin using "Get-PSSnapin -reg" like Darren and I did for the SQL stuff. And post back here to let me know how you go.

re: SQL Server 2008 PowerShell SnapIn

Aaron Guilmette — Tue, 29 Apr 2008 01:50:11 GMT

Does anyone know if this works for the Exchange 2007 Command Shell? For those of us that admin multiple platforms and applications, the prospect of PS bloat is demoralizing.

re: How to format the subtotals of a Reporting Services matrix differently, using InScope

Rob Farley — Thu, 24 Apr 2008 11:08:57 GMT

Catherine,

Do you just want the Previous function?

msdn2.microsoft.com/.../aa255825.aspx

Rob

excel pivot tables

excel pivot tables — Thu, 24 Apr 2008 00:00:25 GMT

Pingback from excel pivot tables

re: SQL Server 2008 PowerShell SnapIn

G D Milner — Tue, 22 Apr 2008 05:54:37 GMT

In my opinion, the best book on Powershell is and remains Bruce Payette's Powershell in Action. Also very good is the Windows PowerShell Cookbook by Lee Holmes.

I just started reading Pro Windows PowerShell by Hristo Deshev, and that one looks pretty good, too.

If you only buy one book, however, get Powershell in Action.

Cheers

re: How to format the subtotals of a Reporting Services matrix differently, using InScope

Catherine Jewett — Mon, 21 Apr 2008 13:56:49 GMT

This was a great example thank you.

I am still challenged with trying to find a way to display the differences or Variance (Var) between two rows of the same column in reporting Services.

I can code for it and put it in that way, but I was hoping that there was a way to calculate not a sub total but a variance between the values of the same column using SSRS.

re: SQL Server 2008 PowerShell SnapIn

Goodwin Robinson — Thu, 17 Apr 2008 09:33:26 GMT

Hi Rob and everyone!

Great article, I DBA managing just over 60 SQL Server 2000/2005 Instances, supporting over 300 databses and it seems my day will be much more productive if I can script in PowerShell.

I know the basis in VBScript via WSH, so some knowledge base on my part to work with, but will like to take on PowerShell.

So, Please where would you suggest I start - books and web resource etc I could use to get up to speed.

Thanks

Goodwin

PowerShell - Where is It?

Carpe Datum — Wed, 16 Apr 2008 15:39:25 GMT

As you may know, we’ve created a SQL Server 2008 provider for PowerShell. With this very cool feature

re: Latest news on 70-431 simulation questions

Rob Farley — Tue, 15 Apr 2008 19:03:53 GMT

If you have prepared using TestKing and ActualTest, then you will probably fail this exam. You should use the product for a few months in real situations.