Skip to Content
avatar image
Former Member

Not All Data Is Present In Report

When I create a report in crystal reports and link more than one database I lose part of my data. All the data I want to appear does not show up in report. Does anyone have an easy solution for this

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 05:04 PM

    Hi.

    Can you please check the join between two database tables ? If you are joining with Inner Join than that case you will loose some data where it is not present in either of the tables. Try to use Left Outer / Right Outer joins according to your data tables.

    Thanks,

    Sastry

    Add comment
    10|10000 characters needed characters exceeded