Tuesday, March 18, 2008

Select Case in CR.NET Crystal Reports

Numbervar numUnAllocatedAmount;

select {vwRptClaimPrint.ClaimStatus}

case 'PartAllocated':(numUnAllocatedAmount:={vwRptClaimPrint.TotalVouchedClaimAmount}- {vwRptClaimPrint.TotalAllocatedClaimAmount})

default: (numUnAllocatedAmount:= {vwRptClaimPrint.TotalVouchedClaimAmount} -{vwRptClaimPrint.TotalAllocatedClaimAmount})

No comments: