The list doesn't allow attachments. Could you keep them on a xloud and link here?
What i see is that you should prepare a query where you already have 14 results (even null) in a single record. Il 26/giu/2015 18:06, "Ed Beroset" <bero...@mindspring.com> ha scritto: > I'm trying to print out schedules for students using mailmerge and have > encountered a problem that I haven't yet been able to solve. Here's what > I've done so far. > > I have created a simple embedded database (named "school") in base and I > have three tables named Classes, Students and Schedules. Classes has three > fields: ClassID (which is the index), ClassTitle and CreditHours. The > Students table has StudentID (the index), LastName and FirstName. The > Schedules table has PairID (the index) and StudentID and ClassID. > > Students and Classes are just what you'd expect. Each record in the > Schedules table links one student and one class. A schedule is the > collection of all classes for a particular student. I have created a > simple query for the Schedules table: > > SELECT "Schedules"."StudentID" "StudentID", "Students"."LastName" > "LastName", "Students"."FirstName" "FirstName", "Schedules"."ClassID" > "ClassID", "Classes"."ClassTitle" "ClassTitle", "Classes"."CreditHours" > "CreditHours" FROM "Schedules" "Schedules", "Students" "Students", > "Classes" "Classes" WHERE "Schedules"."StudentID" = "Students"."StudentID" > AND "Schedules"."ClassID" = "Classes"."ClassID" ORDER BY "StudentID", > "ClassID" > > All of that works just fine and I've also created a simple report that > uses the query, which also works as expected. > > Now what I want to do is to create a separate schedule document for each > student. I'm attempting to use mailmerge to do that. I have a simple .ott > file which has "Schedule for <FirstName> <LastName>" in the header and then > a table in the body of the document. It has a header and about 14 rows > (the maximum number of classes I expect) and then a final row which has a > formula which calculates the total number of credit hours. > > When I select and filter one individual student, the schedule prints just > fine, but if I try to generate all of them, it doesn't work as I want. > Specifically, it picks up the first student's name but then it populates > the table with the next 14 classes in the query, whether or not this > *particular* student is taking that class or not. Each page is filled with > 14 classes until we get to the end of the list. > > Each row of the table includes the three fields and then a "Next record" > which is probably where my problem lies. The condition is set to "TRUE". > Somewhat schematically, each line looks like: > > <school.Query_Schedules.ClassID> <school.Query_Schedules.ClassTitle> > <school.Query_Schedules.CreditHours> <Next record:school.Query_Schedules> > > Any clues would be most welcome. I'm quite new to LibreOffice and my SQL > skills are very rusty, but I'd love to learn more about both if it helps me > solve this problem! > > Also, attached is a small zip file with both the database and template if > you'd like to try. > > Thanks! > > Ed > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted