Hi there,

I have a variety of tables each providing me a summary total for a year's found set of records.

I want to place all of these summary totals from different tables on one page so I can see all of my summaries for an individual year of records. But when I do this on a separate new layout, it doesn't give me my found set summary for the individual year as I would like but instead it give me the grand total for all the fields records combined from the table.

I thought since I cannot link the summary to a different page that maybe I needed to create a global field and have that = the summary field but even that still gives a grand total of all records as opposed to a total for a particular year's records.

 

I would have to think that this is possible but it doesn't seem to want to work. Any help much appreciated.

Thanks in advance,

The Missing Man

Based on what info you have given, seem to me like you can write a script that goes through each of your layouts, grab the summary total into a few global variables, and then display those variables on a "reporting" layout. You could also put them into global fields, but if it only going to be used for reporting, variables would be suffice.

OK, so global seems to be the answer, good to know I was on the right track but why do I keep getting the total in my global for all records as opposed to just my found set?

Are you referencing the right table occurrence? Perhaps at this point you may want to post a sample file.

Thanks for your help