We're wanting to make some custom MSCRM reports available via a Custom Tab in c360 portal. Report data comes from User, Account, Case & some Custom entities related to Cases.

Has anyone achieved something similar?

Am assuming we would need to install an instance of SQL Reporting Server on the Portal Server to facilitate clients not having direct access to MSCRM.

Thanks!