Creating CrossTab reports by using OLAP data sources
CrossTab reports are particularly suited to displaying and exploring data contained in OLAP servers. You can create CrossTab reports from fields in an OLAP server by selecting an OLAP server as the data source. You can also import CrossTab reports created with OLAP software into Quattro Pro.
To select an OLAP data source for a CrossTab report |  |
|
1.
|
|
Click Tools
 Data tools CrossTab Report. |
|
2.
|
|
Enable the OLAP source option.
|
|
3.
|
|
Click OK.
|
|
4.
|
|
In the CrossTab data sources dialog box, select the server you want.
|
|
5.
|
|
In the Connect to provider dialog box, type a user ID and password.
|
To import OLAP CrossTab reports | |
|
1.
|
|
Click Tools
Data tools CrossTab Report. |
|
2.
|
|
Enable the OLAP report option.
|
|
3.
|
|
Click OK.
|
|
4.
|
|
In the CrossTab data sources dialog box, select the server you want.
|
|
5.
|
|
In the Connect to provider dialog box, type a user ID and password.
|
|
6.
|
|
Select a data source.
|
|
7.
|
|
In the CrossTab report dialog box, click Import report.
|
|
8.
|
|
In the Import templates dialog box, choose a report type.
|
|
9.
|
|
In the Import report dialog box, choose a report.
|
|
•
|
|
You must have an OLAP provider running in the background before you can connect to the server.
|
|
•
|
|
You can also click the Import report in the CrossTab report dialog box to import OLAP CrossTab reports.
|