开发者

Access crosstab formula field in another crosstab column?

开发者 https://www.devze.com 2023-02-01 01:50 出处:网络
How to access crosstab formula field in another column? I have report like with Dues & total both formula fields:

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?


  1. Just use {@FormulaName} (See image below)

  2. 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.

Access crosstab formula field in another crosstab column?

0

精彩评论

暂无评论...
验证码 换一张
取 消