[RESOLVED] subquery in cr?

[Besoup]

Hey,
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?

[Besoup]

Just created a view in my SQL DB and linked it with the table... worked fine.