ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> CR XI problem
http://www.istechforum.com/YaBB.pl?num=1140118941

Message started by timgolds on 02/16/06 at 11:42:21

Title: CR XI problem
Post by timgolds on 02/16/06 at 11:42:21

Hope someonecan help.

Here's the problem. Working on a drill down report where I look for all WIP variances within GLTRAN (use the GLACCT field) then I take that record and fild the associaed work order for the transaction. Sound simple but BKGLTRANS.BKGL.TRN.INVC is a string and WORKORD.MTWO.WIP.WOPRE is a Double so I do the following:

{WORKORD.MTWO_WIP_WOPRE} = val(left({BKGLTRAN.BKGL_TRN_INVC}, 6)) <-- 2 SP +#

This appears to work most of the time but every now and then I get one that's missing. I looked in WORKORD and there is a prefix of 1160 there and I looked in BKGLTRAN and the entry is "__1160- 1____" It works for every thing except the example above and one other.

Any ideas would be a great help.

Tim

Title: Re: CR XI problem
Post by timgolds on 02/16/06 at 14:17:55

OK After doing some debugging, it would appear CR is skipping the record on the data and not the "munge" will check for problems in the table.