Showing Tag: "sql" (Show all posts)

SSRS 2012 Export to Excel Footer bug

Posted by John Henderson on Monday, April 30, 2012, In : SQL

So I recently upgraded my companies SQL servers to SQL 2012...
Thus far we are loving it, without changing any code, we are seeing some dramatic speed increases.

Although, we ran into an issue with SSRS when trying to export to the report to Excel. It turns out there is a bug with the footer and exporting to Excel.

J Gooding found a workaround to this problem, found here. This link is to the connect submission, so please vote to get this fixed.

In synopsis, if you have a text box in the footer of...
Continue reading ...

It's been awhile, but...

Posted by John Henderson on Thursday, September 2, 2010, In : Everything Else

I found out about an extremely handy tool that will save you tons of time.

It's called AutoHotKey, and it is superb for instant auto correction when for misspellings, but the real power that I think it provides is for programming.

For example, the SQL developers out there have heard of SQL Prompt, but it's a little pricey for personal use, but with AutoHotKey, you can simple little scripts to perform the same "snippets" found in the aforementioned product.

You can add ::ssf::SELECT * FROM

and ev...
Continue reading ...