on 02-24-2012 11:25 PM
Hello Experts,
Can anyone help me with this FMS? I get Internal Error when i click on the formatted search but when i run this in SQL syntax it executes successfully.
SELECT 'Batch'=
CASE When $[$3.U_SES_TrnsTyp.0]='Receipt'
Then
(RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
+$[$3.U_SES_Code.0]+$[$3.U_SES_Lseq.0]+'('+$[$3.U_SES_Crg.0]+')')
When $[$3.U_SES_TrnsTyp.0]='Production'
RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
Else ''
End
Hi,
Are you calling a UDF from Header to Row? or Your creating a UDF from a Header then calling the field in the row,
this may create an internal error.
Thanks.
CLint
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is it ok if you just put only this part in FMS:
RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
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 |
---|---|
103 | |
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.