Turns out there is a snag when it comes to using Internet Explorer 9 with SharePoint and SQL Server 2008 R2 Reporting Services. If you need to export a report, the export options don’t exists. There’s an open Connect item on this, please take a moment to up-vote this item.
I was asked to take a look at an issue the other day regarding displaying Microsoft Project Task’s Notes in SSRS 2008. If you’ve worked with building reports for Microsoft Project Server, you have no doubt dealt with the RTF data that is stored in the Task’s Notes fields. With SQL Server 2005 Reporting Services … Continue reading Displaying Microsoft Project Task’s Notes in SSRS 2008
The SSWUG Ultimate Virtual Conference starts this morning. Are you planning to take advantage of this opportunity? The Rock Starspeakers are waiting in the channels, anticipating you every move. But, have you registered? It’s not too late. If you can’t get to the sessions today, there is always tonight to go through and view them. … Continue reading Tap, Tap, Tap – SSWUG Conference Starts Today
It starts next week,the SSWUG Ultimate Virtual Conference on October 21-24. This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while being able to view the content from the comforts of home or your desk. Have you registered? If you haven’t registered yet, I really … Continue reading Are You Registered?
While working on some questions for a project I am working on, I ran into an issue with Report Manager today. I haven’t had the pleasure of running into this issue in a while and thought I would share the issue and the resolution because it affects both Windows 7 and Vista. Between this time … Continue reading Report Manager in Windows 7
One of the reasons I was digging around to find out how many reports were being executed for each folder the other day was that there were some subscription issues at the client. The goal was to get a break down of when reports were being executed and generally who’s reports they were. With that … Continue reading Analyzing Report Execution Time
While working with a client a couple weeks back, I was asked to determine the count of reports that were being executed under each folder off the root directory on the Reporting Services instance. Each of the folders off the root directory represented a department at the client. For the output, I decided that I … Continue reading Finding Number of Reports Executed By Folder
Ever have a Reporting Services (SSRS) subscription that didn’t fire off as you thought it should? Or was SQL Agent offline when subscriptions should have been fired? Or did you just create a subscription and want to find out if it’s been configured properly? Fortunately all of the information is sitting neatly and plainly in … Continue reading I Didn’t Receive My Subscription
If you are like me and have been toying around with Report Designer (aka Report Builder 2.0), you may have noticed that it disappeared with RC0 and RTM. Unfortunately, the RC0 version is the only version currently available and even more unfortuantely, if you haven't downloaded it already you are out of luck. I am … Continue reading Where’d Report Designer Preview go!?
I found a nice little feature in SQL Server Reporting Services (SSRS) today. Through the expression "=dataset!<dataset name>.commandtext" the query executed by the dataset can be returned to the report. There is also a rewrittencommandtext function but it appears to only be populated when Report Models are being used. This feature been around for a … Continue reading Are You Sure You’re Using the Right Query?
Strate SQL 