In this example we will use a SharePoint list as a data source in a SSRS report using SQL Server 2012 Report Builder.
Begin by adding a new data source to your report. Select Microsoft SharePoint List under the connection type dropdown. For the connection string you will want to enter the root URL for your site/subsite. For example, if the URL for our list is
http://technicaloverload.com/My-Test-List/, then you would enter
http://technicaloverload.com/ in the connection sting box.
false if no match was found.
Sometimes, after changes to Microsoft Office are made you may start receiving the error message:
The Language DLL ‘VBE7INTL.DLL’ could not be found.
Or VBE6INTL.DLL if you’re using an older version of Office. To resolve this error, you need to install the Office Shared Feature, Visual Basic for Applications.
If you have moved to Office 2013 you may have noticed that Microsoft decided to remove the Office Picture Manager application. I was a fan of OPM as it let me quickly edit photos without installing another third-party application and also had some nice batch editing functions available.
While there is no 2013 version of Office Picture Manager available, there are a couple of ways to get it back. Continue Reading
“I am writing to let you know that I will retire as CEO of Microsoft within the next 12 months, after a successor is chosen. There is never a perfect time for this type of transition, but now is the right time. My original thoughts on timing would have had my retirement happen in the middle of our transformation to a devices and services company focused on empowering customers in the activities they value most. We need a CEO who will be here longer term for this new direction.”
Here are three easy ways to change the default database for a user in SQL Server.
Option 1: Execute the system stored procedure
EXEC sp_defaultdb @loginame='UserName', @defdb='NewDefaultDB'