SSRS

Remember to Vote for List of PCs by SQL Edition OR OS Deployment Dashboard

This is your last chance to vote for your favorite report in this month’s poll! The report choices in Enhansoft’s November 2017 poll are List of PCs by SQL Edition and OS Deployment Dashboard. Which Microsoft System Center Configuration Manager (SCCM) report do you WANT to win? The winner will become December’s free SCCM report! As with all of our dashboard and report giveaways, they can be found within the Enhansoft Reporting product. To learn more about Enhansoft Reporting, please visit the product page. At the moment, OS Deployment Dashboard is well ahead of List of PCs by SQL Edition. If you haven’t voted yet, make sure to VOTE HERE! List of PCs by SQL Edition This report is found within Enhansoft Reporting’s SQL Server category. The List of PCs by SQL Edition report provides you with ...

Vote for List of PCs by SQL Edition OR OS Deployment Dashboard

The report choices in Enhansoft’s November 2017 poll are List of PCs by SQL Edition and OS Deployment Dashboard. Which Microsoft System Center Configuration Manager (SCCM) report do you WANT to win? The winner will become December’s free SCCM report! As with all of our dashboard and report giveaways, they can all be found within the Enhansoft Reporting product. To learn more about Enhansoft Reporting, please visit the product page. Make sure to VOTE HERE! List of PCs by SQL Edition This report is found within Enhansoft Reporting’s SQL Server category. The List of PCs by SQL Edition report provides you with the PC name, SQL version number, SQL instance name, and the installation directory for a specific SQL Server edition. For added convenience, two additional prompt options are available w...

How Can I Hide an SSRS Gauge in a Dashboard?

By Garth Jones A super-cool feature with SQL Server Reporting Services (SSRS) is all of the available options for creating dashboards and reports! For example, did you know that you can hide an SSRS gauge in a dashboard based on the results of a query? Or, that you can hide an SSRS gauge based on the items selected within a prompt? I showed you how to make a gauge appear less plain-Jane in a recent blog post called, “How Can I Update the Plain SSRS Gauge in a Dashboard?” The dashboard example that I used in that post was Overall Software Update Status Dashboard from Enhansoft Reporting. Originally when I was building and testing this dashboard, a number of testers had questions about the software update categories. They told me that they either didn’t deploy all of the categories or their ...

Workaround for SSRS Issue with IE11 on Windows After November Cumulative Update

Microsoft is rolling out its monthly updates for security, including Windows 10. As the latest update is rolling out for all supported Windows 10 versions, administrators should be aware of an issue that keeps SQL Server Reporting Services (SSRS) from working properly with Internet Explorer 11. Those using SSRS may not be able to scroll through a drop-down menu using the scroll bar.  This affects all Windows 10 versions and also Windows 7 SP1. Microsoft is aware of the issue and is working on a permanent fix. In the interim, Microsoft has provided the following workaround… Using the scroll wheel on a mouse works as expected. This issue only applies to document mode 11, so attempting to load the page with document mode 10 may work around the issue. To change the document mode in Inter...

Reminder – Local Account-Group Details for a Computer is the Free SCCM Report

Local Account-Group Details for a Computer is November 2017’s free System Center Configuration Manager (SCCM) report! In order to receive your free copy of this month’s winning SCCM report, Local Account-Group Details for a Computer, simply visit our monthly giveaway page and fill out the form. You should receive the giveaway email within a few minutes, but if you have not received it, please check your spam folder or contact us and we will work with you to solve the problem. Local Account-Group Details for a Computer This report is found within Enhansoft Reporting’s Local Accounts and Groups category. This category of reports provides details about local accounts on each computer as well as the membership of each local security group. This is particularly useful when performing a security...

How Can I Update the Plain SSRS Gauge in a Dashboard?

By Garth Jones The default SQL Server Reporting Services (SSRS) reports in System Center Configuration Manager (SCCM), let’s face it, are plain. When you create a custom dashboard or report, however, they don’t have to stay that way! In this blog post I’ll show you how to update the plain SSRS gauge. Who wants to hear from their boss that a dashboard’s gauges look plain? With only a few simple changes your gauges will look better in no time! Take a close look at this Overall Software Update Status Dashboard (the final version is within Enhansoft Reporting). I deliberately made every gauge different. Can you tell what I did? This table’s explanation of the gauge changes I made might seem confusing, but I hope that once you see how I changed these items, it will become clearer. Gauge Parts T...

