Reports Sorting Reference ID

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

  • Reports Sorting Reference ID

    Hi I have research on line and in the forum, but I cannot find any references on how to sort by Ref_ID in order. When running a report for easier viewing without exporting to excel first. PCDMIS Reports puts everything in machine order. Can the sortup command be used in the label code below.

    = ID +If(Len(REF_ID:1)>0,("-" + STR(REF_ID:1))," ")+ If(Len(REF_ID:2)>0 AND REF_ID:1<>REF_ID:2,
    (" " + LOADSTR(-247)+" " +STR(REF_ID:2)),"")+ If(Len(REF_ID:3)>0 AND REF_ID:2<>REF_ID:3 AND REF_ID:3<>LOADSTR(-492),("( " +STR(REF_ID:3)+")"),"")+SUMMARY_TBLHDR

    I would greatly appreciate any help

    JT

  • #2
    What is that label supposed to show, and how do you want to show it instead?
    AndersI
    SW support - Hexagon Metrology Nordic AB

    Comment


    • #3
      The labels are connected to the machine code. When you run the report. It loads the reference IDs (balloon numbers) by machine sequence order. I want the report to be loaded by Balloon Order for easier viewing at Inspection.

      Comment


      • #4
        AFAIK it can't be done.

        The way the reports work is when called, it starts at the top of the program and works down.

        For each command it encounters (Dimension, Feature, Alignment, Comment etc) it looks in a Rule Tree for what label to display for that command type. i.e. For a dimension location command use label X, for a comment use label Y. etc

        You need to be looking at custom reporting, where you can drag and drop commands in any order, but you need to do it for each dimension and for every program it's required for.
        Automettech - Automated Metrology Technology

        Comment


        • Jill Tryba
          Jill Tryba commented
          Editing a comment
          Thanks For your Reply

      • #5
        On the other hand, just have all of your dimensions in ascending order at the end of the program. Another, method is to export to excel and sort the results in ascending order. I find it easier for excel to sort the dimensions ID balloons numbers using this type of format. Example: Balloon numbers 1 thru 10 use 01_01 thru 10_01. Example: Balloon numbers 1 thru 100 use 001_01 thru 100_01

        Comment


        • Jill Tryba
          Jill Tryba commented
          Editing a comment
          I was hoping there was a way to not have to export to excel first. TY

      • #6
        The only way I can think of is doing the dimensions in balloon order in the program. Don't dimension directly after measuring, but in a block after everything is measured - then you can easily rearrange them in any order you want. Unfortunately, that will add a little bit to the total runtime, as the report isn't started until all measurements have been done.
        AndersI
        SW support - Hexagon Metrology Nordic AB

        Comment


        • #7
          Thanks All, It doesn't lool like there a way to solve this issue. If I figure it out, I'll let you know.

          Comment


          • #8
            The only way I've got it to report out of sequence is to use sections, then I could report by dimension type (but each section was in still i program order),

            Have you looked at custom reports? How big are your programs, how many programs etc?
            Automettech - Automated Metrology Technology

            Comment


            • Jill Tryba
              Jill Tryba commented
              Editing a comment
              333 Programs... the lengths vary.

          • #9
            I know you posted that you don't want to go to Excel, but your solutions are either that or editing 333 programs to order the dimensions.

            We use Excel quite a bit, the VB programming capability of macros is nearly limitless.

            Comment


            • #10
              I'm sure there is a way with VB, to export out all your programs, save them, and then open and organize all the items the way you want.
              so yes it is possible.

              However, you would have to compensate for alignments/workplanes.
              Certain feature being toleranced in one alignment, and then needing to be done in another.
              Same with workplanes.

              So you would have to do to a multi step sort.
              Pull in active alignment for dimenionsal purposes, then active workplane.
              Account for it and organize as needed.

              So by no means it is impossible.
              Daunting and convoluted, very.

              I agree, an excel export is the more efficient method.

              Comment

              Related Topics

              Collapse

              Working...
              X