
I have a custom table which has a User field (relation to User) as the key as well, plus an extra field, SG Number.
So I know the SG Number is always 1 (one) for each user. So when running a report I have tried adding a dataset like this:
But this always returns all rows on each "child dataset"
WHat options can I explore to have it return only the matching row, where the UserName matches with the Parent table's user?
Hi,
Please share both tables structure and its sample data.
Regards
Amit Sharma
www.erpconsultors.com
Press Yes if verify.