CODEWITHSUNDEEP
crystal-reports
JetJack
JetJack

Reputation: 988

How to add rows at runtime

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

Upvotes: 1

Views: 1799

Answers (1)

Lee Tickett
Lee Tickett

Reputation: 6027

  • 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

Upvotes: 1

Related Questions