Thanks so much!

Can you post how you fixed this? I would like to know, as I've run into the same issue. Thanks!

I personally have turned it off. It locks up my PC too much, and formats things in ways I don't want them formatted (I'm pretty particular about how I capitalize,...

Thanks. We actually have SQL Prompt but would like to stop paying for it. We have 2008 and do intend to upgrade sooner than later; however, until we're ready we...

Thanks for the responses!

Thank you!

Thank you! I may be able to use this quite a bit.

Thank you for your time, I'll play with it. I still can't get consistent formatting between the row label, the subtotal label, and the values in the filter drop-down. If...

Yes, but that isn't working in my pivot table, when the column I'm trying to format is a grouping (one of the row labels). I can format the values column,...

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)

I actually had coded that way initially, to just bring back the first day of the month. But the problem I'm having is formatting the...

I apologize...I'm working with SQL Server 2005. I don't know that it makes a difference, but I will post this message there instead.