When linking a SQL Server table (SQL Server 2008 R2) via ODBC, I encountered a major error where all cells in the table display #Deleted when opened from Microsoft Access 2010 (14.0.6123.5001).The problem turns out to be that Microsoft Jet … [Continue reading]
From a set of data in SQL Server database, we needed to find a way to quickly get a numeric representation (add a field MonthNo) of a month name in order to do a comparison. Given we only have a month name and year fields here's a simple way to do … [Continue reading]
Even with Connect-It scenario between HP Asset Manager (AM) to Service Manager (SM) running, for quite some time we had an issue where certain models did not carry over to Service Manager.It turns out, one little detail was overlooked. By design, … [Continue reading]
Just earlier today I encountered an issue where SSRS reports that works fine in IE and FireFox were showing blank in Chrome and Safari and interestingly enough the common denominator for these two browsers are that they are based on … [Continue reading]
This is just a quick hack to hide the breadcrumb and navigation links in SSRS.Under default installation, locate ReportingServices.css file under the following path: C:\Program Files\Microsoft SQL Server\MSRS10_50\Reporting … [Continue reading]