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..
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
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.