geod Posted July 22, 2000 Share Posted July 22, 2000 The key is to design your report with the appropiate Sub-summary parts and then place summary fields for the totals in the right parts. But this will not work unless you have the data sorted in the same order that the parts are set up on your report. If I am understanding your setup: Your parts would be: Year Institution Type Institutions (being the body) The sort would be: Year Type Institution With these dang'd small reply boxes it is hard to follow your own logic. Again the key is the sort has to follow the order of your parts. Play around with it and you will succeed. Link to comment Share on other sites More sharing options...
Newbies mgrady Posted July 22, 2000 Newbies Share Posted July 22, 2000 I'm designing a database that stores co-op student placement statistics for numerous Canadian colleges and universities. For the columnar reports, institutions are grouped based on type, with each group sorted alphabetically. A typical report lists various statistical totals (columns) per institution (rows). I wish to set up a report that displays totals for different years, with each column representing a specific year. (Each record contains a "Year" field, but I can't figure out how to list *separate* totals in a report for different years.) Any advice would be greatly appreciated! [This message has been edited by mgrady (edited July 21, 2000).] Link to comment Share on other sites More sharing options...
ZuperZZ Posted July 22, 2000 Share Posted July 22, 2000 Mr mgrady, I understand that you want the years in columns, If you proceed as geod suggested the sub-summary will devide the years in rows. I foud a file that may help you, you can find it here: http://www.fmsearch.com/ , type "Excel-Like Matrix Report". Hope it help you! ZZ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8843 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now