JR Server: How to allow user to input time parameters for grouping data in report

Question

I am new to JasperReports Server.

I have a report which is grouped on time interval.

I want to user give the input to group the data in minutes, hours or days. Based on the user input, report must group the records accordingly.

I am not able to figure out the way. Please help.

@AlexK Yes, I have developed a report using ireport and running using JR server — Prashant, Sep 17 '12 at 07:24

score 0 · Answer 1 · answered Nov 23 '12 at 05:54

Create a input control "p_days" and add this line in select statement of your query

 SELECT days,hours,minutes,
 if($P{p_days} is null, days, hours) p_groupby
 FROM table_name
 GROUP BY p_groupby
 ORDER BY p_groupby

but this will work for only days and hours.

1 Answers1