alca1

I use mySQL. Do you mean than that the problem must be solved through SQL?

I have a db table that is logging tasks. Events are grouped and have a timestamp: like this for example groupidtaskTypetimestamp1start10:001pauseOn10:301pauseOff10:351pauseOn10:551pauseOff11:001end11:30 I need to create a report for total time required to perform tasks, subtracting the "pause" time... What is the best way to achieve this? Maybe the db must be modified a little to create easily the reports? Or there are some trick or formulas to create such a report?

Let's say I have this data table: {id_order, date_order} I want to show the n. of orders in a period as percentage of the total number of orders. I defined id_order as a countAll measure and date_order as dimension. I used date_order as row and id_order as columns in crosstab report. Next I added a filter on date_order: is between. What I would like to show is just a box, with inside a BIG number with the percentage of orders against the total and below the period. I tried to introduce a calculated measure PercentageOf ("id_order","Total") but it just works per row. (and even so number are not right) I'm a bit lost, I don't how to do it nor I find relevant resources/examples

JasperServer 5.6.0 Release on CentOS 6.6, JDK1.7, trying to install for mysql. I run ./js-install-ce.sh but build fails with this error /opt/jasperreports-server-cp-5.6.0-bin/buildomatic/bin/setup.xml:320: java.lang.InternalError... Line 320 appear to be : <create-ks ks="${ks}" ksp="${ksp}" propsFile="${masterPropsSource}"/> Stack trace gives some hint at a security problem: ...at com.jaspersoft.jasperserver.crypto.KeystoreManager.generateSecret.. MySQL is up and running and user/pwd are correct Any help greatly appreciated! thanks