2 or more fields suppressrepeated and total same row

Comments

• gordk St.Catherines On. Canada.

  November 2013 edited 8:22AM

  which method are you using to get the totals currently?
• jubrovolski

  November 2013 edited November 2013

  Hi
  
  Today I don't use this report. It's not exist. My manager would like the report this way.
  
  This sample is in Excel.
• gordk St.Catherines On. Canada.

  November 2013 edited 8:22AM

  declare a typed variable at the start of the report code page.
  in the obp event of the band write code to add the fields
  ie myvarname:=0;
  myvar:= <datasetname."fieldname1"> +<datasetname."fieldname2"> and so on
  use the variable in the memo to display the total
  in the memos you want to hide set supress repeated values to true.
  
• jubrovolski

  November 2013 edited 8:22AM

  I need supress the hours only when the date is the same.
  If I mark all memos to suppress, when you change the date and time is the same time it suppresses again.
• gordk St.Catherines On. Canada.

  November 2013 edited 8:22AM

  so add another variable to store the previous date
  and on the next record check the datafield against the stored date and set the visible properties of the
  memos you want to hide.