Subreport or Subdataset

[christian.lehmann_1]

Hi community!

I'd like to create a capacity-report from zabbix in jasper. The DB-structure of zabbix is quite complex, so i thought (and also read) about doing it with API-calls and the Web Service Data adapter.

To keep this flexible, my plan was to have (as a start) two datasources: One does the request "host.get" which fetches all hosts. The other is "history.get" which gets the capacity-data for each host.

Separately, this works. I can get hosts, and i can fetch data from a hardcoded hostid with the other request. But as soon i try to make it dynamic, i run into trouble. The most common error is "net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error creating request: net.sf.jasperreports.engine.JRException: The verb can't be null".

Does anybody know how to solve this? I searched a lot and did not find any hints on solving this. The only place where the termn "Verb" is used is with the type of http-request (get/post etc), but this can't be the issue!

 

Chris

[hozawa]

You'll need to save the data from Zabbix into one database table and that as the datasource for JasperReports.

[christian.lehmann_1]

Really? There is no possibility for sub-queries?

I now switched for a direct db-connection to the postgres-server but did not yet try executing subreports. So this will fail as well?

Thanks for your answer!

Chris