Sunday January 21st 2018

Categories

Insider

Archives

Crystal reports 2008 adventureworks Cube

Today I would like share my experience of utilizing adventure works cube in Crystal reports 2008. I assume that you already have created Adventure works cube in AnalysisServices 2008, you can find some information at this link for creating Adventureworks Cube.

I started the crystal Report 2008, then selected OLAP Cube report as a project, then selected the Cube option. In the Server type Combo Box, I selected Microsoft OLEDB Provider for Analysis Services 9.0. In the Caption – give name to your file, then server name where the project is residing, my project was on Local. You will then be directed to OLAP Connection browser where you should browse the cubes and then double click on the one you want to use.

After that, you will be at page dimension selector and just follow the instructions, you will find it very self explanatory.