I'm creating a report and I'm getting some duplicates. how can i reffer only to to one of the items in the group? it can be dine by "GROUP BY" in sql but when I try to change the Query it just disregards the "GROUP BY".
what should I do?
Can you verify that the linking between the tables is accurate? Inappropriate linking will produce duplicate data.
Alternatively, if the links are correct, you could create a group in the report, and place your data in the group footer instead of the details section, which will return the last value per group returned from the database. You could also use the previous or next functions to produce the same thing.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.