Ad-hoc capability SQL SSRS

We are in the process of doing techincal design. We would like to know what is the Ad-hoc Capability part of SSRS. We have done some POC with Report Model and building reports with Report builder.

Options 2 : Build Analysis Services Universe and expose that through the Report builder.

I would like to know from the group each approach wha开发者_JAVA技巧t are the benifts and disadvantages. I am also looking if you have any suggestion on the Report Builder books or resource which i can refer to.

---

SSRS is rather developer focused in that its capabilities allow detailed and explicit reports that take a developer to put together

Izenda is an excellent ad hoc reporting tool, particularly from a user focused standpoint. It has na open API for deep customization, but with a simple point and click interface geared to your average user to whip up unique reports without the involvement of a developer