No-Code Report Generation Solution
The point-and-click query builder allows business users to create their own queries with drag-and-drop ease. Users choose the files they wish to interrogate, nominate the fields needed for the report and execute the query. There is no need to learn SQL to build the queries and filter the data for the query result data.
- BUSINESS USERS can access to enterprise data on Windows and IBM i (System i, iSeries, AS/400) servers without getting IT involved.
- QUERY, REPORT, AND ANALYZE data from a single tool with unparalleled ease- of- use via a graphical user interface without coding.
- SEND DATA to popular spreadsheets or other tools for extended analysis.
- DRAMATICALLY REDUCE the application development backlog by empowering users with the tools to create their own reports.
- EXPORT QUERY RESULTS to standard file formats including Microsoft® Access™, dBase, Microsoft® Excel™, and tab or comma delimited ASCII text files.
- SAVE QUERIES to repeat later, —for example, running monthly sales figures for a particular product.
Integrate with Third-3rd Party Tools
LANSA’s query builder and reporting tool uses dynamic data grouping and summarizing to produce the query result data. Saving the query result data as a Microsoft Access database allows you to integrate it with third- party reporting tools to extend reporting capabilities.
- LEVERAGE THIRD-3RD PARTY TOOLS such as Crystal Reports and Microsoft SQL Server Reporting Services.
- CREATE pivot tables, and multi-section reports
- PERFORM mail merges or publish reports to the web
- SKILLS MANAGEMENT: Stop struggling to find resources for each project. Equip and enable all your developers to universally work on every part of a project.
- STOP HUNTING FULL-STACK DEVELOPERS: LANSA turns your current team of developers into highly productive full-stack experts with minimal training.
Desktop Query Builder and Reporting Tool
LANSA Client is an ad-hoc reporting tool that enables normal business users to create custom reports and build queries to run later, without being an IT professional. IT is still in charge since they control which users have access to certain sets of data.
Ease of Use
LANSA Client enables business users to securely access enterprise data using a simple, graphical user interface. No need for users to be a coders or know SQL.
Users can finally get the data they need, when they need it.
Run Now or Save for Later
LANSA Client displays data – in real-time –
as rows and columns in a data grid, or in graphical views such as pie charts and bar graphs, that can be printed as a report.
Or, users can save their queries and
deploy them as an icons on the desktop
to be run later.
Secured Access
Defining and controlling query access in the LANSA Meta Data Repository centralizes the configuration and definition information. The repository holds the rules for navigating between files, ensuring that users will be able to work with the data they are allowed to use.