I'm trying to print a number of sub-summary reports based on a related record, but am instead banging my head against the wall.
I have three tables: client, book, and contract, as well as client_book, and book_contract linking tables.
My aim is to show the contracts for each client based on a particular book. For example:
- THE SOUND AND THE FURY
- Random House, 1947
- French, 2012
- Italian, 2014
- AS I LAY DYING
- Random House, 1941
- Japan, 1985
- Turkey, 1989
I have a layout based on the contract table that works well -- to generate the report for a particular client I just do a find for that client ("client id" in the "client_book" link table) in a dropdown menu, have a sub-summary of "book id" and then sort based on a few criteria to keep things in order. Manually, it works fine.
I would like to automatically generate these reports for a number of clients, but have thus far been unable to figure out how to automate the find. What I would like is the script to start at this layout, find the first client, sort the sub-summary and save as a pdf, then move to the next, etc.
Thanks for any help.