Boekkamp

updated

15 years ago

B

Boekkamp

9 Posts

1

1617

March 23rd, 2011 01:00

Realtime reports using DPA API and built-in webserver (apache)

Hi All,

Currently we are creating static reports using the scheduled reports option and placing the resulting html documents in the reports folder.

Does anyone know how to use the DPA API to create dynamic reports using a webserver so we can request reports using

The report would be requested using an url like:

http://dpaserver:9002/reports/dpa_api.cgi?request=report&?reportname=reportcard

dpa_api.cgi should be a custom script where we can do the talking to dpa_apitool and using the variable values and predefined information

such as the authfile.

The result of the request should be an xml which is sent back to the browser so it can be formatted using an xlt

My questions are:

  • what would be needed to run the reports like this
  • how to set this up using the built in http server for DPA
  • how would the script look like
  • what would be the easiest way to format an xlt which makes the xml data readable

Kind regards,

Jeroen