Preparing data for Report
Middleware for report source data computing
2019/09/12 by pjfHow to migrate SQL in application to different types of databases
2019/12/30 by HooSome examples of solving BIRT dynamic data source
2019/12/25 by HooHow to deal with rounding balance in reports
2019/12/13 by HooUsing esProc to realize the sub database summary
2019/12/13 by HooSome examples of solving BIRT special layout
2019/11/25 by pjfMaking a More Efficient iReport with esProc
2019/11/25 by pjfDevelop reports efficiently with esProc
2019/11/19 by JerryCalculation script improves report development efficiency
2019/11/07 by pjfImplement intra-group cross-row calculation In Birt
2019/11/01 by pjfFree computing
Offline Free computing
2019/11/06 by pjfAn Easy Way to Merge and Summarize Excel Files
2019/04/18 by pjfCSV File Comparison
2019/11/25 by pjfStructured Text File Processing in SPL (II)
2019/11/25 by pjfExcel integrate esProc
2019/11/07 by pjfSPL parsing and exporting Excel
2019/10/22 by HooStructured Text Computing with esProc
2019/10/22 by HooCSV file with multiples tables, how to get the middle table only
2019/07/29 by pjfLatest
How to implement a pivot without aggregation?
8hour ago by xingjlCalculate the growth of TopN in one line
8hour ago by xingjlGet multiple records with the maximum value in one line
8hour ago by xingjlHow to do dynamic transposition that can’t be solved by pivot
8hour ago by xingjlUse an Embedded Script to Quickly Parse Multilevel JSON Data in Java
2020/02/10 by AndyParse Complex Excel Worksheet & Write Data to Database with a 3-line Script
2020/02/10 by AndyParallelly Process a Large File with a Two-line Script in Java
2020/02/10 by AndyHow to Use a Dynamic Data Source in BIRT
2020/02/10 by AndyHow to Perform Table Joins between MongoDB and MySQL
2020/02/10 by AndyHow to Join a Database Table & XML Data Conveniently
2020/02/10 by AndyDiverse data sources
XML data parsing and calculation
2019/12/27 by pjfJSON data calculation and importing into database
2019/12/16 by pjfPerforming Joins over MongoDB with SPL
2019/12/02 by HooGetting MongoDB Indexes with SPL
2019/12/02 by HooMerging MongDB Subdocuments
2019/12/02 by HooQuerying ListField in a MongoDB Subdocument
2019/12/02 by HooGetting Top N from MongoDB Data
2019/12/04 by HooMongoDB Data Grouping & Aggregationate
2019/12/04 by HooAchieving Foreign Key Joins between MongoDB Collections in SPL
2019/11/25 by pjfMongoDB Data Grouping & Aggregation
2019/11/25 by pjfSaving SQL Headache
SQL Headaches Therapies – For Loop Operations
2019/11/26 by HooSQL Headaches Therapies: For Set Operations and Getting Row Numbers
2019/11/26 by HooSQL Headaches Therapies – For Special Cases
2019/11/25 by pjfSQL Headaches Therapies – For Record Reference
2019/11/25 by pjfGrouping Data by a Non-field Condition in SPL
2019/11/25 by pjfSPL Simplified SQL Case Details: Intra-group Computing
2019/06/13 by pjfSPL Simplified SQL Case Details: Interline Computing
2019/06/13 by pjfSPL Simplified SQL Case Details: Multilevel Join
2019/05/27 by pjfSPL Simplified SQL Case Details: Multilayer Fixed Grouping
2019/05/27 by pjfEasy Java computing