This application works in conjunction with the free CMS system PDQ Portal (http://www.pdqportal.com). It provides a convenient way to generate reports or other HTML or plain text messages from any database that can be accessed from the server.

• Reports are designed in sections that define what database, index, key and selection formula to use
  
• Child sections can specify different databases
  
• Allows relational reporting of Notes data without the performance penalty of NotesSQL and without having to restructure indexes
  
• Generated reports can then be distributed.
  
• The report generation and distribution process can be used for sending out bulk email newsletters
  
• Distribution lists are generated by selecting user names, database ACL groups, uploaded CSV files, or can be created dynamically from data in any database
  
• The distribution process runs on the server and progress can be monitored from the "run document"
  
• The "Run document" can stop/ start/ pause the distribution or a particular report
  
• Throttling of transmissions can be set in the configuration document
  
  
  
  The file posted here contains all of the definition documents and @formulas that define the report generation application. To use this application, download the free PDQ Portal CMS system and copy these documents in to it (if they are not there already). All code in this application is released under the GNU GPL license and can be freely modified and distributed.
  
  
  
  Coming soon: two pass reports and numerous total and summarizing improvements.