sql question

HI; I HAVE COME ACROSS ONE PROBLEM IN SQL. IF ANYBODY COULD HELP ME OUT, I WILL APPRECIATE YOUR EFFORT. HERE IS MY PROBLEM: I HAVE A DATABASE OF 50 PATIENTS. EACH PATIENT HAS UNIQUE ID NUMBER. I ALSO HAVE A BATCH NUMBER FOR EACH PATIENT, THERE ARE TWO BATCHES FOR ALL 50 PEOPLE (25 IN EACH BATCH). I WROTE AN ACE REPORT TO CHECK IF-THEN-ELSE STATEMENTS FOR 10 DIFFERENT FIELDS WITHIN THE DATABASE. I WANT TO PRINT THE HEADER ON EACH PAGE FOR EACH PATIENT IF ANY ONE OF THE IF-THEN-ELSE STATEMENT IS TRUE. I WOULD ALSO LIKE TO PRINT THE FIELD NAME WHERE IF-THEN IS TRUE (ALL IN ONE PAGE) IF ALL MY IF-THEN STATEMENTS ARE FALSE, I DONT WANT TO PRINT ANYTHING (NOT THE HEADER INFORMATION EITHER.) WHEN I RUN MY REPORT, (PER BATCH), I GET 25 PRINTED PAGES OF WHICH ONLY 4 PAGES HAVE THE INFORMATION THAT I NEED. 21 PAGES ARE WASTAGE. ON THOSE 21 PAGES ALL I GET IS THEADER INFORMATION (THE FIELDS ARE ALL FALSE THEREFORE THEY DONT PRINT). I WANT TO PRINT ONLY 4 PAGES WITH HEADER AND ALL THE FIELD NAMES THAT MATCH IF-THEN (TRUE). I WANT TO PRINT ONLY HEADER INFORMATION AND THE ALL THE FIELDS THAT ARE TRUE ON ONE PAGE. IF FOR ANY ROW ALL THE FIELDS ARE FALSE, I DONT WANT HEADER PRINTED. I TRIED VARIOUS THINGS, BUT NONE WORKED. HOPE SOMEONE CAN HELP.. CALLED TECH. HELP AT INFORMIX TWICE, BUT THEY WERE NO HELP AT ALL. I HOPE I HAVE EXPLAINED THE PROBLEM WELL. HERE IS PART OF MY REPORT: DATABASE RADC END SELECT * FROM RAD101 WHERE BATCH_ID = "0312" ORDER BY PAT_IDFORMAT PAGE HEADER PRINT COLUMN 25, "LOGIC CHECK REPORT" SKIP 1 LINE PRINT COLUMN 25, "RESEARCH DEPARTMENT" PRINT COLUMN 10, BATCH_ID SKIP 3 LINES PRINT COLUMN 10, PAT_ID ON EVERY ROW IF FIELD_1 = "1" THEN PRINT "FIELD_1" ELSE IF FIELD_1 = "2" THEN PRINT "FIELD_1" (FIELD_1 HAS 1,2,3 POSSIBLE VALUE) .... I HAVE 10 SIMILAR IF-THEN-ELSE AT THE END I HAVE SKIP TO TOP OF PAGE END THANKS IN ADVANCE RAKESH GOYAL PS: YOU MAY REPLY TO GOYAL@CRHA.RPSLMC.EDU OR INFORMIX@CRHA.RPSLMC.EDU