Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36204-split-data-row/ .
To split fields apart and recombine them into records, you can use the stored procedure or a report script. But as the code is complex, an alternative choice is using esProc to help the reporting tool with the job. Let...
2015-04-27 18 0
Irregular month grouping: If the start date is 2014-01-10, group dates from this date to 2014-02-09 together and dates from 2014-02-10 to 2014-03-9 together. If the start date is 2014-01-31, put dates f...
2015-04-25 13 0
1. File encryption
esProc provides ways of encrypting cellset files to protect them from unauthorized access or use. There are two levels of encryption:
Execution privilege：By this privilege, users can set parameters, execute the cellset and see the cell values; they can also view the cellset descriptions and cell tips...
2015-04-24 13 0
Using esProc, it is quite convenient to group data in memory. There are several main types of grouping based on how data is grouped. Here we’ll illustrate equal grouping, alignment grouping and enumeration grouping respectively with an example.
That data is grouped by one or more certain fields (or one o...
2015-04-24 13 0
esProc provides flexible charting functionality. It allows users to define parameters and data used for charting with the graphics editor, and to draw various styles of charts as needed using drawing functions.
1. General charting procedure
Let’s learn of the general procedure of charting in esProc through the followin...
2015-04-23 16 0
Here, we use esProc to analyze the upward trend in stock prices. There is a variety of algorithms, of which one will be illustrated in detail. Other cases can be handled using the similar codes. Specific requirements are:
Among the stocks which have kept going up for N days, what is the proportion of those that c...
2015-04-23 18 0
The calculation of opening balances according to deposit and withdraw amount involves inter-row operation. Jasper can do the calculation but the code is complicated. You can use esProc to assist the jo...
2015-04-22 26 0
Problem source: http://community.jaspersoft.com/questions/851148/loop-jasper .
The calculation of loan payments according to loan amount will involve loop operation and inter-row operation. It is difficult to write code for it using stored procedure or Scriptlets. Yet with the help of esProc, the Jasper calculati...
2015-04-21 63 0
Generally intragroup inter-row calculations are handled with window functions or report scripts. But the code is rather complicated. Instead, you can use esProc to assi...
2015-04-20 13 0
Problem source: http://community.jaspersoft.com/questions/847490/how-get-annual-growth-rate-crosstab .
As every column in a crosstab is generated dynamically, you also need to reference them dynamically when performing inter-row calculations. There is some difficulty in handling this dynamic reference using a Jas...
2015-04-17 26 0
Problem source: http://bbs.csdn.net/topics/390611005 .
Below is JSON data (s.json) the system acquires:
“MESSAGE”: “IMEI Servi...
2015-04-16 41 0
Problem source: http://stackoverflow.com/questions/29396985/is-there-a-where-like-relation-function-when-using-pymongo .
It is difficult to join MongoDB collections through hardcoding as it doesn’t directly support joins. Yet you can use esProc to perform inner join, left join and full join between collections or join ...
2015-04-15 30 0
Problem source: http://bbs.csdn.net/topics/391014229.
Below is data from SL field of table tb1:
You need to calculate the sum of values every five rows. The expected aggregate result is as follows:
That is, the first column is the int...
2015-04-14 25 0
We often need to sort records in a table for data analysis and computing. esProc supports sort function to sort sequences or table sequences. External memory sorting is required when the data being sorted is too huge to be loaded into the memory all together and the ordinary sorting method cannot be used.
2015-04-13 14 0
Problem source：http://stackoverflow.com/questions/29392169/populating-field-values-for-referred-documents-in-aggregate-call-in-mongoose .
With MongoDB’s built-in API, you implement a foreign key relationship through hardcoding. The hardcode is not intuitive and difficult to write. In this case you can use esProc to han...
2015-04-10 22 0