suppressing problem: 1

[pandy1]

Hi,

I have some data like this:

name id
abc 1
abc 2
abc 1
abc 1

i would like to display the records based on the criteria: I want to have only id:1 but if that name has other id's also along with id:1 , then i dont need that data or entire group with name:abc

in that case i dont want the above data.

another example:

name id
xyz 1
xyz 1
xyz 1


here i have 3 records in that group, i want this data because it has only id :1 no other ID's. can anybody help me how to solve this.

Thanks
pandy

 

[lbass]

Assuming you have a group on {table.name}, go to report->edit selection criteria->GROUP and enter:

distinctcount({table.id},{table.name}) = 1 and
{table.id} = 1

-LB

 

[pandy1]

Thank you lbass for the valuable tip. It worked very well.

Thanks
pandy