Passing a total between groups in crystal reports -

group 1 = date of order

group 2 = product , current on hand

day1

20140423   (day 1)    product                   200     order 1                     -20 order 2                     -20 balance                     160  product b                   100 order 1                     - 5 

day 2

20140424  (day 2) product c                    16 order 1                     - 5 

day 3

20140425  (day 3) product                   160   

how pass ending balance product day 1 beginning balance product day 3

pls explain in detail because novice report writer.

try below approach: create formula @storevalue , write below code.

    local numbervar storevalue;     local numbervar display;      if ({date},{@group1})=20140423 , ({product},{@group2})=product a'     storevalue:=//balance value of a;      if ({date},{@group1})=20140425 , ({product},{@group2})=product a'         display:=storevalue;     else      display:=//your calculation here;     display; 

now place value in balance row.