Print Page | Close Window

Pull multiple ID & Name from same table Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22116 Printed Date: 28 Apr 2024 at 4:14pm Topic: Pull multiple ID & Name from same table Posted By: carstowal Subject: Pull multiple ID & Name from same table Date Posted: 18 Oct 2016 at 4:46am CR 2013 SP1 Version 14.1.1.1036 Table1 has a Modified_User_ID & a Created_By_User_ID. The User_ID is linked to the table Users which has IDs & Names. If I insert the Users table twice to link both Modified & CreatedBy User_ID to obtain their full names it duplicates the rows in my details. Is there another way to look up BOTH Users Name in table Users from their IDs in Table1? Replies: Posted By: hilfy Date Posted: 07 Dec 2016 at 10:43am Does your Users table have multiple records per user? That's the only way you would end up with duplicate details unless you have multiple Modified and Created users for an item in Table1. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Print Page | Close Window