FastQuery is the webgate400 add-on module that transforms the way you access and use information stored in your ERP databases.
Reports automatically inherit webgate400 settings, including Command Services for navigation. When the Database Link module is present, they also support document generation and archiving, so documents can be attached to ERP information.
Create dynamic reports with an intuitive wizard,
without writing code
With the FastQuery wizard, you can create dynamic reports and make them available to users according to the authorization rules you have defined. The generated SQL code can be edited manually and saved for later runs.
FastQuery lets you create summary files on which you can generate up to 100 cascading queries, with the option to rerun previous queries to update calculated data. Reports can be opened directly in tabs configured in webgate400 or can run specific programs after a file has been generated. Where the query type allows it and the user is authorized, data can also be edited directly in the database from the query.
By simply defining axes and series, FastQuery automatically generates ready-to-use charts. Hierarchy, totals, and calculation functions such as count, average, and other aggregations are also available.
Four tools to analyze data the way you prefer
Navigate400: your business indicators always just a click away
Screens are enhanced with a panel featuring dynamic and static indicators that show at a glance the key data of the selected subject. From here you can perform successive drill-downs to navigate through information with the level of detail you need.
Cross Query: pivot tables in your ERP
Cross Query allows you to analyze and summarize data through a multidimensional table, with the ability to swap rows and columns. By creating a hypercube, you can compare data from different time periods. With one click, you immediately have a chart available on the data and totals.
Query Runner: simple, fast correlated queries with drill-down
Generate correlated queries with optional data drill-down quickly and directly.
Drop Query: a complete report with charts from any subfile, using drag & drop
Drag data from any subfile to automatically create a report with charts included.
Export results in the format you need, with one click.
Once the query is displayed, you can export the result directly to Excel. When the PSG Report Editor module is present, export is also available as PDF. You can also generate TXT, XLS, and XML files without even displaying the result on screen.
Prerequisites
- webgate400
- Optional: PSG Report Editor
Evolution, not revolution
For nearly 25 years, one principle has never changed: don’t become a company forced to chase technology; stay focused on what you do best in your industry.
Our job is to give you the tools to stay competitive, modern, secure, and scalable without losing what already works today.