i have dats like Name sex race relationshipind addrind birthdate the relationshipind indicates whether the relation is mom, dad, etc, similarly addrind is used to see whose address it is i want to build a SSRS dashbord where someone could search for a name and the add, birthdate , mother, father, brother and their asddress are shown for all the related name searches, is it possible id appreciate if anyone can provide me with tips on whether i can directly do it in database and ssrs or do i have to connect ssrs to a cibe. in that case, what shud be teh fact table design <input id="19526558-060f-441a-93f2-6729c849d079_attachments" type="hidden" />