Reprint Posted Invoices ICR

[Maz61]

Does anyone know where I can get a copy of this ICR for Progression MS-SQL 7.7? The report name is OEINVFRMSQL.rpt
I am running 7.6.400 and that report does not seem to work with Crystal XI. According to Exact, they have been modified to work with Crystal XI in 7.7. Thanks.

 

[dgillz]

Crystal XI can open this report, then simply save it. You will be prompted to update the report to the current version. Answer YES.

This report will not be able to run from the Macola interface, however you should be able to run it stand alone from the Crystal XI designer.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Maz61]

When I run this report from Crystal XI, I get an error message that reads Formatting formulas must be print-time formulas. I get the same error when I try to run it using Visual CUT 11, which is what I am trying to do. According to Exact Doc ID 18.433.240, the formulas were fixed in the version that installs with 7.7. I guess if need be, I can install 7.7 on a test machine and get the report that way.

 

[dgillz]

Typically if something must be a print time formula, you preceed the formula with this line:

WhilePrintingRecords;

Realize of course that VB is likely doing all of this, it is only when you take the report outside of the VB project that you get this error.

If that doesn't work, please post back.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Maz61]

The following is the formula which generated the error. I replaced beforereadingrecords with whileprintingrecords and it seemed to have worked.

// this function returns the feature and kit components literal
// from the defaults storage. The feature and kit components
// literal must internationlized within code, if needed, prior
// to running the report.

beforereadingrecords;
if MACOLADefaultFileExists ({@DefaultFileName}) and
MACOLADefaultFileValue ({@DefaultFileName}, "Literals", "FeatureKitComponentsLit") <> "" THEN
MACOLADefaultFileValue ({@DefaultFileName}, "Literals", "FeatureKitComponentsLit")
Else
"Feature/Kit Components";

 

[Maz61]

Just printed some invoices and noticed that the report is missing data. I need to get the report from 7.7 that was modified by Macola.

 

[dgillz]

What is missing?

I took the "BeforeReadingRecords" formula and hard coded them, as there will never be a defaultfileexists() when running this report outside of Macola's VBA wrapper.

In other words, in your formula above I would use:
"Feature/Kit Components"

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Maz61]

That explains it. I didn't know what the defaultfileexists() function was until now. I was working on it this afternoon and was hard coding data into those fields. Thanks for clearing that up. All is working now.

 

[dgillz]

If I recall, there are several conditional formats using these same formula fields. I would revisit all conditional formats everywhere in the report.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Maz61]

Thank you for all your help on this.

 

[dgillz]

One other point on conditionally suppressed sections. A good example is the section where kit components are displayed via a subreport. If you never use kit items, just delete the section to simplify the report.

Same goes for the section for Serial/bin/lot data, POP and SF features, etc.



Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Maz61]

Thanks. Now I have to figure out why it's not working in Visual CUT.

 

[crystalreporting]

Is it not previewing in Visual Cut or not bursting? If it's not bursting, then the number 1 reason for this is that you must have the actual field in the group #1 section i.e. if your report is grouped by customer number, then the field cus_no must be in the GH section.

Typically if I were using Visual Cut to burst, export and email invoices I would create an invoice from scratch rather than try and build off of the canned report.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[Maz61]

The report runs fine on my test machine but doesn't on my production machine. I am getting "UFL u2lcom.dll that implements this function is missing." when I run it. I tried copying that dll over and registering it but it won't register.

 

[dgillz]

u2lcom.dll is the file that crystal uses to handle all UFLs. You don't need to do anything with this file.

The files in question are cruflma.dll and cruflba.dll in the c:\program files\common files\Macola shared folder. Copy them over and register them to the other machine.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Actually another way to do this is to install the Macola client on your production machine. This should install and register these files automatically.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Maz61]

Registering those 2 files did it. Thank you so much!!