Access crosstab formula field in another crosstab column?
How to access crosstab formula field in another column? I have report like with Dues & total both formula fields:
Amount Dues(Done by a Formula) 开发者_JAVA百科 Total (Done by a Formula)
------ ------------------------- ---------------------------
500 20 % someAmount
Formula for Dues:
WhileReadingRecords;
numberVar due:={Command.SomeField)/100;
due
Formula for Total:
WhileReadingRecords;
numberVar total:= {Command.Amount} - due;
total
How do I access due field inside the second formula for each row of record?
Just use
{@FormulaName}
(See image below)Crystal syntax is very simple for simple formulas. For your sample formulas, you don't need to declare variables or use WhileReadingRecords. (Both have their uses, but for your sample formulas, they are unneeded). Again, see the image below for an example.
精彩评论