Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
extender
- Thread starter TheKnee
- Start date
create a calculated field using thr RW_TableHeaderString function. The calculated field should be a string and the expression should look something like this:
FUNCTION_SCRIPT (rw_TableHeaderString 3107 "window name" SOP Number 0 1)
Note:
window name - extender window name
SOP Number - key taken from the SOP_HDR_Work file
0 - filler; used instead of SOP Number if key was numeric.
1 - the field number on the extender window.
drag calculated field unto report.
FUNCTION_SCRIPT (rw_TableHeaderString 3107 "window name" SOP Number 0 1)
Note:
window name - extender window name
SOP Number - key taken from the SOP_HDR_Work file
0 - filler; used instead of SOP Number if key was numeric.
1 - the field number on the extender window.
drag calculated field unto report.
- Thread starter
- #3
There is something i don't understand
In the sop long order form, i whant do add a feild after the item number on eache line off the order the one will be linked to itemnumber as well
my extenter form name is location, i need to print feild #1
In the sop long order form, i whant do add a feild after the item number on eache line off the order the one will be linked to itemnumber as well
my extenter form name is location, i need to print feild #1
Is your extender window on the Sales Line Items then you have a concatenated key. Do another calculated field to concatenate the key fields and use this new calculated field as the key in script.
Steps to concatenate Field:
1) Name field and set the Result Type to String.
2) Functions tab --> System --> Function: LNG_STR
3) Add function string .
4) Fields tab --> Select table and key field #1.
5) Add field.
6) Operators: CAT
7) Functions tab --> System --> STRIP
8) Add function string.
9) Fields tab --> Select table and key field #2.
10) Add field
The final result should look something like this:
LNG_STR(SOP_Line_Work.Item Number) # STRIP (SOP_LINE_Work.SOP Number)
Steps for rw_TableHeaderString:
1). Name the calculated field and set the Result Type to string.
2) unctions tab --> User Defined --> Core: System --> Function: rw_TableHeaderString.
3. Add the function.
4) Constants tab --> Type: Integer --> Constant: 3107
5) Add the constant.
6) Constants tab --> Type: String --> Constant: location
7) Fields --> Calculated --> soplinekey
8) Add the key field.
9) Constants tab --> Type: Integer --> Constant: 0
10) Constants tab --> Type: Integer --> Constant: 1
Final result in my previous response.
Steps to concatenate Field:
1) Name field and set the Result Type to String.
2) Functions tab --> System --> Function: LNG_STR
3) Add function string .
4) Fields tab --> Select table and key field #1.
5) Add field.
6) Operators: CAT
7) Functions tab --> System --> STRIP
8) Add function string.
9) Fields tab --> Select table and key field #2.
10) Add field
The final result should look something like this:
LNG_STR(SOP_Line_Work.Item Number) # STRIP (SOP_LINE_Work.SOP Number)
Steps for rw_TableHeaderString:
1). Name the calculated field and set the Result Type to string.
2) unctions tab --> User Defined --> Core: System --> Function: rw_TableHeaderString.
3. Add the function.
4) Constants tab --> Type: Integer --> Constant: 3107
5) Add the constant.
6) Constants tab --> Type: String --> Constant: location
7) Fields --> Calculated --> soplinekey
8) Add the key field.
9) Constants tab --> Type: Integer --> Constant: 0
10) Constants tab --> Type: Integer --> Constant: 1
Final result in my previous response.
- Status
Similar threads
