Grouping report without details?

Comments

• gordk St.Catherines On. Canada.

  June 2004 edited 12:11AM

  turn mdb visible property to false
  use extended syntax of sum funtion in memos in footers and summary band
  [sum([tablename."Fieldname"],bandname,1)]
  bandname is bandname of mdband as shown in frs object inspector.
  the ,1 param allows summing non visible values.
  of course you could always look at the main reports demo to see how it is done.
  regards
• paren

  May 2006 edited May 2006

  I??m doing that, but when I do the operations in memo on MasterData and i set property visible to false in the band, throws an "Invalid variant type conversion"
  
  memo have text like this

    if [DialogForm.qryAcumPendXPay."STATUS"] = '1'
    then
      if [DialogForm.qryAcumPendXPay."DUEDATE"] <= [vFrNowDate]
      then totalOutDated := [DialogForm.qryAcumPendXPay."TOTAL"]
      else totalOutDated := 0;
  

  
  I put the Group Header Band to group totals per Customer
  then put a MasterData Band
  then i put a Group Footer Band to subtotals of each customer