+1

I agree, GROUPING will count NULLs.

+1

OK, I think I finally got this running again! 😀

After my last post I went to the ReportServer DB and noticed that I had one record in the Keys table...

I'm still struggling with this issue. I have found a number of placing that talk about moving Reporting Services from one computer to another. However, all of these...

I was able to restore the rsreportserver.config file but this didn't help anything.

Seems like I may have answered my own question, or at least half of the question. I found a few reports that were working as expected and another one...

That did it!!!!!!! Thanks so much!

I don't know why this happens but this is what I've found and how I've solved this issue. It seems that sometimes opening Excel files from Report Server would...

This was the exact information that I was looking for, thanks! We have played around a bit with disabling and then rebuilding and did find that some of these...

Thanks, I'll take a look at it. In addition can you help me understand how fragmentation is calculated? I would assume when a reorg or rebuild happens that...

Nevermind, I was able to get this to work. Thanks for your insight on this!

I try this and I'm getting the following error on the saveas line:

Exception calling "SaveAs" with "1" arguments(s): "Cannot access read-only document

I have "$False" for the readonly parameter on the...

Great, I was able to open the Excel file using Powershell, thanks! Since I'm very new to Powershell, is there a way to save the Excel file without the...

Shoot! Anyway to programatically remove the password protection so that it can be used in SSIS?

AH...I figured it had to be something simple like that. That did it! Thank you so much!