Relation in repeat region

[gabrielferaru]

I want to create a relation withthis report parameter: &asm.mbr.connprm.conn_pn.In relation, the dots "." must be replacedby underscores "_" .But, my parametercontains a word which has an underscore in it, and becauseof thisI receive an error. Doesanybody knowhow to solve this error?
Edited by: gabrielferaru

 

[kdem]

Can you give the contents of the parameter and the relation you are trying to write? I'm not so sure the underscore is the problem.

 

[gabrielferaru]

Yes. Igot it. Wasn't the underscore. The report parameter mustbe predefined in "Local Parameters" window.


Ok. Now I want to create a BOM with many kinds of electrical components: connectors, wires, bundles, terminals etc. As a report parameter, on main columnin table, I put &rpt.rel.PART_NUMBER where PART_NUMBER must be harn_spool_name, asm_mbr_connprm_pin_term_name or asm_mbr_connprm_conn_pn. Can anybody help me with relation syntax? I'm a very stupid programmer.






Edited by: gabrielferaru

 

[rcamp]

What condition determines which value it gets? Do you want to set it to whichever one has a value? What if more than one have a value?


This sets PART_NUMBER to the first one that has a value:


IF harn_spool_name <> ""


PART_NUMBER = harn_spool_name


ELSEIF


asm_mbr_connprm_pin_term_name <> ""


PART_NUMBER = asm_mbr_connprm_pin_term_name


ELSEIF


asm_mbr_connprm_conn_pn <> ""


PART_NUMBER = asm_mbr_connprm_conn_pn


ENDIF


ENDIF


ENDIF

 

[gabrielferaru]

Thanks rchamp.


The relation works with some little changes from me, but I want valuesin BOM (if they exist in asm)also for 2nd and 3rd reported parameter, no matter what,not only for first one.


Could you explain the meaning of <> "" ?


Thanks in advance... once again.

Edited by: gabrielferaru

 

[rcamp]

Means: Is not null (blank or empty). In other words if it has a value.


If you want all 3 values you'll probably have to use 3 parameters in 3 columns. Or concatenate (combine) them all into one.

 

[gabrielferaru]

I tried to make 3 repeat regions for each parameter but I didn't find a solution to have a common index for all.
I tried to put all reported parameters in the same cell, it dont't works.
I don't know if it's possible to combine like you said.
3 columns... no... because of my company's standards.

Anyway, thanks for your help.

 

[gabrielferaru]

I put in the region the folowing relation (see results in picture):


IF exists("harn_spool_name")
PART_NUMBER = harn_spool_name
REL_QTY = harn_spool_len
DESCRIPTION = harn_spool_type
ELSE
IF exists("asm_mbr_connprm_conn_pn")
PART_NUMBER = asm_mbr_connprm_conn_pn
REL_QTY = rpt_qty
DESCRIPTION = asm_mbr_connprm_family +" "+ asm_mbr_connprm_type
ENDIF
ENDIF


It works fine, but I need more parameters to add to have a complete BOM, andif I try add on relationanother items like asm_mbr_connprm_pin_term_name, the cells become empty...

 

[cristelino]

Gabriel


Maybe you don"t have any/some parametres define in your model.


When you have some empty cell is because of that.


BTW why you don"t use user defined paerameters:&asm.mbr.type??


Corect me if i"m wrong


Also a recommend other types of method to show hide information in tabels and repeat regions


I have some examples since i worked in Romania

Edited by: cristelino

 

[gabrielferaru]

Great idea cristelino!!! Thank you very much!

This is almost the final version of relation. On table regions attributes I checked "Cable Info" option to show the terminals of connectors.

IF exists("harn_spool_name")
PART_NUMBER = harn_spool_name
REL_QTY = harn_spool_len
DESCRIPTION = harn_spool_type
ELSE
IF asm_mbr_type == "PART"
PART_NUMBER = asm_mbr_connprm_conn_pn
REL_QTY = rpt_qty
DESCRIPTION = asm_mbr_connprm_family +" "+ asm_mbr_connprm_type
ELSE
PART_NUMBER = asm_mbr_name
REL_QTY = rpt_qty
DESCRIPTION = "CONTACT TERMINAL"
ENDIF
ENDIF



Edited by: gabrielferaru

 

[cristelino]

Gabriel

Also if you have a problem with comercial de departaments next step is very useful.

Did you use Info/Bills of materials option?Of course if you have PROE Wildfire installed


Cristelino

 

[gabrielferaru]

Thanks for this trick.


I'm working with internal parameters of connectorsor terminals on Pro/Cabling module. It works a little bit different then mechanical assemblies.


Now I have another issue.


I dont' understant or I don't know how to create a relation to show, on the same column, in different cells andonly one&rpt.index, two parameters from the same level of one connector: &asm.mbr.connprm.COVER and &asm.mbr.connprm.CONN_PN






Edited by: gabrielferaru