I believe the ODBC driver does not support you joining forms within Crystal. You must define the join in Remedy first, then you can report on it via Crystal. Terry
_____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Tuesday, April 24, 2012 9:06 PM To: arslist@ARSLIST.ORG Subject: Crystal report issue on joining the forms in crystal ** I am trying to create a crystal report using AR System ODBC driver. I can connect to ARSyetm database fine and can access all the tables. However, when I try to create the report using join between two tables in crystal, it does not return any data, We are using SQL Server 2008 R2 database. Has anyone experienced this issue? Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"