Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Added BIN number

Status
Not open for further replies.

tjbennett

MIS
Feb 8, 2005
95
US
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.
 
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:
 
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top