I've a big issue I don't know how to manage this with report builder 2.0
I've four table.
- SystemUser (systemUserId)
- FilteredContact (onwerid, owneridname, contactid, lastname..)
- FilteredAppointment (ownerid, stateCode, Subject, ActivityId, CreatedBy, OwnerIdName..)
- FilteredActivityParty (ActivityId, PartyId, participationTypeMask...)
So basicly the user can create contact, so it becomes the owner of the contact.
And user can create appointments, but need to choose a contact as required to the appointment. This contact can be created by the current user or not.
So FilteredContact.contactID = FilteredActivityParty.partyId , as a contact is in a list of activityParty.
FilteredAppointment.activityId = FilteredActivityParty.activityId
So FilteredSystemUser.systemUserId = FilteredContact.ownerId
FilteredAppointment.activity.ownerId = FilteredContact.contactId
With all that, I need to get by FilteredSystemUser.systemUserId, the amount of FilteredContact that Im the owner and I need to know how many people(partyid) where Filteredappointment.ownerId=Filteredsystemuser.systemuserid.
And I cant find a way to manage this without two datasets. I've no idea how to link thus two datasets between them.
Thanks for your help
View Complete Post