Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Data from Accpac ERP Post Reply Post New Topic
Author Message
raha_mtl
Newbie
Newbie


Joined: 19 Oct 2007
Location: Canada
Online Status: Offline
Posts: 2
Quote raha_mtl Replybullet Topic: Data from Accpac ERP
    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?

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.