I think I am just doing something silly, but I can't for the life o me figure out what I am doing wrong.
My databse has Two tables in a One to Many relationship. Client to Appointments
I have a report that shows a series of subsummary fields from the Appointments table. At the bottom of the page is a trailing Grand summary with some totals.
I have a total calculation from the Clients Table I would like to also appear on the same page. It continues to stubbornley show "0" when I generate the report. Is there something about trailing grand summaries that mean I can't have this total in there? How would I show summary fields from different tables ont he same page?