Data Post Processing
Results of data sources queries are simple table-type recordsets (set of fields distributed along more rows) obtained by SQL command.
Many times such a tables need to be modified before being inserted in a report template, both in the contents and in the layout.
Without repSL there are only two ways to do this:
- Running very complex SQL queries returning a result that can be pasted in the template as it.
This approach requires high SQL programming and DB management skills, the availability of OLAP features on your data source, privileges on accessed source to use particular functions or procedures, to create temporary tables, to use system objects, and so on...
- Manually modifing results of simple SQL queries.
Returned table-type recordsets can be modified using temporary Excel sheets, copying and pasting data between them, changing each element, value or format with mouse and keyboard. Moreover if you have tens of recorsets to post-process in the same way, you must repeat tens of time the same changes. This is the worst approach in terms of time, costs and user errors!
|
