Run Datapipe Reports in Report Runner
To run a datapipe report in Report Runner, you need to:
1. Update ebrpt.ini
Add 3 lines to the EBRPT.ini file in the customization directory: type, datapipe path and datapipe query.
Tip: You can copy the Datapipe query to copy from the source module rpt.ini. For example, for an I/C report , use icrpt.ini, for a G/L report, use glrpt.ini, etc).
If you receive an error "Table xxxx could not be found" when running the report as following :
“Error – Description : Crystal Reports Error : The Table XXXX could not be found. Error in file ZZZZZ.rpt. The Table could not be found.”, where ZZZZ.rpt is the report you are running and the XXXXX is the dll file, you will need to copy the data query from the source rpt.ini into ebrpt.ini.
2. Copy the actual dll file
Copy the dll used in the report from the Sage 300 programs files into the custom folder\EBXXA.
I/C VALUATION REPORT
ICVAL03 is using ICVALUP.dll, so you need to copy this DLL into EBXXA in the Report Runner Customisation directory.
Type and datapipe path, you can update as below.
I/C Valuation Report datapipe
Type and datapipe path, you can update as below.
type=datapipe
datapipe path=..\
datapipe query='icvalup.dll=ICVALU03\n%REPORTTYPE%\n1\n%INCLUDEQTY%\n%INCLUDECOST%\n%SORT2%
%SORT1%\n%SORT2MIN%\n%SORT2MAX%\n%SORT1MIN%\n%SORT1MAX%\n%ACCOUNTMIN%\n%ACCOUNTMAX%\n%HOMECUR%\
n%SORTDESC%\n%VALU1%\n%VALU2%\n%VALU3%\n%VALU4%\n0'
Troubleshooting
If you receive an error along the lines of : “A4WDP_OpenDataDictionary, ERROR:LoadLibrary <customisation path\xxxx.dll> returned 0 error = 0”
where xxxx is the report name you are running through Report Runner, it means you are running a datapipe report through report runner and the associated dll for the datapipe has not been copied to the customisation directory.
G/L Transaction Listing, you get the error
.. A4WDP.c – line 372
Followed by
A4WDP_OpenDataDictionary, ERROR:LoadLibrary <c:\Reports\EB62\ENG\..\GLPTL.dll> returned 0 error = 0”
You need to copy the glptl.dll file from ..\Sage install folder\glxxa to c:\reports\EBxxA where “C:\Reports” is the customisation directory entered on the Information Manager Options tab.
Order Action Report -
Table OEACTN.dll is the source data in OEORDACS (Order Action) report.
Open OERPT.ini, locate the OEORDACS report section and copy and paste the datapipe query line from OERPT.ini into EBRPT.ini in the customization directory.
type=datapipe
datapipe path=..\
datapipe query="oeactn.dll=OEORDACD\n%ORDERTYPE%\n%PRINTSTATUS%\n%ITEMSTATUS%
\n%SORTBY%\n%STARTSORT%\n%ENDSORT%\n1\n%FROMSHPDATE%
\n%TOSHPDATE%\n%SOURCECURR%\n%ORDSOURCE%\n"After upgrading
It is recommended to copy the latest datapipe dll from the source Sage 300 folder into the new customization directory.
Refer to Upgrade Information Manager Tips
