4 Replies Latest reply on Sep 13, 2018 11:54 PM by sasingh

    Report builder to show terminal part number?

    mr_ew

      Does anyone know where in report builder is the command to show the terminal part number?  If not possible in report builder, is it possible to modify the config file and have it shown in there?  I appreciate the help!

        • 1. Re: Report builder to show terminal part number?
          sasingh

          Hello,

           

          I have tried to jot down steps for you to achive the result, although a snap shot of what and how exactly you want to have the report would have been more informative for us to look into.

           

          In case if you just want a report of all the terminals used in a harness drawing, you may follow the below steps:

          Step1: Write a query to show Terminal Part Number.

           

          This query will check each wire ends and return the related Terminal Part number.

           

          Step2: Now, on your harness drawing, go to Workflow->Reports->Build. Select Wire as an entry object and then add the query.

           

          Step3: Once you select "Done", it will list all the terminal part numbers.

          Once you have saved the report, you can go to Workflow->Report Builder-> Reports-> Select the Report you created-> View Report

           

          Please let me know if this helps.

           

          Thanks

          Saurabh

          1 of 1 people found this helpful
          • 2. Re: Report builder to show terminal part number?
            mr_ew

            Hi Saurabh,

               I very much appreciate your feedback.  I'm new to Vesys but I'm learning too. When I was asking about this feature to our local rep. They referred me to this site.  So I appreciate your help.  With that said, here are some screen shots showing what I'm trying to do.  From the below image, you can see that we've added the cost per foot for the wires that we use under the "Architectural Cost".  Please understand we are using this cost as an estimate on our designs.  This is NOT intended to check up on our harness supplier.  We were hoping to add the cost of the terminals and connectors and such to this same attribute.

             

            As I said before, I'm still new to Vesys and I wasn't sure which is easier to do - use the report builder or write a "program".  In the image below, you can see that there are to "programs" for getting the cost of the harness.  The one without the "2" is my attempt to use the "Report Builder".

               

            From the image below, you can see the cost of the wire/foot and total cost of the wire.  My next step was to get the cost of the terminals and then the connectors.  So I'm slowly building this report up step by step.  However, I'm getting stuck trying to show the terminal part number.

             

            So I then went and started to write a "program".  Please see the image below. 

            Using this method, I was able to get the terminal part number to show up.  See image below.  However, I'm still stuck at getting the cost of the terminal.

             

            I hope this makes more sense now.  Again, I do appreciate your help!!  I was getting nervous when no-one was replying to my question.  I couldn't believe that I was the only one trying to do what I'm trying to do.  Anyway, I was confused on how step one was done to get that query to show up in step 2.

            • 3. Re: Report builder to show terminal part number?
              Gabi

              Hello,

              Thanks for the tip!

              I had an almost the same question. I wanted to export the additional components on all connectors from a design.

              With your solution, I made it!

              Regards,

              Gabi

              • 4. Re: Report builder to show terminal part number?
                sasingh

                I am glad it helped you

                Thanks

                Saurabh