Print Page | Close Window

Data from Accpac ERP

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1535
Printed Date: 03 May 2025 at 8:24pm


Topic: Data from Accpac ERP
Posted By: raha_mtl
Subject: Data from Accpac ERP
Date Posted: 19 Oct 2007 at 1:49pm
Hi,
 
I'm not very smart in crystal yet. I'm just beginning to use it.
 

My customized report is for OE Forms/Invoices. I use the OEINPR3.DLL  and ODBC data for OEINVHO and CSOPT for recuperating the optional field description (CSOPT.DATA).

When I do my select expert, this is the formula I have :

 

{OEINVHO.INVUNIQ} = {?Pm-OEINPR3.INVUNIQ}  and

{OEINVHO.OPTFIELD} = "DISCHARGE" and

{CSOPT.CODE} = {?Pm-OEINPR3.CUSVALUE}

 

I did this relation. When I’m in the tab of subreport, when I do Browse Field data, it gives me a window with the list of data that I want to display from the subreport into the primary report.

When I save it and run report, it doesn’t display on the primary report.

Why?




Print Page | Close Window