on 06-14-2011 12:04 AM
Dear All,
I add a hyperlink to my orange arrow like below
'http://$b1$/link?table=JDT1&key=' + {Command.TransID}
'http://$b1$/link?table=OJDT&key=' + {Command.TransID}
Neither of them works.
Here is my user query:
Select T4.CompnyName 'CompName'
, T1.[FormatCode] 'FormatCode'
, T1.[AcctName] 'AcctName'
, Case When T0.ContraAct Not like '_SYS%' Then T0.ContraAct
Else '' End 'BPCode'
, T6.CardName 'BPName'
, T0.[ExtrMatch] 'ExtrMatch'
, T5.[MatchDate] 'MatchDate'
,T0.[TransId] 'TransID'
,T0.[RefDate] 'PostingDate'
,'X' 'Clr'
, Case T0.[TransType]
When -2 Then 'OB'
When -4 Then 'BN'
When 13 Then 'AR IN'
When 14 Then 'AR Credit'
When 18 Then 'AP IN'
When 19 Then 'AP Credit'
When 24 Then 'Incoming PMT'
When 25 Then 'Deposit (C)'
When 30 Then 'JE'
When 46 Then 'Outgoing PMT'
When 57 Then 'Check'
Else ''
End 'Type'
, Case When T0.[Ref3Line] = '' Then T0.[BaseRef]
Else Case T0.[TransType] When 30 Then Convert(Varchar, T0.[TransId])
Else T0.[BaseRef] ' -> ' T0.[Ref3Line]
End
End 'BaseRef'
, T0.[Credit] 'Credit'
FROM JDT1 T0
INNER JOIN OACT T1 ON T0.Account = T1.AcctCode
Left Outer Join ORCT T2 On T0.[TransId] = T2.[TransId] And T0.[TransType] = 24
Left Outer JOIN RCT1 T3 ON T2.DocEntry = T3.DocNum
Left Outer Join OMTH T5 ON T5.[MatchNum] = T0.[ExtrMatch] AND T5.MthAcctCod = T1.Acctcode
Left Outer Join OCRD T6 ON T0.ContraAct = T6.CardCode
, OADM T4
WHERE T0.Credit >0
Thanks in advance.
Regards,
Yuka
Dear Yuka,
Convert(Varchar, T0.TransId) can never have the arrow you want. Add a field without convert to try.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.