Summarizing on Entry Screen

[dave000]

I manage a school database accessible to non-technical users. The database opens to an 'entry screen' with buttons for various activities. I would like the entry screen to display some basic information, such as current enrollment by classroom, etc. If I script a report to summarize the data using summary fields, I realize I need to display in Preview--but then the buttons don't function, and I don't get to use the full screen width, just page width. If I use GetSummary(), I can't figure out how to see subtotals for all of the classrooms--just the total for the classroom of the currently selected record.

Is there a way to do this?

Thanks!

[Ocean West]

Yes there is, may take a bit of work but what you can do is create a "dashboard" by creating a script that collects the necessary data by looping thru layouts and records and creates necessary records in another table for purposes of display. -

Or if you just want totals you could use the Sum() function on your dashboard and Sum the contents of the (filtered / unfiltered) portal, based on relationships.

You could have various portals for different at - a glance - data.

[Vaughan]

Just be aware that showing this summed data for all users on the entry screen is going to require a lot of data processing; and on the opening screen this can make the solution appear slow and unresponsive, especially if the record count gets large and the network is marginal.