Fantastic work Jessica. Can anybody suggest some sites that demonstrate clever uses of complex custom functions in SSRS?
Um, my blog (http://spacefold.com/lisa) has, at current count, 63 entries in the SQL Server category and 78 in the Reporting category. Some Reporting entries are obviously not SSRS, but of those that are, most use custom code of one type or another, and a lot of them use complex custom functions, sometimes in bizarre ways.
I generally write my blog posts in response to a reader's question. If you have a specific type of code you're looking for, I'll check and see if there is an entry that pertains to that area... if not, I might write a post that shows it ;-). My past and present work has afforded me with a *lot* of real-life opportunities to come up with examples, both common and uncommon.
Here's an example of using custom code to solve a common real-life problem: http://spacefold.com/lisa/post/2007/12/23/A-Pedestrian-Piece-of-Code-Goes-Walkabout.aspx
Here's an example of custom code doing something quite a bit more unusual, but still a generalized problem-to-solve, it seems to have helped a number of people:
Here's an example of custom code actually writing the SQL statement that creates a dataset (and some explanation of why I occasionally do it) :
... there are many, many other examples (some bizarre and specific, but many generally useful).
I've been thinking of writing a walkthrough on how I use custom code to localize reports. Would this be of any interest to anybody?