FastQuery is the webgate400 add-on module that changes the way you access and use information stored in your ERP databases.
Reports automatically inherit the webgate400 settings, including Command Service for navigation and, with the Database Link module, can also generate and archive documents to attach 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 based on 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 that can generate up to 100 cascading queries, choosing whether to rerun previous queries to update calculated data. Reports can be opened directly in tabs configured in webgate400 or can run specific programs when file generation is complete. Where the query type allows it and the user is authorized, you can also modify data directly in the database from the query.
Simply define the Cartesian axes and the series, and FastQuery automatically generates ready-to-use charts. Hierarchy, totaling, and calculation functions are also available, including counts, averages, and other aggregations.
Four Tools to Analyze Data the Way You Prefer
Navigate400: Your Business Indicators Always One Click Away
Screens gain a panel with dynamic and static indicators that show key data for the selected record at a glance. From there, you can run successive drill-downs and reach exactly the level of detail you need.
Cross Query: Pivot Tables in Your ERP
Cross Query lets you analyze and summarize data in a multidimensional table and invert rows and columns. By creating a hypercube, you can compare data from different time periods. With one click, you get a chart based on the data and totals.
Query Runner: Related Queries With Simple, Fast Drill-down
Generate related 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 and automatically generate a report with charts included.
Export Results in the Format You Need, With One Click.
Once the query is displayed, you can export the results directly to Excel. With the PSG Report Editor module, export is also available in 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 guided us: don’t let technology turn you into a company that has to chase every new trend—stay focused on what you do best in your industry
Our role is to give you the tools to stay competitive, modern, secure, and scalable, without giving up what already works.