How to add rows at runtime

Question

using crystal report 7

ID Value total

001 100 2000
002 300 1000
003 300 1000
......

i want to add one more additional row at runtime after 2nd row (1st + 2nd row).

Expected Ouput

ID Value total subtotal

001 100 2000 (a)
002 300 1000 (b)
123 400 3000 (total of a & b)
003 300 1000 (c)
......

How to do it in crystal report.

Can any one give me a idea or formula help

Answer 1

• Create a new formula field: if recordnumber in [1,2] then 1 else 2;
• Create a group using this formula
• Suppress the group header
• Conditionally suppress the group footer using formula recordnumber > 2
• Add your total fields to the group footer