Hi,

I just started using Stonefield Reports. I have changed my SYS(3055) setting to the max (2040?) and I'm still getting the 'Too many subqueries' error.

I have something like the following:

Court Cases (Case Number) related to:
Defendants related to:
People (Name)
Arrest Warrants (Date Issued, Date Arrested)

All primary keys are integer.

When I do a report on names in People Date Issued and filter on EMPTY Date Arrested all works fine. WHen I add the Case Number it blows up w/the 'Too many subqueries' error. It doesn't seem THAT involved to me!

Input is appreciated. J