my generic answer to any report is to create a stored procedure to do the work for you. Crystal is very limited in what it can do, but stored procs aren't. You can easily get all the bugs in one temp table, mark the ones that are completed and return all the ones that aren't to the report or any combination of information that you want. To make your life the easiest, put all the data for all the parts of your report in one dataline, and life is usually pretty easy (at least it works for me).
It all starts with the stored proc, which gives you a much greater degree of flexiblity to get your task accomplished.
I know this is very general, but it's also why we have jobs....cause not everyone can create the reports that they want.
HTH
IP Logged
