Report Relations

[hwech]

I have a BOM generated from an assembly drawing. The assembly drawing is typical for one assembly. I want to add a colum to the report thatmultiplies paramater values for the one typical assembly by the quantity to be produced. I have a parameter "QUANTITY" that was created in the assembly model that I amable to show in the drawing notes. I want that same parameter to be used to generate the report totals. I have tried several iterations in the report relations, but cannot seem to get it right.


My report relations as they are now (and work)


if asm_mbr_length==0
total_length="-"
ELSE
total_length=RPT_QTY*asm_mbr_length/12
ENDIF


total_weight=RPT_QTY*asm_mbr_weight


I want to mulptiply total_length and total_weight x QUANTITY.
I don't want to create a parameter within the report region that requires input.
The QUANTITY parameter is input external to the region.


Any suggestions?


Thanks Harry

 

[vlad1979]

I'm up for a new challenge. Don't know why I started to like relation lately, I used to hate them...


So why don't you make a new relations in the repeat region table like:


x=total_length*total_weight*quantity


(this is what you need? or maybe I don't understand, correct me)


then put a new column in the repeat region and write in the cell &rpt.rel.x
Edited by: vlad1979

 

[hwech]

Thanks Vlad.


What I want to do is


total_length=RPT_QTY*asm_mbr_length/12*QUANTITY
AND
total_weight=RPT_QTY*asm_mbr_weight*QUANTITY


But QUANTITY is not a report parameter, it is an assembly parameter.
I have tried asm_mbr_QUANTITY and several others to no avail.


I can create a column and enter asm.mbr.QUANTITY and it the region fills in,
but I can't seem to get it into my relations.


Harry

 

[vlad1979]

there are 2 solution to the problem:


1. if you don't have quantity shown in BOM as a sepparate column then you can't use it in relations.


What you must do in this case is add it to your repeat region relations.


Openthe repeat region relations and add the parameter:


View attachment 3819


add it as shown below, as integer and leave the value field 0 like pro-e put it


View attachment 3820


then you can add it to your relations as:


total_length=RPT_QTY*asm_mbr_length/12*asm_mbr_quantity
AND
total_weight=RPT_QTY*asm_mbr_weight*asm_mbr_quantity


2. or you can add a column to your repeat region table with quantity, this way you don't have to add the parameter to the relations.


Both methods work, the only difference is that for one you don't have the column quantity and for the other you have the column.