Monday, April 27, 2009

TDL for adding address column in columnar report:


[#Line: DSP ColVchDetail]
Add : Fields: Before: DBC VchNo : DBC Address1, DBC Address2, DBC Address3, DBC Address4, DBC Address5

[Field: DBC Address1]

Use : Name Field
Set as : $$FullList:Address:$_Address1:Ledger:@@FilterPartyName
Style : Normal
Align : Left
Scroll : Yes
Border : Thin Left
Invisible : NOT ##COLREGWithAddress

[Field: DBC Address2]

Use : Name Field
Set as : $$FullList:Address:$_Address2:Ledger:@@FilterPartyName
Style : Normal
Align : Left
Scroll : Yes
Border : Thin Left
Invisible : NOT ##COLREGWithAddress

[Field: DBC Address3]

Use : Name Field
Set as : $$FullList:Address:$_Address3:Ledger:@@FilterPartyName
Style : Normal
Align : Left
Scroll : Yes
Border : Thin Left
Invisible : NOT ##COLREGWithAddress

[Field: DBC Address4]

Use : Name Field
Set as : $$FullList:Address:$_Address4:Ledger:@@FilterPartyName
Style : Normal
Align : Left
Scroll : Yes
Border : Thin Left
Invisible : NOT ##COLREGWithAddress

[Field: DBC Address5]

Use : Name Field
Set as : $$FullList:Address:$_Address5:Ledger:@@FilterPartyName
Style : Normal
Align : Left
Scroll : Yes
Border : Thin Left
Invisible : NOT ##COLREGWithAddress

;;--------- Title-----------

[#Line: DSP ColVchTitle]
Local : Field : DBC Address1 : Set as : $$LocaleString:"Address1"
Local : Field : DBC Address2 : Set as : $$LocaleString:"Address2"
Local : Field : DBC Address3 : Set as : $$LocaleString:"Address3"
Local : Field : DBC Address4 : Set as : $$LocaleString:"Address4"
Local : Field : DBC Address5 : Set as : $$LocaleString:"Address5"

;;--------- Switch----------

[#Part: CMP COLBasics]
Add : Lines : At Beginning : COLREGWithAddress

[Line: COLREGWithAddress]

Fields : Medium Prompt, COLREGWithAddress
Local : Field : Medium Prompt : Info : $$LocaleString:"Show Party Address ?"

[Field: COLREGWithAddress]

Use : Logical Field
Modifies: COLREGWithAddress

[System: Variables]

COLREGWithAddress : No

[Variable: COLREGWithAddress]

Type : Logical
Persistent : Yes


1 comment:

  1. Very good ,good tdl you solve forced date problem ..see my other blog http://pearl-utility.blogspot.com

    ReplyDelete