Click to See Complete Forum and Search --> : crystal report help


jabbarsb
February 15th, 2007, 05:19 AM
hi friends,
I need to display a custom field in crystal reports the sql query is like this

SELECT transid, frdeptno ,frdeptname=(select deptname from dept where deptno=frdeptno),
frempno,frempname=(select username from users where userid=frempno), todeptno,todeptname=(select deptname from dept where deptno=todeptno),
toempno ,toempname=(select username from users where userid=toempno), mchcode
FROM transfermch

the fields frdeptname,frempname,todeptname,toempname how can i display these fields in crystal reports