daydaytrack

The where clause isn't where the issue is. When I removed it, the issue persisted. I eventually found that the issue was in the code below, but for some reason I can't see what the issue is. round(SUM(get_minutes(least(end_datetime, $P!{pEndDate}), greatest(begin_datetime, $P!{pBeginDate}))) / 60, 2) AS Total_Hours

Hello, it says i'm missing the right parenthesis in this SQL statement in my JasperStudio. I don't see it and I need some help. Below is the statement on my report. SELECT vs.b_c, vs.s_c, vs.R_N, vtc.D_S, dvl.M_C, dvl.R_F, dvl.B_C, dvl.R_M, dvl.S_E, round(SUM(get_minutes(least(end_datetime, $P!{pEndDate}), greatest(begin_datetime, $P!{pBeginDate}))) / 60, 2) AS Total_Hours -- if they want to know the number of maintenance events uncomment the line below -- count(*) as Number_of_Events -- not in the spec but I think it should be FROM Vehicle vs, dispatch dvl, Miracle_car mc, vehicle_type_controller vtc WHERE $P!{pWhereClause} Please give me some guidance :(