Skip to Content
0

CRYSTAL REPORT CHECK LAYOUT ERROR

Nov 06, 2017 at 06:40 AM

56

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Aziz El Mir Nov 06, 2017 at 12:02 PM
0

Hi Socrates

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Aziz El Mir,

Already Using my server name.

best regards

soc

0

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

0
Nagarajan K Nov 06, 2017 at 12:51 PM
0

Hi,

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

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Errors? No Sir

0
Dell Stinnett-Christy Nov 09, 2017 at 03:26 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded