Excel Form Report and Looping

Looping a program for a capability study, reporting out with Excel Form Report. I have it set up for 30 parts.
2020R2.
It keeps reporting the first part rather than each new part. This used to work. What may have changed?

Parents

AverageInspector over 2 years ago

S_Cliff

see attached.

I got it to work but the first dimension repeats to the 2nd. If i run 6, I get 5 total parts measured, with 1 and 2 being the same result. any idea why?

Attached Files
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
S_Cliff over 2 years ago in reply to AverageInspector

I'd have to see your code. Here's an example of mine that works.

manual alignment

LOOP1 =LOOP/START,ID=NO,NUMBER=99,START=1,SKIP=,
OFFSET:XAXIS=0,YAXIS=0,ZAXIS=0,ANGLE=0
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=OFF,AUTO=1,AUTO OPEN=OFF,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMENSIONS=NO,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=DELETE_INSTANCES

program: DCC alignment, features, & dimensions

EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=Large Chassis Template, TYPE=XLSX
RESULT FOLDER/C:\PC_DMIS Search Path\Reports\Excel Reports
LOOP/END
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

S_Cliff over 2 years ago in reply to AverageInspector

I'd have to see your code. Here's an example of mine that works.

manual alignment

LOOP1 =LOOP/START,ID=NO,NUMBER=99,START=1,SKIP=,
OFFSET:XAXIS=0,YAXIS=0,ZAXIS=0,ANGLE=0
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=OFF,AUTO=1,AUTO OPEN=OFF,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMENSIONS=NO,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=DELETE_INSTANCES

program: DCC alignment, features, & dimensions

EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=Large Chassis Template, TYPE=XLSX
RESULT FOLDER/C:\PC_DMIS Search Path\Reports\Excel Reports
LOOP/END
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data