- Layout Table Report Example: Customer List
/pages/Guides/Report/Layout Table Reports/Layout Table Report Example__COLON__ Customer List.xml
In this example we will create a layout table report in the AlphaSports database that lists customers by state. It is loosely modeled on the Customer List Free Form report sample supplied in the AlphaSports database.
- Converting a Quick Report to a Layout Table Report
/pages/Guides/Report/Quick Reports/Converting a Quick Report to a Layout Table Report.xml
Once you have gone as far as possible with a Quick Report, you'll want to convert it to a Free Form or Layout Table Report. The Open in Report Editor button on the main toolbar does this when the Quick Report Genie is open.
If you want to preserve the Quick Report for future use in the Genie, first press the Save As button on the main toolbar and either accept the generated name or choose a new name.
- Web Grid Enhancements V11
/pages/Index/Web Grid Enhancements V11.html
- Linked Reports
/pages/Guides/Report/Linked and Sub Reports/Linked Reports.xml
Linked Reports are Layout Table reports embedded into other reports, and linked with the host report on some field. Linked Reports are similar to Subreports, but more flexible — and, in fact, similar in functionality to Subreports in some other products.
Using linked reports allows you to create ledger reports, among other useful report patterns that were not previously possible. In a ledger report, the Debit and Credit tables are both linked to the account table on the Account ID field, and it is possible to compute a balance on the account. Structurally, this pattern is the same as for a customer statement report that displays orders and payments.
- Generating Reports
Printing, emailing, and faxing reports.
- How to Create a 'Conditional Object' in a Layout Table Report
/pages/HowTo/Reports/Conditional Objects in Layout Table Reports.xml
When creating Free-form reports, the Conditional Object control is used to dynamically display content. When designing Layout Table reports, the same functionality can be created with Static HTML.
- Managing Reports
Copying, archiving, and working with report preferences.
- How to Export a Layout Table Report with Live Forumlas to Excel
/pages/HowTo/Reports/Live Excel Forumlae in Layout Table Reports.xml
When exporting a Layout Table Report to Excel, calculated fields can be configured to export as Excel Formulas, instead of static data.
- Creating Reports
- Quick Reports
Building reports with the Quick Report Genie