Reporter bug

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

Posted by Grant Foraker on August 22, 2008 at 09:58:10:

Using old Reporter but this may apply to new too.

==========================
ERASE WORKQ10,PAC
PRINTER WORKQ10,PAC
WORKDISC PAC
INPUT P.O.SUB.LINE
NOHEADINGS
REPORT
INDENT 0
SPACES 0
USING Q12.TO.Q10
SELECTING IF SUB.COMPLETED NE 'X' AND P.O.STATUS NE 'X'
TOTAL P.O.NUMBER,P;SUB.COMMIT;TOTAL.COMMIT,P;P.O.ORDER.DATE,P;P.O.STATUS,P
BREAK ON P.O.NUMBER
=======================
Q12 can be multiple records linked to Q10 where there is one.

The "TOTAL.COMMIT,P" is totalling not just printing the the field. If there are ten Q12 records then TOTAL.COMMIT is ten times it's value.

Follow Ups:


Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





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

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]