Welcome to Open Exchange

At InterSystems, we deeply appreciate the rapid innovation enabled by open-source development. Our team acknowledges the significant impact of the community's dedication, which has been a driving force behind the evolution of software and data technology.

Featured applications

732 Application(s)
Filter
Show only
Last release on OEX
Categories
Works with
Industry
InterSystems IRIS
Clear filters
Analytics
iris-dmn
iris-dmn
IRIS + DMN, make business logic visually
5.0 (1)
DockerIPM
Integration
presto-iris
presto-iris
Presto InterSystems IRIS Connector
5.0 (1)
DockerPython
Technology Example
java-global-editor
java-global-editor
CRUD++ for globals from Java
5.0 (1)
DockerIPM

InterSystems Ideas Waiting to be Implemented

Programmatic reports

The report creation is a tedious and non-productive task. You need an IDE, create a connection, create a SQL query, define report bands, drag-and-drop/design report columns, fields, labels, summarizations, margins, charts and prepare perfect pixel reports for print. To create a tradicional report the effort takes 4 to 12 hours. The idea is to define reports using object script instructions. With some minutes and with writing a few object script lines you can get a report equivalent to a tradicional report, with the benefit to create dynamic content for the reports (productivity). The idea includes yet the feature to allows to the developer set print restrictions for the PDF report generated (reduce carbon emission, not allowing print, only read). Benefits of this idea: 1 - Productivity - develop a report in minutes not in hours 2 - Reduce carbon emission - is possible restrict the PDF print 3 - Create dynamic reports using ObjectScript 4 - No need to install a report server, saving processor and memory resources (decreasing emissions) To create a report using source code, see this sample with Java, but could be in ObjectScript too: TextColumnBuilder<String> itemColumn = col.column("Item", "item", type.stringType()); TextColumnBuilder<Date> orderDateColumn = col.column("Order date", "orderdate", type.dateType()); TextColumnBuilder<Integer> quantityColumn = col.column("Quantity", "quantity", type.integerType()).setFixedWidth(50); TextColumnBuilder<BigDecimal> unitPriceColumn = col.column("Unit price", "unitprice", type.bigDecimalType()); ColumnTitleGroupBuilder titleGroup2 = grid.titleGroup("Group 2", quantityColumn, unitPriceColumn); ColumnTitleGroupBuilder titleGroup1 = grid.titleGroup("Group 1", orderDateColumn, titleGroup2).setTitleFixedWidth(450); report() .setTemplate(Templates.reportTemplate) .columnGrid(itemColumn, titleGroup1) .columns(itemColumn, orderDateColumn, quantityColumn, unitPriceColumn) .title(Templates.createTitleComponent("ColumnTitleGroup")) .pageFooter(Templates.footerComponent) .setDataSource(createDataSource()) .setSecurityRule(PrintRule.READ_ONLY) //if you want restrict print .printPDF();

Y
by Yuri Marx

4

Votes

3

Comments
Vote
Technology Example
native-api-command-line-java
native-api-command-line-java
Java Client for NativeAPI CommandLine Extension
5.0 (1)
DockerIPM
Solutions
iris-parquet
iris-parquet
Read and write files and datasets between InterSystems IRIS and Parquet
4.5 (1)
DockerIPM
Technology Example
mypButtons
mypButtons
mypButtons routine creates CSV from pButtons HTML.
3.8 (3)
Integration
mercure-outboundadapter
mercure-outboundadapter
This adapter allows you to send SSE events from IRIS using Mercu
0.0 (0)
DockerIPM
Solutions
JIRISReport
JIRISReport
Create Drag and Drop JasperReports and run on InterSystems IRIS
4.5 (1)
DockerIPM
Technology Example
iris-ipc-utils
iris-ipc-utils
Inter-process communication example with $SYSTEM.Event
5.0 (1)
DockerIPM
Solutions
iris-imap-python-adaptor
iris-imap-python-adaptor
An implementation of an imap python adaptor with a support of OAuth2
5.0 (1)
DockerPythonIPM
Solutions
IRIS Smart String
IRIS Smart String
Smart String Datatype for InterSystems Products
5.0 (2)
DockerIPM
Integration
workshop-firebase
workshop-firebase
Firebase adaptor
0.0 (0)
DockerIPM
Solutions
zapm
zapm
And now ZAPM has survived to the first version and can add any command that I need and remember it so that I can re-execute it.
4.5 (1)
DockerIPM
Solutions
QuinielaML
QuinielaML
Soccer match predictions with IntegratedML
5.0 (1)
DockerML
Solutions
journal-file-indexer
journal-file-indexer
IRIS Journal file indexer
5.0 (1)
DockerIPM
Technology Example
custom2hl7
custom2hl7
Transform custom patient data format to the HL7v2 format
4.3 (3)
Docker
Solutions
OpenAPI-Suite
OpenAPI-Suite
Set of tools for ObjectScript code generation from Swagger 3.0
5.0 (4)
DockerIPM
Technology Example
passwordless
passwordless
Passwordless mode for Dev Mode IRIS
5.0 (3)
DockerIPM
Developer Environment
isc-one-liners
isc-one-liners
useful one line commands for objectscript
5.0 (2)
DockerIPM
Solutions
iris-table-audit
iris-table-audit
Enabling a full record audit trail
5.0 (1)
Docker
Technology Example
Samples-Aviation
Samples-Aviation
Provides sample data for use in exploring InterSystems IRIS Text Analytics capabilities. Also includes sample analytics model elements.
4.5 (2)
DockerIPM
Solutions
doxygen-objectscript
doxygen-objectscript
Doxygen filter that ables you to generate static documentation
0.0 (0)
Python
Technology Example
Object-based-M-N-to-JSON
Object-based-M-N-to-JSON
Sample for object method %JSON.Export for M:N Relationship
5.0 (1)
DockerIPM
Integration
Open API Client Gen
Open API Client Gen
IRIS Interoperability Production generator from Swagger 2.0 specification.
5.0 (1)
DockerIPM
Solutions
openapi-common-lib
openapi-common-lib
This library contains common code for openapi-client-gen and openapi-server-gen.
5.0 (1)
DockerIPM
Technology Example
Utils
Utils
Various code snippets for InterSystems IRIS
5.0 (1)
DockerIPM
Developer Environment
objectscript-openapi-definition
objectscript-openapi-definition
The objectif of this library is to generate the ObjectScript Class from an OpenApi defintion.
4.5 (1)
DockerIPM
Solutions
apptools-django
apptools-django
IRIS management portal using the Django framework
4.0 (1)
DockerPythonIPM
Solutions
openapi-server-gen
openapi-server-gen
IRIS server-side REST class generator from OpenAPI specification
5.0 (1)
DockerIPM
Technology Example
workshop-timeseries-csv
workshop-timeseries-csv
Example of IntegratedML Time Series predictions.
5.0 (1)
DockerML