HI, I created a report in Jaspersoft Studio using the objects layer from CA, I need to show in my report the only last solution for a ticket. I know that it's in the object casd.alg and I join this table and casd.cr but the result is rows duplicated i need a report lke this:
ticket last_solution
cr.ref_num alg.description
Please help me.