Reports that include both variable and standard data

[SP Myers]

I'm working on creating a script for a mailing list report. The mailing list is for all the people the publishing company I work for sends advance copies of books to.

Basically it has two levels:

The first is for the standard group we send advance copies to: our archive, library of congress, etc. This consists of a check box, number of copies, and shipping date.

The second is for book specific individuals, such as the author, the editor, reviewers, and so on. This consists of portal rows with needed information.

Here is what the section looks like:

Advance Copy Book Database Tab

The issue arises when I try to create a report that will list out the mailing information. For the Portal data I use:

Go to Related Records [show only related records; From table:"Advance Copy"; Using Layout: "Mailing List"]

This gives me the related portal information I need for a selected title.

To get the standard information I tried using:

If[tablename::fieldname="Yes"]

//Aka the check boxes

ExtendFoundSet [Restore]

//The data for this is based off a hidden field with a record specific number

End If

I added this for each one, but when I run the script, it will only work for the first checked box and not the others.

Any help/insight would be highly appreciated.

Edited July 22, 2009 by Guest

[Fitch]

Seems like it would be easier to manage if you did it all in the portal. E.g. make your "standard" recipients into buttons that pass a parameter (Archive, English Chair, etc.) into a script; the script would then create a new related record with the corresponding info filled in.

Not only does this simplify the mailing list/reporting process, it means you can get rid of all those extra fields in the parent (book) record.