on 11-02-2017 7:18 AM
Hi all,
I am new to Crystal report.I am using crystal reports 2008.
I have an issue while analyzing the report.
There are two tables in my report linked via smart linking.
The issues are the below,
1)Both has only one row of data when I run in sql developer
2)If I run those in Crystal the table 2 gives nearly 100 rows of data
3)It is linked in Left outer join.If I remove the link and run the report . The report displays same amount of data.
4)If I have done the same linking in sql developer also , it gives one row only.
5)The crystal report data is not Cartesian product.
any one knows what causes the crystal report to display more data whereas sql developer doesnt display?
Thanks in advance
Balakumar Krishnasamy
Hi Bala,
Go to the Database Menu on the top > Show SQL.
Copy the SQL and run it in SQL Developer. How many rows do you get when you do this?
Could you make sure CR is using the correct fields to join on?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.