The SQR Production Reporting Studio Layout window helps you design reports and retrieve database information; however, you may want to enhance or further customize these reports in a way that goes beyond the scope of the layout. You can make these types of changes or enhancements with the Production Reporting programming language.
Using the Production Reporting programming language, you can write reports that are more complex than reports generated from layout formats. For example, you can write a Production Reporting program that updates the database, performs procedural logic prior to printing, and defines specific column wrapping or special formatting,. You can also add #INCLUDE files to keep commonly-used routines in a single file and create lookup tables to improve query processing. You may wish to write your basic report using the layout format, and then make changes directly in the Production Reporting code.