Added BIN number

[tjbennett]

Macola ES 9.5.700, Crystal Reports XI

Has anyone added the BIN number, from the IMINVBIN_SQL table to the Crystal Report Pick Ticket? I am once again getting the "Run-time error ‘9’, Subscript out of range” error after adding it. And I went through every sub-report this time and can't find any problems.

I heard that Macola may have included it in a suppressed (serial/lot/bin) sub-report somewhere on this report. But I haven't found it.

 

[dgillz]

I am about 80% sure you must modify the subreport to do this. You should call your business partner or exact regional office and this should be a reasonable issue to address.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[DBergkamp10]

Hi,

If it's the same as the Progression one, then in details c section there is a subreport which has IMBINTRX_SQL in it, not sure how IMINVBIN could even work for this?

 

[tjbennett]

We only have ONE bin per part (at least right now). So I just needed to show what BIN number is assigned to a particular P/N. Anyway I did finally get it all to work. The MAJOR problem I was having was updating the Macola database used to create the ICR to my database. Until I was able to do that I would just keep getting the error messages and not be able to do anything with the data.

So to fix it ...... I had to create a new "OLE DB (ADO)" connection to my Macola database and then I was able to "update" the Macola database to mine. Then I could work with the data.