Recurso

Reports

Scriptcase is a powerful tool for generating web systems and business applications. It also helps you to create complete reports (with dashboards, charts and pivot tables) in a simple and fast way for the management data analysis (Business Intelligence). Learn more about the features available to create reports and summaries.

Interface
Wide Range of Data Analysis Features

Wide Range of Data Analysis Features

With Grid application you can build sophisticated and highly customizable interactive charts and reports . You can display a grid data in an integrated way using a summary format (Pivot tables), chart and Grids. This application also offers different types of filters and advanced Group by settings for creating dynamic reports. Report settings can also be customized by the end user within the final application.

Samples
Report with dynamic themes
Pivot Tables and Charts

Pivot Tables and Charts

Connect and visualize your data in minutes. Combine multiple views of data to get wider insights. Best practices of data visualization are made within Scriptcase. From a simple SQL query it is possible to create pivot tables and integrated graphics, with different filters and settings options for data analysis.

Samples
Pivot Summary TableFunnel Chart 3D
Group By with Dynamic options and aggregate functions

Group By with Dynamic options and aggregate functions

Easy-to-use graphical interface for Group By management. Possibility of dragging the same dimension with different date period fields (semester, quarter, trimester, semester and others) and metrics with different aggregate functions (sum, maximum, minimum, average, Weighted Average, Count, Distinct count, Variance and Standard Deviation) for data grouping within the Grids, Summaries and Charts.

Samples
Group ButtonsDynamic Group By
Dynamic Summaries

Dynamic Summaries

Dynamic options for configuring and viewing summaries within each of the Grid modules. Summaries can be arranged independently for each module and also customized by the end user.

Samples
Using Group By and Totals
Subqueries/Nested Grids

Subqueries/Nested Grids

A subquery is a nested grid inside a SELECT, INSERT, UPDATE, or DELETE, or subquery. In Scriptcase these can be created through a graphical interface that manages the connection, parameters and layout settings within the final application.

Samples
Customers X Orders - Master / Detail ReportNested grids using treeview
Query Builder / Manager

Query Builder / Manager

Interface for automatic creation of select commands with options for selection of tables, fields, and relationships to prepare the Grid queries.

Dynamic Columns Configuration

Dynamic Columns Configuration

The fields (columns) in the Grid application can be selected during the development or dynamically by the user within the application generated.

Dynamic sorting

Dynamic sorting

The sorting settings can be made within the application generated by the end user, you can create simple or advanced orderings (with more than one field), according to the developer fields.

Grid export options

Grid export options

Grids generated by Scriptcase can be automatically exported to XLS (Excel), XML, DOC (Word), PDF, CSV, RTF and printing.

Different Grid Layouts

Different Grid Layouts

Scriptcase automatically generates the grid layout in horizontal, vertical or slide format. You can also use a “free format" layout, where you can freely draw the layout of the table by applying your own HTML and CSS.

Samples
Slide Grid with blocks and image fieldDefault Grid
Infinite Scrolling pagination

Infinite Scrolling pagination

Grids can be organized by using different paging types for data visualization: total record in page, partial paging or infinite scrolling (where data is loaded according to page scrolling).

Samples
Special Fields (Maps, Youtube and HTML Editor)Grid using infinite scrollGrid using infinite scroll with fixed height
PDF Report

PDF Report

Application for generating reports using predefined formats. This application is created via the TCPDF library, which is natively integrated with Scriptcase.

Samples
PDF Generator