In field.......... [Field : TotalAmount] Use : Amount field IsSqFt1blank1 : $$IsEmpty:$SqFeet1 Then $$AsAmount:1 Else $$Value IsSqFt1blank2: $$IsEmpty:$SqFeet2 Then $$AsAmount:1 Else $$Value Set As : {Qty * @IsSqFt1blank1 * IsSqFt1blank2 * Rate}
Sir its showing result = 1 (Total Amount not calculate) My field are given below..... [Field : JAP Desc] ; User define qty field Use : Number Field Set As : $$Value ;#VCHBilledQty Storage : JAPDesc [Field : SQFT1] ; User define SQFT1 field Use : Number Field Set As : $$Value Storage : SQFT1 [Field : SQFT2] ; User define SQFT1 field Use : Number Field Set As : $$Value Storage : SQFT1 [Field : JAP Desc1] ;;User define Rate field Use : Number Field Set As : $$Table:EIDesc:$SalMobNum ;;$Rate Storage : JAPDesc1 [Field : JAP Desc2] ; User define amount field Use : Number Field IsSqFt1blank1 : $$IsEmpty:$SqFeet1 Then $$AsNumber:1 Else $$Value IsSqFt1blank2: $$IsEmpty:$SqFeet2 Then $$AsNumber:1 Else $$Value Set As : {JAPDesc * @IsSqFt1blank1 * IsSqFt1blank2 * JAPDesc1} Storage : JAPDesc2
You are suppose to replace the name in my example with your storage names.......... e.g. $$IsEmpty:$SqFeet1 Then $$AsNumber:1 Else $$Value With THIS $$IsEmpty:$SqFt1 Then $$Number:1 Else $$Value Plus there is no such thing as "$$AsNumber". It is $$Number or $$AsAmount. Read properly and then implement.
I think by now u are sufficiently blooded in TDL program and I do not expect you to make such silly mistakes........... Keep your focus up and straight and concentrate well.
sir can u tell me how to break the line in report....... Local:Field:KA Item Description:Info:$UserDescription +" " + $$String:$SQFT1 +$$String:$SQFT1 + "QTY - "+$$String:$JapDesc+" @" +$$String:$JapDesc1+" = "+$$String:$JapDesc2+"/-" i want to bold line always in 2nd line
use $$Newline ....where you want to break the report into second line. You cannot have multi-format for a single field .... which might be broken into single, double or triple lines. This is not EXCEL or WORD. For that you will have to add another LINE (2nd line) or FIELD (next field) ....