Just in case anyone need encounter problem with Reveal in Finder with Alfred, it’s not Alfred’s fault. You need to relaunch Finder and kill some process. I’ve included the workflow download link here with some bonus: http://d.pr/f/xrvs
I’ve explained it in my post:
If you’ve encountered a bug that stops you from revealing Alfred search result in Finder, then you’ll need this command. Usually it happened after you relaunch Finder without killing “appleeventsd” process. With this, you can relaunch Finder and kill the process in one stroke. Because we need sudo command, you’ll need to enter your user password in the workflows menu (see the Relauch Finder shell script).
Let me know if you find it useful.