Update:
Hello Jllort,
I tried creating a report.
It seems like it can't display multiple property groups.
I first created a report for my okg:si .
When I saved my file, I uploaded the .jrxml in openKM but there is an error.
THIS IS THE ERROR:
Class: java.lang.IllegalArgumentException
Message: protocol = http host = null
Date: Mon Jan 23 17:13:12 CST 2017
also, how to create parameters just like the in the available reports in openKM, wherein there is a from and to date ??
Thank you very much!!!
This is my sql query:
Code: Select allSELECT NBS_NAME,NBS_AUTHOR,(SELECT NPG_VALUE FROM OKM_NODE_PROPERTY WHERE NPG_GROUP='okg:si' AND NPG_NAME='okp:si.tin' AND NPG_NODE=NBS_UUID) AS TIN,(SELECT NPG_VALUE FROM OKM_NODE_PROPERTY WHERE NPG_GROUP='okg:si' AND NPG_NAME='okp:si.salesperson' AND NPG_NODE=NBS_UUID) AS SALESPERSON,(SELECT NPG_VALUE FROM OKM_NODE_PROPERTY WHERE NPG_GROUP='okg:si' AND NPG_NAME='okp:si.date' AND NPG_NODE=NBS_UUID) AS DATE, (SELECT NPG_VALUE FROM OKM_NODE_PROPERTY WHERE NPG_GROUP='okg:si' AND NPG_NAME='okp:si.sino' AND NPG_NODE=NBS_UUID) AS SI_NUMBER FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT DISTINCT(NPG_NODE) from OKM_NODE_PROPERTY WHERE NPG_GROUP='okg:si')