Yes, there is one filter on the report.
Let me describe again.
I have two tables one is Client and another one is SOW Assignments.
one client has many SOW Assignment. I have created some SOW Assignment just for testing purpose (don't want to delete them).
So, I have created a custom report (excluded the test SOWs).
Now, I have created a form and set that custom report in the form element setting of SOW Assignments.
I have two fields one is Client and another one is SOW Assignments. SOW Assignment is a dependent field on the Client.
Now, it is working fine when I use to create a record through the form. But if I use in Grid edit mode It shows all the related record and columns which I have set up in the table properties, not from the custom report. (If I remove the dependency of SOW assignment fields from the Client that it's working fine).
I hope you got my point now.
If it is still not clear to you. I'd happy to take a call with you.
Thanks,
Gaurav
