Inspired by the Mini Pinball machine here: http://www.instructables.com/id/Mini-Pinball-1/ I decided to give this a try with a solderless version. Thanks to Pascal for working with me to reconcile some troubles I had with his PinballButtons.apk. Tips and Caveats: 1. You must install the PinballButtons app from above. 2. You must have the […]
Accidently killed a shared datasource for 1000 reports. Found a handy query to update all those reports with a re-created datasource. Updated a couple of reports manually in Sharepoint. Ran the following against the ReportServer database. select c.Name as reportname, d.link, d.Name as datasource, d.dsid, d.itemid from Catalog c inner […]
Update 4/23/2014: I have posted a new method using a Script Task. Had a request to dump a large dataset from a SQL query into a CSV file and then upload that file to a Sharepoint document library. Because the resulting file was large, I zipped the file using a […]
Discovered this SSIS dataflow task called HTTPDownload. The link here is a dtsx package you can import into Visual Studio. Modify the HTTP Connection Manager with the URL of the file. Note that this has to be specific, so the source file has to be the same if we are […]
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 […]
See all the videos at my YouTube Channel
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 […]
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 […]
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. […]
Here’s a play testing video.
