Accpac ComAPI asking for parameters

Question

Hi, 
 I have written a console app in C# to export Purchase Orders to PDF. When using the standard Crystal file that ships with Sage 300 (POPOR01.rpt), the export works perfectly fine without requiring user intervention. 
 If, however, i change to the crystal file specific to Pacific Workflow (PTPOR04.rpt), a pop up shows asking for the parameters PORFROM,PORTO, QTYDEC and REPRINTPOS. 
 I have set all 4 these parameters in my code: 
 rpt.SetParam("PORFROM", item.PoOrderNum); -- Here I loop through a list of PO Numbers rpt.SetParam("PORTO", item.PoOrderNum); 
 rpt.SetParam("REPRINTPOS", "1"); 
 rpt.SetParam("QTYDEC", "2"); 
 It still asks for the parameters, even though they are set in code. I have check the sub reports and none of the sub reports require these 4 parameters. 
 Has anybody ever experienced a similar issue?

Django · Accepted Answer

You've commented out the line that tells Sage what section to use. 
 If the PTPOR04 section has a line within it that says 
 Crystal=PRPOR04.RPT then you can just use: 
 rpt = session.ReportSelect("PTPOR04", " ", " "); 
 If you need to override the Crystal report that you want Sage to use you can do this: 
 rpt = session.ReportSelect("PTPOR04[PTPOR04.rpt]", " ", " "); 
 What did the macro look like when you recorded a macro of you printing the purchase order from within the PW screen? 
 And for the registry entry it looks like I gave you the wrong setting: It should be set to "D" 
 smist08.wordpress.com/.../

Sage 300

Accpac ComAPI asking for parameters

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING