Hi group! We are running a helpdesk system on the intranet. People have the possibility sending in a service request which is routed to the right person. I'm having trouble finding a good solution for a group by with two files: - service request file (seqnr, username, description, reqdate, solvedate) - users file (seqnr, username, full name, dept) When I perform a group by JUST on the service request file, there's no problem whatsoever. But......I would like to have the full name, department, telephonenr, etcetera on the report header as well. The reportgenerator I'm using is iReport. In this program it is possible to use the group by as a trigger for sending a page break. This way all requests are printed with their "rightfull owner". Of course, I want to use the username (which is unique) as a group by trigger, but the sql statement issues an error message when I include fields of the users file. Here is the sql-statement I'm using: SELECT s.*, u.* FROM servicereq s, users u WHERE s.username = u.username GROUP BY s.username ORDER BY s.seqnr Of course the "select star" is not being used, but it's only used here for readability. My question is: how do I trigger the page break as soon as the user changes? Or should I use the sql statement in a different way? I hope you can help this novice. /tools/fckeditor/editor/images/smiley/msn/embaressed_smile.gif Thanks in advance for your help. Kind regards / Med vennlig hilsen, Ton
