thanks iamsupergrasya
i got the problem solved by exporting an invisible datagridview to a csv file and at the same time grouping the customers by surname and inserting a blank row.i then import from the same csv file into another datagridview that is visible.from there on its just printing and the data in the database remains unmodified.
kleinyster