Thursday, June 16, 2011

Ever wanted shapes and check boxes in SSRS?

I do some webdesigning in my own side business, and was installing some fonts, then this crazy idea came to my mind about using the default fonts that comes installed in windows to produce shapes in SSRS.

The various fonts are called " Webdings, Wingdings, Wingdings2 and Wingdings3 "

Basically you'll use IIF or SWITCH to set your desired shape, you'll need to use capital letters, small letter or numbers.

The list of the shapes and the corespondent key could be found here http://www.purplehell.com/riddletools/wingdingschart.htm

P.S. Use IE to view that page, firefox doesn't display that font correctly!!

Examples:

Hope that helps someone.....