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.