I'm trying to create a report with the GetSummary functions.

I figured out that this function can't use related records. To bypass this I tried to run a script which copies the related records into the table where the report is created.

The problem is that this script doesn't work. (see the attachment)

Does somebody have an idea to get the script working or another solution to use the GetSummary function with related records.

Thanks

Question.fp7.zip

You can define a calculation field = Related::Field and use it instead of the related field. Or, if the sorting is acceptable, simply use the foreign key field.

Could you explain to me what I'm doing wrong in the script.

I tried the calc fields they work well.

I`d like to know though why the search step in the script doesn't work.

Could you explain to me what I'm doing wrong in the script.

Just about everything, I'm afraid. Specifically, the find couldn't work because you cannot enter a variable into a stored request. In any case, duplicating the related content is not a good idea - it goes against the very concept of a relational database.