How can I use a drop down list for Comments on a report?

[zachzwp]

We are trying to use comments for them to display on the excel report that is created. We have some code to do that, however we need it to be a drop down list so that they cannot put wrong labels on the report. I want it so that when they start up the program it prompts them to input the machine number and shift from drop down lists and have them be labeled on the excel report that is created. What is the best way to go about this?

[NinjaBadger]

Use a form.

File > Reporting > New > Form Report

Place a combo box on it.

Right click on form to open properties window

Add your items to the ListItems propertiy

Repeat as necessary for shift / machine / operator etc

Save the form


In part program...


Insert > Report Command > form and select your saved form.


To link pc-dmis assignments with comboboxes do this....

ASSIGN/MY_SHIFT=""
CS1        =FORM/FILENAME= C:\USERS\JON.WOOD\DESKTOP\MYFORM.FORM
            PARAM/COMBOBOX1.TEXTVALUE=MY_SHIFT
            PARAM/=
            ENDFORM/
            COMMENT/REPT,
            MY_SHIFT

[zachzwp]

Worked perfectly thanks!