Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 02, 2017 at 09:55 AM

    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?


    Add comment
    10|10000 characters needed characters exceeded