Hello,
I have a report designed right now that prints information about a company from my database and I need to design a few forms that have lists of companies, and where the user can select a company from the list and click a button to send the report for that company to someone via email.
Right now I can only get the email to send ALL the pages of the report, but I only want to send the information for the selected company. I understand that I could make a report's query based on the form in order to check the company's ID, but that would mean that I'd need to make a bunch of different reports for each form I would like to print from (because they would each need to refer to a specific field in a specific form). Is there some way to pass a WHERE statement, or something similar when Emailing a report? Then I could use the same report for all the different forms, which saves a lot of time and space.
Thanks
-Cavern
I have a report designed right now that prints information about a company from my database and I need to design a few forms that have lists of companies, and where the user can select a company from the list and click a button to send the report for that company to someone via email.
Right now I can only get the email to send ALL the pages of the report, but I only want to send the information for the selected company. I understand that I could make a report's query based on the form in order to check the company's ID, but that would mean that I'd need to make a bunch of different reports for each form I would like to print from (because they would each need to refer to a specific field in a specific form). Is there some way to pass a WHERE statement, or something similar when Emailing a report? Then I could use the same report for all the different forms, which saves a lot of time and space.
Thanks
-Cavern
