SSRS Report for multiple Contacts

(0) Share

Report

Posted on by RahulGupta1307

2,725

Hi,

First I will explain the data model.

I have 3 entities

1)Contact(Attributes:First Name,Last Name etc)

2)Possession(Attributes:ContactId,UtilityId,Possession %,Possesion Price)

3)Utility(Attributes:Name,Price

Contact has 1:N relationship with Possession entity and Utility also has 1:N relationship with Possession.Eventually Possession is acting a intermediate entity for N:N relationship between contact and Utility.

Example:John smith Contact can hold 100% Possession(Price:$1000) of a Laptop Utility($1000)

His wife Emily Smith contact also holds 100% because they rent it together on lease.If one of them dies/got bankrupt,the other one has to pay.

I have to generate a SSRS report for multiple contacts which will show contact,possession and Utility.And their total price of Possession.

I have to show Possession for either one of them,and not both of them(which creates a confusion for user)

*This post is locked for comments

All responses (1)

Answers (0)

David Jennaway 14,063 on at

Like (0)

Report

RE: SSRS Report for multiple Contacts

Can you clarify what you mean by 'I have to show Possession for either one of them,and not both of them' ? In your example, if John and Emily both hold 100% of the same utility, then do you want to show both records, or just one (and if it is just one, how do you decide which one) ?