• akirajt (12/3/2013)


    Goal:

    Create an additional functionality in report server. It is a button or an address link and when you press it then you open a Excel application containing a customized templete. The Excel's sheet is connected to a cube in SSAS.

    Problem:

    Is it possible to do it to fullfill the goal?

    Information:

    *The report server is located in a server and the user use client computer. If endusers gonna review the report in report server, they have to type the IP number and "reportserver" in the webrowser's address field.

    *Using SSAS as a datasource.

    *You should enable to save the document in the end user's computer.

    Not exactly what you want, but if you have SharePoint, you could create an SSRS action in your report to go to the Excel sheet's URL where it's stored in your SharePoint site. The Excel sheet could use SSAS as its data source.

    Just a thought,

    Rob