dbFront 1.3.0 fully supports Stored Procedures that return multiple result sets.
Those multiple resultsets can either be displayed raw, included in a Template-Based report, or exported as CSV or Excel.
An Excel template can be used and you can specify where in the Excel template you want to dump each individual resultset. dbFront will automatically expand the section as required. dbFront will also skip over formula columns so it is easy to include formulas in your Excel templates.
Stored procedures can perform highly complex business logic and return highly dynamic results and result formats. This is an excellent way to quickly generate very complex reports or exports that are still very easy to maintain.
This is great for when you need to create complex quotes that require loading multiple sections of an Excel template. Examples include quotes for insurance, construction or any other field where there are multiple sections such as pricing details, quote-specific terms and conditions, notes and more.