Crosstab Report

PHPMaker General Discussion (PHPMaker)
1

Please i will be glad if someone will help me. Thank in advance.
i have two table named: tblbiodata and tbldeposit.
the tblebiodata fields are sn, emplyNo, fname, Sname, age, town
the tbldeposit fields are sn, emplyNo, datedeposit, Amountdeposit, receivedby

Please i want a crosstab report that will appear in this form

Emplyno, Fname, Sname,
datedeposit Amountdeposit, receivedby

  1. 12/02/2018 180 Kofi
  2. 15/08/2010 170 yaw
  3. 17/09/2019 150 Ama
    Total: 500

Please any help will be much appreciated.

2

Are you sure that it is a Crosstab report, it looks like a summary report. To get data from other table, you may create a view first, see the topic “Preparing Data for Reports” in the help file.