Can I include procedures/functions into the Report Builder?
Apply OS: Windows
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
Yes. Navicat allows you to include procedure/function in the SQL of the report builder. To do so, in the Query Designer > SQL tab, right click the grey area and choose Edit SQL.
Note: If you change the SQL manually, you cannot use the visual design tabs (Fields, Calcs, Group, Search and Sort) to modify the query.