So the call reporter creates a very limited amount of reports. To further the problem the data exported via Save-As from the report is entirely useless.
I can use PGAdmin to access the data myself but I havent found the actual queries the call reporter is using published anywhere so I can get to the same data but in a useable format.
I mean seriously... look at an export to CSV. Its like its adding in a bunch of empty fields and makes trying to sort / filter / pivot table in excel impossible without an hour of deleting stuff and fiddling.
Export to Excel 2007 File. same crap, extra rows and columns and weird merge columns.
Export to XLS with table. garbage
So:
Does anybody have a list of all the actual SQL queries used by call reporter.
or
Has anybody figured out how to export directly from Call Reporter into a usable format.
I can use PGAdmin to access the data myself but I havent found the actual queries the call reporter is using published anywhere so I can get to the same data but in a useable format.
I mean seriously... look at an export to CSV. Its like its adding in a bunch of empty fields and makes trying to sort / filter / pivot table in excel impossible without an hour of deleting stuff and fiddling.
Export to Excel 2007 File. same crap, extra rows and columns and weird merge columns.
Export to XLS with table. garbage
So:
Does anybody have a list of all the actual SQL queries used by call reporter.
or
Has anybody figured out how to export directly from Call Reporter into a usable format.
