balram.deswal_1

Hi Team, In my report created in Jasperstudio, I am calculating time difference between start time and end time in (Days, Hours, Minutes and Seconds). It is showing correct value when I view the report in Jasperstudio. But when I publish this report on Jasperserver, only Days value is showing incorrect value. Like in Jasperstudio, it is showing 2 Days which is correct. But in Jasperserver after publish, it is showing 61 Days!!!!!! What can be the reason for this? Kindly suggest the solution for this also. It is required on an urgent basis. Thanks & Regards, Balram

I have a table (test) in SQL having the data as follows: sampletime samplevalue 2017-05-10 12:17:02.000 100.00 2017-05-10 12:20:02.000 100.00 2017-05-10 12:23:02.000 100.00 2017-05-10 12:26:02.000 100.00 2017-05-10 12:29:04.000 0.00 //capture as start time 2017-05-10 12:32:02.000 0.00 2017-05-10 12:35:02.000 0.00 2017-05-10 12:38:02.000 0.00 2017-05-10 12:41:02.000 0.00 2017-05-10 12:44:02.000 100.00 //capture as end time with above start time 2017-05-10 12:47:02.000 100.00 2017-05-10 12:50:02.000 100.00 2017-05-10 12:53:02.000 100.00 2017-05-10 12:56:02.000 0.00 //capture as start time 2017-05-10 12:59:02.000 0.00 2017-05-10 13:02:02.000 0.00 2017-05-10 13:05:02.000 100.00 //capture as end time with above start time 2017-05-10 13:08:02.000 100.00 2017-05-10 13:11:02.000 0.00 //capture as start time 2017-05-10 13:14:02.000 100.00 //capture as end time with above start time 2017-05-10 13:17:02.000 100.00 2017-05-10 13:20:02.000 0.00 //capture as start time 2017-05-10 13:23:02.000 0.00 2017-05-10 13:26:02.000 100.00 //capture as end time with above start time 2017-05-10 13:29:02.000 100.00 2017-05-10 13:32:02.000 100.00 In this table, I want the query that will produce the following output: start time end time 2017-05-10 12:29:04.000 2017-05-10 12:44:02.000 2017-05-10 12:56:02.000 2017-05-10 13:05:02.000 2017-05-10 13:11:02.000 2017-05-10 13:14:02.000 2017-05-10 13:20:02.000 2017-05-10 13:26:02.000 Means as soon as the samplevalue gets 0, it records that time as start time and as soon as it becomes 100 again, it records the time as end time. How to design this query and build report in Jasperstudio for this? Thanks & Regards, Balram

Hi Team, Kindly provide the solution for the above issue. Regards, Balram

Hi Team, I am creating a report in Jasper Studio. In that report, I need to calculate the percentage as follows: (Count of rows where value of a column is 100)/(Count of all rows)*100 depending on filter of date. For this, I have created a main report with a dummy query which is returning only one row and passing the date parameter to the subreport. In that subreport, I have added the query somewhat like: select count(*) as overall_value, Table1.dept as department_name from Table2 INNER JOIN Table1 ON Table2.table_id=Table1.table_id where Table2.date_value>=$P!{p_finalstartdate} and Table2.date_value<=$P!{p_finalenddate} group by Table1.dept I am passing this overall_value and department_name as parameter to the table added in the detail band of the same sub-report with the query as follows: select count(*) as available_value, Table1.target as department_name from Table2 INNER JOIN Table1 ON Table2.table_id=Table1.table_id where Table2.samplevalue=100.00 and Table2.date_value>=$P!{p_t_finalstartdate} and Table2.date_value<=$P!{p_t_finalenddate} group by Table2.target having target='$P!{p_t_target_name}' Now in the output, it is showing the percentage values in the tabular format, but it is showing the table for each department (with its percentage value) instead of a single table. If I put this table in summary band, it is showing the percentage of only last department in the table. How it can be done in this case that it will show the complete data in the single table for all departments? Kindly provide your valuable suggestions. Regards, Balram Singh Deswal