SSRS 2005 - I have created a report model, but I don't see a way for a user to create ad hoc reports with outer joins. Is Ad Hoc reporting only for simple reports?
My understanding of ad-hos reporting using report builder and report models is that you should provide the user(s) with a report model that negates the need for any "advanced" sql skills. It should be drag and drop appropriate columns onto a report.