Added BIN number
Added BIN number
(OP)
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.
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.
RE: Added BIN number
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html
RE: Added BIN number
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?
RE: Added BIN number
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.