Records with Same Address

[sys2674]

Hi ,
I have a requirement where I need to display records with same adress. Address will be Address1, City and State.
Can any one please let me know how can this be ahieved.

Thanks in advance..

[RKMI]

Hi,

Can you provide more details?

If are trying to change and hardcode like a list colum data then you can click on the text source change it from data item value to text and input a value you like. (or) you can even input it in a data item with a hardcoded value ie. 'Address' then pull in the data item and you should see it.

Thanks,
RK

[globalbear]

Try this: concatenate all address fields (Address1, City, State) into one new field called Address_combined or somehting like that.
Then create a list where you pull in Address_combined and then the "not-unique" field such as customer_name or what have you.
Group the list on Address_combined.

Create a new data item called no_of_names. The definition should be count([Customer_name] for [Address_combined])
This new item will count the number of names for each distinct address line.
Finally put a detail filter like no_of _names > 1.

Run the report.

You will get a list of all distinct addresses with more than one customer grouped by address.
If you don't filter the list of no_of_names > 1 you will have all address lines in the report even if they have only one customer.