1 of 1 people found this helpful
So in Crystal it's all dependent on your links from the tables. If you are pretty certain you've made the correct links, it just means the linking options could be wrong. Try setting your linking options to Full Outer Join or Left Inner Join. I typically use Full Outer Join and it'll pull everything including blank fields.
I've had this same thing happen when trying to pull "Current Assignment.Group" and if there is no Group Assigned, it'll show blank data. Setting the link options helped.
Hi Jamie, Please can you tell me what the red color is on the link in a table. I went to Database Expert option and I added the table that I needed then when I click the tab that says 'Links' I scrolled down to the table that I added I saw the link connection (without an arrow at both ends) and the attribute usr_guid on the table I added has a color red. When I saved the rpt and tried it, it error out. Thank you very much.
Thank you so much. I took everything out and added the tables one by one then created the links your suggested left inner join. It is now working. I have another issue though which I am going to raise a question in a short while.
Thank you again, so very much.