This question is for Kreports gurus. Often, i need to get a list of all objects not having a type of child relationship. Accounts without contacts is a good example. I notice under select you can set the required field to Notexisting if Operator is function, however it doesnt do the job.
To work around I set everything as optional, do a group by, count the child id and sort descending so the 0s are at the bottom but its not ideal.
Is there a proper way to do this type of queries?