Crystal Reports errors

[jaustill]

Macola Progression 7.7.0.0 running on a mssql 2000 server with ICR version 11

After update, MOST of the ICR's (crystal reports) run fine, however a few will not run and start with the following error.
"Reprint Posted Invoices" gives an error "MacCROut.Change Location-2147189180 The table 'PPORDFIL_SQL' could not be found. Step4" followed by the same error for SFORDFIL_SQL.

I do not have either of these two tables in mssql and I do not use/have licensed Production Orders Processing.
The reports DO WORK in the Demo database.

Any thoughts

 

[crystalreporting]

Check document 17.414.424 on the Exact Portal. In a nutshell they suggest turning the modules on to force the tables to be created, then turning the modules off immediately afterwards. I can't recall if that's possible if you're not licensed for the module. If not, you could always SQL DTS the missing tables from the demo company to your production database.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.srhconsulting.com

 

[jaustill]

Thanks, worked like a charm