hexagon logo

Comment's text in custom report

Hi,


I'm basically new to the report editing, and I'm trying to make custom report, with a checklist. Question is, 'is there a way to insert a comment's text into the custom report?' The comment is Yes/No type
Right now I'm using a GridControlObject, and assigned variables for every comment (like V1=C1.INPUTVALUE), so I can make the OK/NOK columns with an 'IF' function, but i have to type the text twice. And have to use different functoins for every line. This makes it a bit difficult.
The best would be if I could make a template, but if i simply try to use for e.g. C1.INPUTVALUE in the custom report, it won't work.
I want to do something like in the attachment

Any ideas for this?
Thank you

Attached Files
  • Open/select the PPAP report and see if that have the OK/NOK columns in it, if so, you could "steal" the code from that to work in your custom report.
  • Thank you, but OK/NOK column is not the problem, I already have a solution for that, and PPAP's solution works only for dimensions. My problem was inserting the comment's text to the grid control object with a code if it's possible.

    I'm here right now:

    In the programming field:
    C6 =COMMENT/YESNO,NO,FULLSCREEN=NO,AUTO CONTINUE=NO,
    No scratches on the surface
    ASSIGN/V6=C6.INPUTVALUE

    In the report:
    First column is the text [No scratches on the surface ] (no code for that so far, but it seems I can drag it to the report when i change the programming field to the other view ), second is the OK [ =IF(variable("V6")==1,"a","") ] and the 3rd NOK column [ =IF(variable("V6")==2,"x","") ]


    I wonder, if it's possible to create a template without using variables, so I won't have to modify every line of the grid control object.
  • figure this out yet? how are you trying to report it as text or into a grid control object? I have no issues when I report variables into grid control objects but did have trouble into a text field... if I recall it is why I created small labels to handle it on the custom report
  • There are some limitations with displaying variables in the GridControlObject of a header of a report, discussed here.

    I don't know if that's where you're trying to put the "No scratches on the surface" text, but if so, one workaround might be to create a variable for the "No scratches on the surface" text:
    ASSIGN/Q1="No scratches on the surface?"


    Then create a Text object and drag it on top of the grid cell in the GridControlObject. Then call the variable value as usual inside the Text object:
    =variable("Q1")