Idea Summary
Introduce a native, visual "Canvas" within APEX for designing pixel-perfect reports (PDF, Excel, HTML). The tool should allow developers to upload a data structure (via XML tags or JSON schema) and then drag those "tags" onto a design surface to create headers, footers, tables, and sections.
Use Case
APEX is excellent for data-driven web screens, but generating highly formatted documents (like Invoices, Purchase Orders, or Regulatory Filings) is difficult. Currently, developers must:
- Use external paid tools (Oracle Analytics Publisher).
- Manually code complex XSL-FO templates (which is error-prone).
- Use community plug-ins that may not be supported long-term. There is no "native" way to visually align a logo, a signature line, and a data table on a fixed-size A4/Letter page.
Preferred Solution
- Tag-Based Design: Allow developers to upload an XML file or sample SQL query. APEX should parse these into a "Data Panel" of available tags.
- The Canvas: A visual, "What You See Is What You Get" (WYSIWYG) editor where developers can:
- Drag tags from the data panel onto the canvas.
- Define repeating sections (for table rows).
- Set precise coordinates (X/Y) for elements.
- Built-in Logic: Ability to apply conditional formatting (e.g., "if amount > 1000, make text red") directly on the canvas objects.
- Native Integration: This designer should live inside "Shared Components" under a new "Visual Report Layouts" section.
Tags: Reporting, XML, PDF, Pixel-Perfect, Report-Designer