Hi, I am very new to jaspersoft, all help is very much appreciatted. I noticed that when I create a simple ad hoc view, Jaspersoft server generates a group by query, hence same is executed very fast. Once I create a report using jaspersoft studio (querying my server domain), and publish the report to jaspersoft server, same does not add the group by in the query to the database. Can someone please share with me how to create a report which generates a query with a group by clause? Jaspersoft Server and Studio version 6.0.1 PRO Many thanks, Amauri