Appearing/Disappearing Records - Why?

[tonykblen]

Hi,

We have a SQL server db backend for our ERP system. I have written a Crystal Report to extract data from one particular table called itemspecbomw which contains amongst other things Bill of Materials costings. When I run the report I know that some rows are missing as when I look at values through the ERP system itself, the values are different.

What I have found is that when I run the equivalent ERP system report, the Crystal Report I have written shows extra rows. If anyone knows why this mystery is happening, I woould be grateful for your help.

Many thanks,

Tony.

Tony Kennedy BSc. B.I.S.,
MCSA Cand.

A good start is half the work.
Every start is difficult .
-Two Gaelic proverbs

 

[nigelrivett]

The report is giving saved data or the report doesn't have the current version of the database schema are the usual supects.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.