Hi All
I try to modify my sales report to show tender typ on colmun
Begin Column FieldName = "Tendertotals.shift" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "cash" VBDataType = vbCurrency Formula = "case when tender.id ='2' then tendertotals.shift else '0' end" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodSum ColFormat = "" ColAlignment = flexAlignLeftTop End Column
Begin Column FieldName = "Tendertotals.shift" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "VISA CARD" VBDataType = vbCurrency Formula = "case when tender.id ='3' then tendertotals.shift else '0' end" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodSum ColFormat = "" ColAlignment = flexAlignLeftTop End Column
BUT it's give me follow erorr
Implicit conversion from data type vachar to mony is not allowed, Use convert fonction to run this query.
Can any one help me on this please?
Best Regards MOH.OWN
begin 666 CUSTOM - TENDER.qrp M+R\M+2T@4F5P;W)T(%-U;6UA