Anonymous

Customizing Explorer Report Views

Posted By Anonymous

I am trying to put together a report that shows the labor cost that is applied to each BOM/Routing at each operations step.

 

Something like:

 

Part ABC     Operation 1     $1.00

Part ABC     Operation 2     $2.50

Part ABC     Operation 3     $3.00

 

There is a Routings Explorer report that contains all of the information that I need.  However, the top level part exists in the middle of the report and then you can see the breakdown of each operation in the Preview/Navigation window at the bottom of the screen.

 

I have tried to add the columns that are in the navigation preview to the middle of the report (which can be exported) but they aren't there.

 

Does anyone know how I can capture this data so that it can be exported?

 

Thanks!

-eric-

 

 

 

 

 

  • I am not at all familiar with any BOM/Routing modules so I may be way off base in understanding what you are looking for but assuming I do understand your question properly, here goes..

     

    By 'middle of the report', you are referring to the main grid output of the Explorer, correct?  The relationship between the 'middle of the report' output and the 'Preview/Navigation window' output is typically a 1 to many relationship so trying to pull a piece of that data directly into the 'middle of the report' will break that report by misrepresenting the data (i.e. what was once a PO explorer that showed 1 line for each PO will now show multiple lines for that PO depending on how many PO Lines there are in the 'Preview/Navigation window'.  Instead, depending on what the data is that you are trying to pull back, you would need to utilize logic that aggregates the 'Preview/Navigation window' data in some manner (i.e. utilizing Count, Sum, Max, etc against the data in the 'Preview/Navigation window' data as a manner to display in the main grid some aggregated representation of the data).  There would be no means to accomplish this through the front end and instead you would need to modify the DB View that is the source of the 'midle of the report' Explorer.

     

    Not all data or business needs can be represented as such in a reasonable manner so it is dependent on exactly what you are trying to accomplish.

     

    Hope that helps

  • in reply to DGill

    DOES ANYONE KNOW WHY MY INFORMATION WILL NOT PULL THROUGH ON THE EXPLORE MODULE.  

  • in reply to DebbieW

    Eric,

    Are you using the Routing Steps preview to get the information you need? Like DGill said, you probably won't be able to move these columns up because of the one to many relationship.

    However, you can right-click on any of the lines in the bottom window and choose Explore Routing Steps which will bring the Routing Steps from the bottom up to the middle of the screen. Then, when you click the Edit Columns button, you will be choosing from columns that exist for Routing Steps.

    Also, if Routing Steps isn't there already, it's easy to add to the main menu so you don't have to do the right-click trick every time.