How to get Duuplicate Records out

[rico7937]

I have a s imple report that is pulling in records for oncall, below is the query:

{USERS.USER_ACTIVE_FLAG} = 1 and
{GROUPS.ACTIVE} = 1 and
{MEMBER_OF.GROUP_ID} Like 'IGS-VF*'
OR
{MEMBER_OF.GROUP_ID} Like 'VFC-*'


I cannot figure out why on the return of data that a individual names appears twice on the report. It does not happen to everyone just every so often there will be a duplicate of the entire data. Here is a sample of what I am talking about:

Group name User name User ID Phone E-Mail Addr.
IGS-VFC-D 897/I/4299// DSOLOM 1-91 1 dsolomon@us.
IGS-VFC-D 897/I/4299// DSOLOM 1-91 1 dsolomon@us.
IGS-VFC-D 897/I/5702// PECKCH 0 cpeck@us.
IGS-VFC-D 897/I/1590// MORIGE 1-30 1 morigeau@us.
IGS-VFC-D 897/I/6352// RUNDK 1-91 0 krund@us.
IGS-VFC-D 897/I/2788// SADLER 0-00 1 wtsadler@us.
IGS-VFC-D 897/I/4834// G4D283 1-91 1 gabbrown4@us.
IGS-VFC-D 897/I/7312// RLMATU 1-61 0 matus@us.

Any help or idea's would be greatly appreciated !

 

[lbass]

I'm guessing that you want the first two criteria to apply to all records, in which case, you must use parens:

{USERS.USER_ACTIVE_FLAG} = 1 and
{GROUPS.ACTIVE} = 1 and
(
{MEMBER_OF.GROUP_ID} Like 'IGS-VF*'OR
{MEMBER_OF.GROUP_ID} Like 'VFC-*'
)

However, that is probably not the issue causing the duplication. That's more likely to be the result of multiple records in one of the tables. If there should always be just one record, you could suppress the entire detail section (do not check the box) using a formula like this:

{table.username} = previous({table.username})

Or you could create a formula that concatenates all fields and then use that in a formula like the above instead of username.

Or you could group on username and place all fields in a group section and suppress the detail section.

-LB