How to Format the Labels in a Pie Chart in SSRS 2008 R2

OK this REALLY made me do a facepalm.

I was wresting again with SSRS (Microsoft’s SQL Server Reporting Services), and was just trying to format the numbers in a pie chart. It seemed clear enough: right click on the little numbers in the pie chart and edit the number format. It even displays all the numbers in all the pie slices with the new format.

Easy, right?

No.

That change only affects the first series, with no obvious way of selecting the other series values to format them… since they look like they’re already formatted!

[image here…]

Turns out you have to move the next series to the top position in the “Chart Data” floating tool window, and then you can modify the values. I found the answer here on Stack Overflow:

reporting services – How to Format the Labels in a Pie Chart in SSRS 2008 R2 – Stack Overflow

i had this same issue, if you just use the arrows (little blue arrows at the top of the chart data box) to move the value to the top of the list you can edit the label details/code/expression etc for that series. then just repeat this for all the values you’ve added. i’m sure there’s a better way but this worked so that’s what i did. It seems that when you are editing a label it is only ever editing the item/value at the top of the list, after you’ve done your labels then just shuffle them back into the order you wanted them listed

Once you do this, you see new values, unformatted (or, more accurately, formatted with the default number format).

[image here.]

You can then go through the same process as before and change the number format for those data points in the series.

What a pain.

How to Remove a Workspace from Team Foundation Server 2008 [#TFS #dotnetdev]

Recently I ended up having a workspace conflict in Team Foundation since it paired another user’s name with my machine’s name, and then when I attempted to establish a new workspace, it complained with a message like:

The working folder C:\dev\MyWorkingFolder is already in use by the workspace MYMACHINENAME;otherguy on computer MYMACHINENAME.

So after a fair amount of research, I did the following:

Launch the command line prompt (Start Menu >> type “cmd” into the Search text box, hit Enter).

Navigate to “C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE”, using:

CD "C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE"

List the other user’s workspaces using the tf workspaces command:

tf workspaces /owner:otherguy

Find and note the offending workspace (in this case, it’s a workspace with my machine name), and then delete it using the tf workspace command:

tf workspace /delete MYMACHINENAME;YOURDOMAIN\otherguy

That did it for me, your mileage may vary, but hopefully this will prove helpful to someone in the future…

Thanks also to this post.

How to Add a “Send Link” Button to the Bookmarks Bar in Chrome

Really helpful tutorial about how to add a bookmarklet to your Chrome Bookmarks Bar that emails the URL to the current page open in Chrome.

I needed to do this recently so this really came in handy, and it’s super easy to implement.

Basically here are the steps:

  1. Open Chrome (if it’s not already…).
  2. Right-click the Bookmarks bar and select Add Page.
  3. In the Name textbox, input the word Send Link.
  4. In the URL textbox, input the following:
    javascript:location.href='mailto:?SUBJECT='+document.title+'&BODY='+escape(location.href);
  5. Make sure that the Bookmarks bar folder is selected and click OK.

Source: Google Chrome: Add a Send Link Button to the Bookmarks Bar | a Tech-Recipes Tutorial

Separation Anxiety from Apple Magic Trackpad Eased with Logitech T650

I love my Apple Magic Trackpad, but it can be tricky to get working on a Windows machine, so I decided instead to try out the Logitech T650 Wireless Rechargeable Touchpad. So far so good. The feel is very similar to the Apple trackpad, and the gestures (even under Windows 7) are tweakable so they feel more at home.

For instance, if you go into Logitech Mouse and Keyboard Settings application, you can adjust the two-finger scroll to behave like OS X’s tracking of your finger movement, effectively inverting the scroll (though the settings doesn’t word it that way…).

They can be had at Amazon for under $40, and to have more of a Mac-like experience on a Windows machine, I think it’s worth it.