AnsweredAssumed Answered

Showing a summary field from a related table.

Question asked by gobbles on Jun 11, 2012
Latest reply on Jun 21, 2012 by thirdsun

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?

Outcomes