Print Page | Close Window

Retreive data from wrong schema

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=13187
Printed Date: 23 Apr 2025 at 1:09pm


Topic: Retreive data from wrong schema
Posted By: podi
Subject: Retreive data from wrong schema
Date Posted: 12 May 2011 at 8:30am
Hi,
 
I have a report that has few subreports. Some times some of these sub reports retreives the data from the same table in different schema.
 
ex: if I have table TEST on schema A and B, and I use A.TEST in my report, but it get the data from B.TEST when I had login as user A.
 
Do anybody have any idea what is going on here. I use CR XI and Oracle 10g.
 
Thanks and appreciate any help.
 


Print Page | Close Window