AdamReed_1

print sub-summary report based on related record

Discussion created by AdamReed_1 on Jan 27, 2017
Latest reply on Mar 11, 2017 by AdamReed_1

Hello,

 

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:

 

William Faulkner

- 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.


Adam

Outcomes