VSB -Drived linking report

Post Reply
toqeer
Posts: 6
Joined: Wed Mar 17, 2010 10:07 am
Contact:

VSB -Drived linking report

Post by toqeer » Sun May 29, 2011 12:53 pm

Report - Derived linking
Hi,
I need help on the derived link connection of two tables Vspec & headerlog.
My report details are as follow :
Tables:
Tables !id Module Company Name Description
1 VS ** vspec Vehicle specification
!id Module Company Name Description
1 VS ** vspec Vehicle specification
2 VS ** usdst Used vehicle stock
3 SO 03 loghd Header log (0-derived link - path 3)

Derived details :
Name = ...
VSB$ str( !3_VSBNO,6,5)
VSBN 'rg_conv_a2n( !0_VSB$)
!3_WIPNO = !1_ORDERNO : !3_MAGICLH = 0
'rg_build(rg_handle(3),3,sym(rg_record3$())):'rg_fstart(rg_handle(3),ki_key$,3)
while true do
'rg_read_next(rg_handle(3),3,sym(rg_record3$()))
IF KI_STATUS <> 0 OR !3_WIPNO <> !1_ORDERNO THEN break
IF !3_AKDOCREF(1) <> !1_SOAKREF then continue
REG$ !3_REGNO
wend

As I am retrieving details from Headerlog table, report process takes time for output . Would appreciate feedback.

Thanks

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest