Skip to Content
avatar image
Former Member

CRYSTAL REPORT CHECK LAYOUT ERROR

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 06, 2017 at 12:02 PM

    Hi Socrates

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2017 at 12:51 PM

    Hi,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2017 at 03:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded