05-18-2012 02:59 AM
according to me sroted process will be the good option which run and execute automatically for each client, where in for IDP we need to provide special authentication so that other client can be hide for the display.
05-21-2012 01:36 AM
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.