Hi everyone. Is is possible to create a report book with multiple sheets / reports. If so, can the company name be dynamic within a report book i.e. selected at runtime? Also, does anyone know if there is a way to copy a row definition from a form into a report?
For the multiple sheets/reports, we have not found a way within Controller but what we do is:
1. Run a report book.
2. Open all files saved from the book.
3. Run a VBA code which pulls all files into one book.
4. Delete separate files. Keep the one new file.
This works very fast and is done within 1 minute after running the report book. I can send you the code I wrote if you like.
For copying a form row definition into a report, you cannot actually open the definition in the report but I have copied directly from the form definition and directly into the form row definition with old fashion CTRL C and CTRL V. You have to insert lots of rows before this works. Then you have to sometimes click onto each pasted account to get the programs to recognize the paste. It is faster than entering one by one.