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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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?

  • #2
    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....


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

    Automettech - Automated Metrology Technology

    Comment


    • #3
      Worked perfectly thanks!

      Comment

      Related Topics

      Collapse

      Working...
      X