esCalc Basics: Installation and Usage discussed how to install esCalc and use it to make spreadsheets. The spreadsheet data may be of any data type and can be displayed in various appearances. This article mainly covers most used data types in esCalc and the setting of cell properties.
1. Data in the cell
In esCalc, da...
2015-06-19 25 0
Sometimes you need to reference data sources dynamically through a parameter, merge data sources into one, or dynamically pass data source name to a subreport/Table control. Often reporting tools – especially those with support for single data source, such as BIRT and Jasper – have to use a high-level language to...
2015-06-18 87 0
Java provides functions for handling the basic file processing, which refers to the retrieval of small text files, in a simple, unstructured way. But in handling files requiring structured format, holding data of various formats and having particular requirements, or big files that cannot be entirely loaded into memory...
2015-06-17 18 0
The series of articles on esProc charts discussed how to use chart elements in plotting algorithms to make charts. Besides writing plotting algorithms, we can use a number of built-in ready-made graphs to quickly plot common styles of charts.
There are four types of ready-made graphs (Column graph, Line graph, Pie grap...
2015-06-16 13 0
It’s hard to create reports with unconventional layouts directly with functions provided by a reporting tool. However, if the data for building such a report can be beautifully prepared, the difficulty could be considerably reduced.
esProc(free edition is available) is an expert at handling this data preparation. It pr...
2015-06-15 37 0
Sometimes you need to query a big text file, instead of the database. In those cases, you need to retrieve the file in a stream style to perform the query algorithm, in which parallel processing is needed to improve the computing performance. As Java lacks the class library for doing these, you have to use hardcoding t...
2015-06-12 17 0
This article aims to test esProc performance of retrieving files and compares it with the result got by using Oracle JDBC.
The test data is some order records saved in the orders.b file. Import the file with esProc and its content would be like this:
ORDERID CLIENT SELLERID AMOUNT ORDERDATE NOTE...
2015-06-11 13 0
This article aims to test esProc performance in processing files concurrently, based on filter, group and aggregate operations and comparison with Oracle.
Test data includes tables of ordering information of different years. With esProc, files (Orders2009.b, Orders2010.b, Orders2011.b and Orders2012.b) of binary format...
2015-06-10 15 0
It is not uncommon in actual business to tackle complex computational problems by composing dynamic SQL. The skill has generated a lot of discussion across online IT forums. Here are links to some of the questions around it:
2015-06-09 17 0
esCalc is a computing software for handling spreadsheet data. It can be used to make a spreadsheet, as well as to analyze or process the structured data it holds. The storage structure esCalc uses to store data enables users to analyze and generate many types of derived data, such as performing the year-on-year compari...
2015-06-05 20 0
This article focuses on testing performance of esProc’s handling of file traversal, using commonly used group and aggregate operations as well as query and filter operations. The performance test will include evaluation of the influence of using multithreads, and comparison between esProc approach and Oracle counterpar...
2015-06-05 19 0
In some cases, data must be stored in the file system, rather than in a database. That requires handling file-based data computing manually. Since Java lacks the related class library, you have to hardcode the structured file computing, which produces complicated and unreadable code.
Yet, you can make up for this defic...
2015-06-04 19 0
In esProc, it is common to add text to various charts. The text is plotted and positioned with the text element, and has its own style compared with text working with other chart elements (though the latter’s properties can be adjusted in a similar way).
The text element has a relatively simple functi...
2015-06-03 25 0
24-point game is a common intellectual game, which can be played with cards without jokers. The rule is to draw four random cards and manipulate the four numbers to get the result 24 using four arithmetic operations: addition, subtraction, multiplication and division. In card playing, J, Q, K correspond numbers 11, 12 ...
2015-06-03 19 0
For a given system of linear equations in n unknowns, there must be n equations to form the system. e.g.:
Well, how do you solve this system of linear equations with n variables with esProc? First, the system of equations should be written in a standard form, and parameters are fill...
2015-06-02 21 0