January 24, 200322 yr Newbies Hello to all, I tryed everything I know but cannot solve this problem: I'm making a report where I want to sort by school name then display the teacher name and for each teacher a list of students. The report look like this Header school name adress and an introductory text subsummary by school ID (empty only for sort purposes) subsummary by date to come (empty like above) subsummary by teacher (name of the teacher and the date) John Smith Date to come xx-xx-xxxx body with the list of the students that belong to a particular teacher. student 1 student 2 . . . student n So far it work perfectly and the sort order is school ID, date, teacher, and student name.There is a break for each different school and the different teachers (and students) are consecutive. However when the body of a particular teacher is too long (too many students) it goes to next page and keep printing the list. The question is: there is a way to repeat the subheader of the teacher on the next page so don't look so weird (like something is missing)? Thanks in advance for any help I can receive Best regards Nem30151
April 4, 200322 yr I have a similar issue with jobs that have sub components where a job may have 1 or 50 components so they sometime fit on a page and sometime not. I am using sub summaries to show the job number and name before the components and have been requested to have the job name repeat at the top of the next page if the group of job components breaks across a page. The problem is often a new job starts at the top of the page so you get the job name information twice once in the header and once in the sub summary. Any ideas on how to do this? Daniel
April 4, 200322 yr One of the things you can do is keep a running count of records within each subsummary part. If the count is 1, that means you are at the first record, and you don't want the information to be printed in the header. So, You make the information in the header a calculated field with a formula like: Case(ItemNumber=1,"",BreakField & " ....cont") I attached a sample file that shows how to do it. MultiPage.fp5.zip
April 6, 200322 yr Found my answer at http://filemakeradvisor.com/Article/11328 Actually had read the article last month but just forgot about it. Daniel
Create an account or sign in to comment