CRYSTAL REPORT CHECK LAYOUT ERROR

[Former Member]

Hi,

The Check Layout that is forwarded to us is running fine for crystal client.

After publishing the layout or importing the layout to SAP, it throws below error.

This Field name is not known.

Details: errorKind

Error in File VPM10005{02742be5-a465-4d5c-adf9-bd248aa9f45f}

{F6AEBB3D-4EE0-4280-AA09-356CE9CD9278.}rpt

Error in Formula AmountInWords:

"*' + Replace (ProperCase(ToWords({Command.CheckSum})) + Pesos Only*','Xx''00')'

This Field name is not known.

Details: errorKind

I have already tried the following.

1. Executed the report in Crystal report and it executes fine.

2. Executed the report in Preview External Crystal Reports file in SAP works Fine.

3. Executed the report query in respective schema and it works fine.

4. Set DataSource Location

5. Verify Datebase

and gets the same error.

Any help is much appreciated.

Please see attached for the error.

[DellSC]

As requested above, please post the SQL from the command. Also, is it possible for {Command.Checksum} to be null? That might be causing the issue. When you're testing, you need to make sure you're testing with the same parameters that your SAP system uses when you see the error.

-Dell

[kothandaraman_nagarajan]

Hi,

Are you getting when you run stored procedure in SQL server? I think the field is not valid.

Regards,

Nagarajan

[Former Member]

Errors? No Sir

[azizelmir]

Hi Socrates

Try to use the Server Name Indication instead of the server IP address in the Crystal Report/set Datasource location.

[Former Member]

Hi Aziz El Mir,

Already Using my server name.

best regards

soc

[azizelmir]

Could you please provide us with the SQL query you are using from the Crystal report / command box?