Thanks for answering my questions. I just need a bit of clarity here.
Keeping in mind that I need to print the reports on demand client side, and also need to generate and email from server side, and also that I will eventually have several reports:
Is a screen variable attached to each report the most efficient way to specify the user key value?
I’m still not sure about the difference between using a process or using a form to generate the reports. In my Generate Reports form, it works just fine. Can you please elaborate when one is better than the other?
For the automated process, I sometimes have to email reports to our board members, and sometimes have to email reports to our study group leaders. There are tables which define who are the study group leaders, and also who are the board members are and which reports they each receive. I was hoping to have a form similar to my Generate Reports form, but instead of generating a report client side, it could do the mail merge and email those reports server-side. On this form, I could have a choice between board reports and study group reports, with choices for each of those types defining which reports to send and/or which board officers to send to.
It seems like this is fairly complex for a process but maybe not for a form. I hope you can help me with these questions. Thanks…