Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Reports: columnar listing


geod

This topic is 8843 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

  • Newbies

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.