I have this scenario:

WServer 2008, SQL Server 2005, MS Analysis services (SSAS), ISS7 and a OLAP CUBE.

I need to **embed the OLAP result** in a webpage in an existing site.

**I don't need any** selection of dimension, no any drill down, no any 3 dimension, just a passive result of a preset MDX query.

Below here an example of MDX query used: **(Sell statistic for an agent in a period)**

```
SELECT NON EMPTY { [Measures].[Valore] } ON COLUMNS,
    NON EMPTY { ([Prodotti].[Top Marca].[Top Marca].ALLMEMBERS * [Calendario].[Anno -  Mese].[Mese].ALLMEMBERS * [Agenti].[Cod Agente].[Cod Agente].ALLMEMBERS ) }
    DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Calendario].[Anno].&[2012] } ) ON COLUMNS 
    FROM ( SELECT ( { [Agenti].[Vw Agenti].&[005] } ) ON COLUMNS FROM [Vendite])) 
    CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

```

Below an easy result that i need to show in the website:

![olap result](https://i.stack.imgur.com/5f95X.jpg)

I tried to use Report Viewer but seem I can't due this error:

> 
> Remote report processing requires Microsoft SQL Server 2008 Reporting Services or later
> 
> 
> 

and I can't install SQL Server 2008 so I need an alternative solution.

I tried some open source but they need install JAVA and more, most also not connect to SQL Server or required a different web server.

I tried also use a TSQL query but it return only 1 column for the months when in real i need many columns as months calculated

*NOTE: the users are many with many different operating system and browser as iPad, Mac, Windows, Linux, ... so the result must be an HTML output*

**So my question is:**

What is the best way to develop a simple webpage (asp or aspx) (server side or client side) to query the cube to get a simple result **(must be HTML)** as show above, without any selection by the user ?

Or what didn't I understand at all with this scenario ?

Thanks in advance for who can help me!