Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Calculated fields in recordset?

Calculated fields in recordset?

Thread began 6/29/2012 2:41 am by gary.brett434358 | Last modified 7/05/2012 9:38 am by gary.brett434358 | 6953 views | 15 replies

6/29/2012 6:59 amgary.brett434358

Hi Jason thanks for your input, the filtering is not done in mysql but via master/detail links, using code below works on master recordset but not on detail pages as its simply display the total recordset sums.

Select
  tblcontacts.ContactFullName As Name,
  Count(tblcases.CaseID)As Cases,
  Sum(tblcases.CaseCommission) As Commission
From
  tblcontacts Inner Join
  tblcases On tblcontacts.ContactID =
  tblcases.ContactAssignedTo
Group By
  tblcontacts.ContactFullName
  
  UNION ALL

Select
  'GRAND-TOTAL',
  Count(tblcases.CaseID),
  Sum(tblcases.CaseCommission)
From
  tblcontacts Inner Join
  tblcases On tblcontacts.ContactID =
    tblcases.ContactAssignedTo

Not sure how I would do this now, I had started to look at php methods but have no real idea if php can even do calcs?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.