470,863 Members | 1,139 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,863 developers. It's quick & easy.

crystal reports returns more rows than expected from an Oracle view

I have created a fairly complex view based upon several UNION statements and the view selects exactly the rows that I want if I am in ORACLE SQLPLUS or MS Access. But in Crystal Reports it returns rows that should not be visible through this view. Has anyone else experienced this and what did you to get around this?
Oct 2 '07 #1
2 6257
debasisdas
8,127 Expert 4TB
It never happens that the same query / view will generate different output for different applications / tools.

Check for SQL Query taht is being passed to the Crystal Report at runtime.
Oct 3 '07 #2
johnmurphyx
1 Bit
@debasisdas
I have the exact same issue , run view in TOAD get diff results than CR
Apr 4 '22 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by kristoff plasun | last post: by
9 posts views Thread by Robert Schuldenfrei | last post: by
reply views Thread by Chris | last post: by
1 post views Thread by LMPSteel | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.