.rep Report Generator tool

[Jiten@TS]

Hi Team,
I want to generate a report in OpenKM.
I am using iReport tool to generate report, but it is generate a jrxml file.

I want to add following parameters while generating report.
1. From Date , To Date - Date Picker. (checked with available example on web. found .rep files only)
2. DropDown list (how to add dropdown list with dynamic option list - fetch data from database, exa. all users in dropdown)

All above my requirements I need to generate .rep file. but I don't know which report generator tool is require for it.

Please help to resolve above queries and let me know if any changes requires.

Thanks in Advance

[jllort]

.rep it's a simply zip file, create a zip file with all contents needed into and then rename as .rep

[Jiten@TS]

Thanks for your reply!
Ok. I got the concept of .rep file.


what about second question regarding dropdown with dynamic option list.

I am using community version 6.3.
According to given http://wiki.openkm.com/index.php/Form_E ... escription.
I have tried with following code, but unable to generate dynamic values.

Params.xml in .rep file

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE report-parameters PUBLIC "-//OpenKM//DTD Report Parameters 2.1//EN"
                                   "http://www.openkm.com/dtd/report-parameters-2.1.dtd" >
<report-parameters>
 <input label="From" name="from_date" type="date">
  <validator type="req"/>
 </input>
 <input label="To" name="to_date" type="date">
  <validator type="req"/>
 </input>
 <select label="Provincia" name="provincia" table="provincia" type="simple" optionsQuery="SELECT|provincia|$pro_id=1">
 <option label="pro" name="pro" value="$pro_id"></option>
 </select>
</report-parameters>

Also tried with following query in Params.xml

Code: Select all

<select label="Provincia" name="okp:p:provincia" type="simple" 
       table="provincia" optionsQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia'"/>

Could you please answer to my question asap.

[Jiten@TS]

Hi jllort

Could you please let me know, how I can user internal table 'okm_user' data in dropdown list.

[jllort]

Take a look at this class https://sourceforge.net/p/openkm/code/H ... alues.java

you should implement a select like:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.3//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.3.dtd">
<property-groups>
  <property-group label="Consulting" name="okg:consulting">
    <select label="select label" name="okp:consulting.select" type="simple" className="com.openkm.select.values.OptionSelectUserList" />
  </property-group>
</property-groups>

I think we missed explain it on http://wiki.openkm.com/index.php/Form_E ... escription

[Jiten@TS]

Thanks a lot jllort.
It is working now.

The changes, I had made, are:
1) Added "className" attribute in select clause of DTD
2) Specified className in params.xml in select clause.