Warning: Some whining ahead…
Whew, so these past few weeks have been crazy! For one, I was selected to speak for 24 Hours of PASS! I will be doing a session on MDX queries in SSRS, namely pointing out some useful tips and tricks I’ve learned with MDX in order to get my reports to do what I want ;). Unfortunately for me, this is not a session I’ve done before, so I have to generate content from scratch, and I get the worst cases of PowerPoint block….
I also was recently cast in a play called Matt & Ben, about Matt Damon and Ben Affleck who happen to be played by two girls. I play Ben Affleck :). This has been a lot of fun, but it’s a very short rehearsal schedule (we open on Friday) so I’ve been at the theater every night. The show is over March 7th, so I thought, oh I’ll have plenty of time after that to work on my presentation! Except that the slides are due February 23rd, which is Wednesday. Eep.
Even this wouldn’t have been SO bad if it wasn’t also for the fact that I recently signed on to a new full time project doing some report and cube development. This is good because it means I make money. This is bad because when do I find the time to do my presentation?! I’m a perfectionist and I’m starting to get a weeeeeeeeeee bit concerned. I’m also really tired.
So I’m sitting here now, getting together an outline and resources and figuring out, what the heck do I want to SAY to you all? I plan on keeping the actual slide portion short (although I’m terrified it will be too short) and doing a lot of demos. After all, I want to show you clever queries, not yap at you about them. I have a few demos planned, but here’s where I ask you all for help.
You voted for my session, so that means you want to see something that will hopefully help you out. I’m going to have a section at the end of my presentation where I show you some miscellaneous queries that solved an assortment of problems I’ve come across. They will use the tricks I show you earlier in the presentation, but also walk you through my thought process when I’m thrown an SSRS curve ball. I want YOU to throw some of YOUR SSRS curve balls at me. What scenarios have you run into with queries for an SSRS report where you just couldn’t figure out how to get the query to do what you want? Strange groupings? Sorting issues? What causes you to beat your head against the wall? I’ll take ’em on!