List of PCs by SQL Edition versus OS Deployment Dashboard

The report choices in Enhansoft’s November 2017 poll are List of PCs by SQL Edition and OS Deployment Dashboard. Which Microsoft System Center Configuration Manager (SCCM) report do you WANT to win? The winner will become December’s free SCCM report! As with all of our dashboard and report giveaways, they can all be found within the Enhansoft Reporting product. To learn more about Enhansoft Reporting, please visit the product page. VOTE HERE! List of PCs by SQL Edition This report is found within Enhansoft Reporting’s SQL Server category. The List of PCs by SQL Edition report provides you with the PC name, SQL version number, SQL instance name, and the installation directory for a specific SQL Server edition. For added convenience, two additional prompt options are available within their r...

Local Account-Group Details for a Computer is the Free SCCM Report

Thank you to everyone who voted in last month’s poll! The voting was very close, but the favorite report with 50.8% of the vote, Local Account-Group Details for a Computer, becomes November 2017’s free System Center Configuration Manager (SCCM) report! In order to receive your free copy of this month’s winning SCCM report, Local Account-Group Details for a Computer, simply visit our monthly giveaway page and fill out the form. You should receive the giveaway email within a few minutes, but if you have not received it, please check your spam folder or contact us and we will work with you to solve the problem. Local Account-Group Details for a Computer This report is found within Enhansoft Reporting’s Local Accounts and Groups category. This category of reports provides details about local a...

Last Reminder – Asset Intelligence Dashboard Is the Free SCCM Report

Today’s the last day to get your copy of October 2017’s free SCCM report, Asset Intelligence Dashboard, so go to our monthly giveaway page and fill out the form now! You should receive the giveaway email within a few minutes, but if you have not received it, please check your spam folder or contact us and we will work with you to solve the problem. Asset Intelligence Dashboard The Asset Intelligence Dashboard is one of the companion reports within our AI report set. This dashboard will provide you with a count about all of your software titles grouped by Product Family, Product Category, and Product. This is particularly useful to help show you software titles that fall within a particular category or family. The Asset Intelligence Dashboard leverages Microsoft’s Asset Intelligence Catalog...

Last Reminder to Vote for Local Account-Group Details for a Computer OR Component Health States by Site

The report choices in Enhansoft’s October 2017 poll are Local Account-Group Details for a Computer and Component Health States by Site. Which Microsoft System Center Configuration Manager (SCCM) report do you WANT to win? The winner will become November’s free SCCM report! This is your last chance to vote and at the moment, Local Account-Group Details for a Computer is ahead with 58% of the vote. As with all of our dashboard and report giveaways, they can all be found within the Enhansoft Reporting product. To learn more about Enhansoft Reporting, please visit the product page. VOTE HERE! Local Account-Group Details for a Computer This report is found within Enhansoft Reporting’s Local Accounts and Groups category. This category of reports provides details about local accounts on each comp...

What Happened to the Tools Gauge in My SSRS Dashboard?

By Garth Jones In the screenshot below, you can see that there is clearly an issue with the Tools gauge in my SQL Server Reporting Services (SSRS) dashboard. The purple arrow is pointing out that the gauge is not displaying properly. What’s the matter with it? In this blog post, I will show you what the problem is and how to fix it. The Problem This is one of those rare times when I’ll show you a report that is incomplete. The final version of this report, Software Update Dashboard, is now in Enhansoft Reporting and it was a giveaway to attendees when we were at last month’s Microsoft Ignite. If you follow my blog, you will know that I always recommend creating queries in SQL Server Management Studio (SSMS). Then I suggest moving queries from SSMS over to SQL Server Data Tools (SSDT) in or...

How Do I Bulk Upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2?

By Garth Jones I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s blog post called, “What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?” In order to update the RDLs I would have to perform a, “Save As,” or edit each report. In the closing section of that post, I complained that with over 600 reports, I needed to find a way to bulk upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2. It took a little time and research, but in the end I stumbled upon a way that may not be completely automatic, but it’s still a great time saver! This blog post will show you how to bulk upgrade SSRS RDLs. The Problem Let me begin by reminding you about the problem that I had with the, “Unknown Report Version 9.0,” error m...