I have had success with sub-reports in an Oracle environment. The main report on one form and the sub-report on another related form passing selection criteria.
Jim Rivers EES, LLC Contractor to the United States Department of Energy 1000 Independence Avenue, SW Washington, DC 20585 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Shafqat Ayaz Sent: Wednesday, April 25, 2012 9:34 AM To: [email protected] Subject: Re: Crystal report issue on joining the forms in crystal ** Hi Wirasat You cannot join forms in Crystal if you are using the ODBC driver. You have to create the join in Remedy and use that form to report off. If you want to create a join in Crystal then you have to use the database drivers. Shafqat Ayaz ________________________________ From: Wirasat Siddiqi <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> Sent: Wednesday, April 25, 2012 2:06 AM 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: [email protected]<mailto:[email protected]> _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"
