Computer – Page 4 – markwheeler.com

SSRS – Query for NULLs and Order by NULLs last

April 2, 2013 mmwheeler

Had a request to create a report for Project Server milestones. There was a custom enterprise column added for tasks which contained a location code. My report had to return all values including where location was NULL. The first step was to get a valid NULL parameter in my Site […]

JQuery – Get Value of DIV with Custom Attribute

January 1, 2013 mmwheeler

I have a ProjectServer with a custom field (Project Status Slide) where users have a URL for an image. I needed to retrieve the URL from the custom field and display it inline on the ProjectDetails.aspx page <div GUID=”xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx”>http://myserver/PWA/Pictures/Slide1.png</div> The source of the custom field resembles the above. I put […]

Sharepoint 2010 SSRS Oracle Data Access Components BadImageFormatException

October 29, 2012 mmwheeler

I am using SSRS to report against an Oracle database source directly. For a while I was getting the following error. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. Apparently there is […]

Sharepoint 2010 Email-Enabled Discussion List Content Query Web Part

October 26, 2012 mmwheeler

I had a recent request to allow supervisors to post “kudos” emails to a Sharepoint site for display on a “dashboard.” They did not want it to be labor intensive by having to logon and copy/paste email content to a list. To achieve this I created an email-enabled discussion list. […]

Sharepoint 2010 Backup and Cleanup Scripts with Notifications

October 10, 2012 mmwheeler

Simple scripts that you can automate with the Task Scheduler to backup/cleanup your Sharepoint 2010 farm with email notifications. Backup Script try { $today = (Get-Date -Format dd-MM-yyyy) #Location of the Backup Folder [IO.Directory]::CreateDirectory(“E:BackupDailyFarmBackUp$today”) # This will actually initiate the SPFarm backup. Backup-SPFarm -Directory E:BackupFullFarmBackup$today -BackupMethod full # Backup-SPFarm -Directory […]

SQL Server Analysis Services Linking to Other Instance Feature is Disabled

September 16, 2012 mmwheeler

This is related to my previous post on cloning VMs. I was not able to connect to the Analysis Server and Synchronize (cubes) between databases because of the following error. Errors in the OLE DB provider. The server returned the following, error: (Errors related to feature availability and configuration: The ‘Linking to […]

Sharepoint 2010 VM Clone Wars

September 16, 2012 mmwheeler

I have a Sharepoint 2010 standalone farm consisting of a WFE VM and a SQL Server 2008 with SSRS, SSAS on another VM. This farm lives in DataCenter1. Because of network issues and proximity to a data warehouse; I needed to move these VMs to DataCenter2. Once the VMs were […]

Sharepoint 2010 Personalization Site and Global Navigation Audience Targeting

July 3, 2012 mmwheeler

For whatever reason; the Global Navigation in a Personalization Site template does not support Dynamic FlyOut menus OR Audience Targeting. I had added several custom links in my top navigation bar and audience targeted them according to specific user roles. All users, however, could see every link regardless of the […]

Rename SQL Server 2008 R2 Reporting Server Databases

June 13, 2012 mmwheeler

Had a task to move the default SQL Reporting Services ReportServer and ReportServerTempDB databases to a new SQL cluster which required a rename to avoid any potential conflicts. These instance of the databases are being used in Sharepoint-Integrated Mode. You could do Step 7 below before you do Steps 4 […]

Populating Notes field from Cascading Dropdown Selections

April 30, 2012 mmwheeler

This was a solution I figured out for populating a notes field from cascading drop-downs. I’ve had some folks e-mail me asking for the actual implementation. In my scenario, I was creating a Sharepoint form front-end that would create an Incident Ticket in BMC Remedy. […]