Re: REPORTS COMING OUT WRONG

You've not given us enough to go on, but the most probable trouble is that your SELECT statements are returning multiple rows, somehow. We'd need to see those SELECT statements, unfortunately. But you could test this by extracting them from your code (or, you could use SET EXPLAIN ON and look in the sqexplain.out file to get the actual query or queries being executed), and then running those queries and looking at the data that the raw queries return. I'd guess that some table has acquired extra rows which were not there last year, and you haven't got enough filtering conditions on you SELECT to remove the redundancies. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: bbourass@natick-amed02.army.mil >Date: Fri, 2 Feb 96 9:32:42 -0500 >X-Informix-List-Id: <list.8599> > >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.