you can try out with following steps, if I understood your question correctly it should be work with below steps; 1.prepare a program which generates small data having client-ID and gender 2. prepare a stored process where your prompt should be based on client-ID 3.run the stored process. you can view the report seperatly for each client. the entire project you can prepare even in EG. let me know if it works for u.
... View more