Re: REPORTS COMING OUT WRONG

bbourass@natick-amed02.army.mil wrote: : We are having a problem with our reports. Up until December everything had : bee okay with the reports. The data is all right ( when we pull the date in : a search we get the correct number of rows). : But when we print tat data in a report it gives us two sometime three rows, : as if we had the data in several times. : What are we doing wrong. A couple things to try (if you haven't already): 1) Try the very same select statement(s) in dbaccess to make sure you don't have a join that is causing a row to be selected more than once. B) Replace the FOREACH with a specific loop and see if duplicate rows still come through (this will confirm that the problem is in the code, not in the data). iii) See that improper use of a group or page header isn't causing the problem. Comment out all header blocks (keep only ON EVERY ROW if possible). $) How many times is OUTPUT TO REPORT called? Don't assume once because the line of code appears only once. With looping, etc. maybe you're calling it more than you think. LAST) Send me a copy of the report and I'll see if I see anything obvious. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Principal Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.