Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #664

visible only with a value; sorted

Show all headers | View raw

On a fmp 6.04. win7
I have a semester report that lists the the various courses we work with and how many students they have.
Right now the report is static in that (fer example) there are 10 courses for the humanities, 18 for social sciences, and then a bunch of other courses.
But some semesters, we only worked with 8 humanities, or with a new humanities than the previous semester. Or like we haven't worked with Physics for 7 years.
I put a total # value for each course that we worked with this semester, so all the various anthropology courses get totalled in the "Anthropology" field. If we add a new course group, like Chemistry, I would make a new field and add that to the layout, maybe bumping a course we haven't worked with in awhile.

I would like to automate the layout part.

I was wondering if there is a way to make a report that only lists the courses that have a value in it. The rest would not show up.
I suppose something like a sub-summary comes to play, but I don't know how it would work.

Also, since this report would also show totals throughout the years, my hope is that there would be different lists down each column.
-- 
"... respect, all good works are not done by only good folk. For here, at the end of all things, we shall do what needs to be done."
   --till next time, consul -x- <<poetry.dolphins-cove.com>>

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar

Thread

visible only with a value; sorted ~consul <consul@dolphinsTAKEAWAY-cove.com> - 2012-03-02 11:18 -0800
  Re: visible only with a value; sorted HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-03 12:34 +1300

csiph-web