We are implementing a data warehouse solution using MS SQL Server Analysis Server and MS SQL Server Reporting Services which we are very new to. We have an existing company web portal we use for report distribution and other tasks.
We would like to embed our DW solution into this existing webportal allowing users to select a number of high level reports, drill down and specify parameters. Ideally the parameters would b specified using some forms we have as opposed to the headers area on SSRS reports. Is this possible and, if so, links to examples (ideally sample projects) would be very helpful.
We are using MS SQL Server 2008 R2.