cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report Query returns data but same query in SQL developer returns less data

former_member187092
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

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