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.