>I have a complex report that I don't think can be *easily* done using the report designer.

Todd,
I've had much success with creating complex reports in the Report Designer. Have you looked at possible creating queries that would put your data into an easier form to work with? A lot of times I've setup queries to dump data into a relatable form using temporary queries and then report off of those.