Re: Comet Reporter Error 42

Posted by Barbara Brazil on August 11, 2011 at 11:50:52:

In Reply to: Re: Comet Reporter Error 42 posted by Odniel Manon on August 11, 2011 at 11:07:08:

Thanks for posting the report spec file. I can see what's wrong. If this report was created by DataExpress, it didn't get the USINGs in the correct order. If you can modify this in a text editor, try:

DICTIONARY SHP
WORKDIR TMP
PRINTER LPT
INPUT stock.lot.piece
TITLE DISCONTINUED LIST
INDENT 0
REPORT
SELECTING on.hand.pce gt 0
SELECTING warehouse eq "WHS"
USING i1r.2.i1a;i1a.2.i1p
SELECTING pattern.number ne " "
SORT pattern.number
SELECTING discontinue.dte ne " "
PRINT pattern.name;item.number;lot.number;pce.number;on.hand.pce;discontinue.dte;pattern.number;
warehouse
RUN DX,UTL,SHP

Depending on what you want you may also want to combine the SELECTINGs with an AND:

DICTIONARY SHP
WORKDIR TMP
PRINTER LPT
INPUT stock.lot.piece
TITLE DISCONTINUED LIST
INDENT 0
REPORT
SELECTING on.hand.pce gt 0
SELECTING warehouse eq "WHS"
USING i1r.2.i1a;i1a.2.i1p
SORT pattern.number
SELECTING pattern.number ne " " AND discontinue.dte ne " "
PRINT pattern.name;item.number;lot.number;pce.number;on.hand.pce;discontinue.dte;pattern.number;
warehouse
RUN DX,UTL,SHP

I'll try to reproduce the problem by using DataExpress to create this report.

Follow Ups:

• Re: Comet Reporter Error 42 Odniel Manon 12:57:38 08/11/11 (3)
  • Re: Comet Reporter Error 42 Barbara Brazil 13:19:11 08/11/11 (2)
    • Re: Comet Reporter Error 42 Barbara Brazil 11:20:18 08/12/11 (1)
      • Re: Comet Reporter Error 42 Odniel Manon 11:42:47 08/12/11 (0)

Post a Followup

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.