English
Français
ItalianoInformes
Scriptcase es una poderosa herramienta para generar sistemas web y aplicaciones de negocios. También le ayuda a crear informes completos (con paneles, cuadros y tablas dinámicas) de una manera simple y rápida para el análisis de datos de gestión (Business Intelligence). Obtenga más información sobre las funciones disponibles para crear informes y resúmenes.
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
Informe con temas dinámicos
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
Informe con Resumen en forma de "Pivot Table"
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.
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
Informe en resumen con agrupación y totalesAplicación del Grid utilizando Agrupación Dinámica para el Resumen
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
Informe con Maestro/Detalle - Clientes y sus PedidosGrids anidadas con TreeView
Grid Filtering/Search
Within Grid application you can filter data using various types of filters, individually or combined:
- Advanced Search - Filter module which works integrated with the Grid modules to check for data view before the Grid display. It offers a range of search criteria and conditions according to the given type (equal, start with, does not contain, other than, greater than, less than, between values, empty, Null, different date periods, etc).
- Dynamic Search - Filter for dynamic selection of conditions and fields directly within the generated application. With this filter the end user may choose fields and conditions at runtime.
- Refined Search - Filter that restricts values within the Grid according to the universe of existing data directly in the application generated.
- Summary Search - Dynamic filter for data Summary and Chart modules. Filters the data dynamically within the tables at runtime.
- Quick Search - General filter that searched within the grid data according with determined term entered in the search field.
Samples
Formulario MobileFiltro Refinado
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
The fields (columns) in the Grid application can be selected during the development or dynamically by the user within the application generated.
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
Grids generated by Scriptcase can be automatically exported to XLS (Excel), XML, DOC (Word), PDF, CSV, RTF and printing.
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
Grilla Default
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
Gráfico de ÁreaGráfico de Barras 2DGráfico de Barras 3D
PDF Report
Application for generating reports using predefined formats. This application is created via the TCPDF library, which is natively integrated with Scriptcase.
+1-800-925-0609
+55 81 97102-7382
Facebook
Twitter
Instagram
Youtube
Linkedin