Crystal Report from OLAP Data Introduction - Using Crystal Reports with OLAP Data

(Page 2 of 4 )

Crystal Reports version 8.5 was used to generate a sample report from the 'Sales' Cube in the SQL 2000 Analysis Server. The report generation is completely driven by a wizard. The main steps involved in generating this report are as follows:

Connection to OLAP Server

As soon as you open the Crystal report program, you get the Welcome to Crystal Reports screen. If you choose the Using the Report Expert radio button, you will get access to the wizard, which walks you through creating a report.

There are different types of OLAP sources, such as Essbase Cube, OLE DB for OLAP, IBM DB for OLAP, Informix's MetaCube, and so on. For SQL 2000 Analysis server the correct type is the OLE DB for OLAP (Provider msolap) needs to be chosen.

Supplying connection information

Once the OLAP type is chosen, then the connection information needs to be furnished in the following format:

Next: Choosing a CUBE >>
 

More Database Articles
More By Jayaram Krishnaswamy

Comments On: Crystal Report from OLAP Data Introduction

· I am welcoming you again for a fruitful discussion of this topic. The version of...    · I've created cube In Sql sever.. when i try to attach the report with OLAP...    · Your question is somewhat vague. Could you let me know at what stage of the wizard...    · can I use an Oracle OLAP cube with Crystal REports in the same manner as demostrated...   >>> Post your comment now!