With a universe as your data connection, there may not be much you can do about it as the universe controls how the SQL is generated. Here are a couple of things you can try:
- Check on your Database menu - if "Select Distinct Records" is checked, then uncheck it.
- Is there a field that might contain a value that would make the records from one part of the union different from those in the other? If so, put that field on your report and change its text color to white so that you can't actually see it. This way it will be included in the query and will force the records that are duplicates in all of their other fields to display.
-Dell
IP Logged
