Stopping the report creation with if statement

[zachzwp]

I am attempting to use a form and if statement to make a way for the operator to not create the excel report in certain instances. I have the form and if statement all set up, but I am lost on what code to use inside to tell it not to create the excel report. The way we have the excel being created is by going to FILE-PRINTING-PRINT REPORT WINDOW SETUP and having it automatically create an excel report each time. There is no actual code in the program that refers to this to my knowledge so I am not sure how I can utilize this and make it do what I need it to.

[Ego Murphy]

EDIT: crap this will never work: It may be easier to simply have a FILE/DELETE command go wipe the file out if the operator choose to not make the Excel report.

Why would the operator want to skip the reporting?

[anthony.alfaro]

you would probably want to utilize the print command rather than setting the default printing. With this you could simply have a label before and after the actual print command with a couple of "GOTO"s based on user decision.

Print commands work the same as the file-printing except it DOES actually put some code in the program instead of just doing it by default.

[zachzwp]

I want the reporting to be cancelled because we are only using the excel report to integrate the data into our SPC software, and we don't want startup or changeover parts to be skewing all of the data. I am very new to PC DMIS, how would I go about taking the automatic excel creation and making it into a print command code.

[anthony.alfaro]

navigate to file > printing > report window print setup...UNcheck the little boxes at the top left corner of each tab (report, dmis, excel)

click in the edit window where you want the report to be generated and go to Insert > report command > print command...

once you have the print command code in your program you can just "F9" it and the same window will pop up as it would if you went to printing > report window print setup and you can edit the settings from there. With this the report will generate when the execution line hits the print command rather than when the program finishes.