How to integrate Group Summary Totals?
Posted: Tue Dec 16, 2025 10:29 pm
I have a report with 3 linked data bands. So far so good. But I'm unable to get the summary totals to work. In simple terms the three linked tables are Plans (one record) - Options - Categories. This works. See below.
I've created a hard-coded report that shows the summary vales. that works, but it's a hard-coded example. See below.
This is the hard-coded query:
I need the summary values to show in the report based upon the link to the options DataBand.
Here is what the report looks like in the builder:
So how do I put this together ?
I've created a hard-coded report that shows the summary vales. that works, but it's a hard-coded example. See below.
This is the hard-coded query:
Code: Select all
SELECT
lcp_categories.Lcp_Cat_Desc,
lcp_categories.LCP_Cat_Id,
lcp_categories.Lcp_Cat_Id_Original,
lcp_categories.Lcp_Opt_Id_VarChar,
lcp_categories.LCP_Opt_Id,
lcp_categories.Created,
lcp_categories.Udated,
SUM(lcp_items.Total_Cost) AS Items_Total
FROM
lcp_categories
INNER JOIN
lcp_items ON lcp_items.LCP_Cat_Id = lcp_categories.LCP_Cat_Id
WHERE
lcp_categories.LCP_Opt_Id = 2491
GROUP BY
lcp_categories.`Lcp_Cat_Desc`
ORDER BY
Lcp_Cat_Desc
Here is what the report looks like in the builder:
So how do I put this together ?
