Print Page | Close Window

Connect to Materialize View of Oracle

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1128
Printed Date: 05 Apr 2025 at 5:38am


Topic: Connect to Materialize View of Oracle
Posted By: ciatecmx
Subject: Connect to Materialize View of Oracle
Date Posted: 06 Aug 2007 at 11:30am

How can the Crystal Report (XI) connect to the materialized view of Oracle (10g R2), and take advantage of the MV feature?  A MV is a table in principle according to Oracle.


Replies:
Posted By: ciatecmx
Date Posted: 07 Aug 2007 at 2:26pm
in the connection of CR, there is no filter for MV, but the synonym.  So I created a synonym for the MV and click on the synonym.  The synonym of MV will show up and be ready. 


Print Page | Close Window