Jun 20th, 2006, 09:04 AM
[RESOLVED] subquery in cr?
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?
Jun 21st, 2006, 11:02 AM
Re: [RESOLVED] subquery in cr?
Just created a view in my SQL DB and linked it with the table... worked fine.
Click Here to Expand Forum to Full Width