I have a report that is grouped by a field named Exec_Number. Now this number corrosponds to another field in the table called Agent_Number. On grouping level I need to get display the Agent_Name who's Agent_Number = the group's Exec_Number.
Anyone know how I would do this in crystal?
Just created a view in my SQL DB and linked it with the table... worked fine.