Hello...I am newbie designing crystal reports. So, advanced apologies, if this comes across as the most silliest question you have ever heard!
I have a table called Issues. These Issues are logged by people in the Service Desk team.
The issues are then resolved and finally closed by people in the App Support Team.
My table design is as follows -
Table - Issues
Issue_Id (Primary Key)
Issue_Description
Logged_By
Closed_By
Table - Users
Users_Id
Users_Name
Now, the Issues table is related to Users table where Logged_By and Closed_By of Issues table is referencing the Users_Id column of the Users table.
In my report, I need the following.
1. Issue_Description
2. Logged_By
3. Closed_By
How do I do it?
What I attempted so far.
Defined the relation between Issues and Users for Logged_by and it fetches the binary value of Users_id instead of Users_Name.
How do I get the Users_Name? Do I define it in the Special field and define a formula?
How do I link Issues table to Users table for 2 fields from Issues table to the same users_id field in the users table.
Needless to say, issues will be logged by one person and closed by a completely different person.
Any help is greatly appreciated!
IP Logged
