Consultor Eletrônico



Kbase P147565: Error Field Name is unknown when running a Crystal Report
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   17/11/2009
Status: Unverified

SYMPTOM(s):

Error Field Name is unknown when running a Crystal Report

Error is reported when trying to group by a field

When RecordSelectionFormula method is used in 4GL report fails

Report does not work in Crystal Reports with 10.1C

FACT(s) (Environment):

Report works in Crystal Reports with 10.2A
Report works in design mode within Crystal Reports
Windows
OpenEdge 10.1C
Crystal Reports 11 (XI)

CAUSE:

Overriding catalog name in 4GL using both Location and SetTableLocation methods in the same program:
chReport:Database:Tables(i):Location = myDatabase.
chReport:Database:Tables(i):SetTableLocation(myDatabase,"","").


FIX:

Overriding catalog name in 4GL using Location or SetTableLocation methods cause problems when using a dynamic selection criteria in RecordSelectionFormula mehod. Use either Location or SetTableLocation method.