Crystal not displaying all data.

[allivant]

I can see all the data in webi but crystal only shows some of the data. Any ideas on what may be the problem? Does it have to do with the universe?

 

[Madawc]

Are you showing data from more than one table (dataset)? A common problem is linking Table A to Table B when there may be no entry for Table B. You need to make the link 'left outer', otherwise you won't see any table A record that lacks a table B entry.

Another common error is testing for a value in a field and not allowing for it being null. Hitting a null stops any formula unless IsNull is used first.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP