We would like to base Crystal Reports on a Microsoft SQL Services Analysis Services OLAP Cube. Currently, we are able to do so via "New Olap Cube Report". However when doing so we are only able to see the measures when using an OLAP grid.
Is there a way to base a report on an MSAS Cube without being obliged to use the OLAP grid functionality? This is because when using the OLAP Grid, the normal Crystal Reports functionalities (formulas etc...) are not available.
I've heard it should perfectly work when passing through a Universe, but we prefere to connect it directly to the OLAP cube to reduce maintenance.
kr and thank you in advance,