Report writing: 2 group headers keep appearing

AhMoi

Hi there!

got a problem with my report.

I have got records from General Journal Line Table. I would like to present them like this:

Group header 1(by acc no)
[followed by records with acc type = bank account]

Group header 2(by bal acc no)
[followed by records with bal. acc type = bank account]


currently, these records are sorted by acc no, bal acc no. in DataItemTableView.

Now, although I have used the "TOTALCAUSEDBY" code in the group header, both group headers appear for each record.

What have I done wrong? has it got anthing to do with my sort order?
help!

StephenG

Hi Ah Moi

Have you tried Putting code similar to this on the OnPreSection triggers of GroupHeader and GroupFooter sections.

CurrReport.SHOWOUTPUT :=
  CurrReport.TOTALSCAUSEDBY = "Customer Complaint".FIELDNO("Account No.");