Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Field name is not known in custom reports

Posted on by Microsoft Employee

We are in the middle of an upgrade from SL 7.0 FP1 SP4 to SL 2011.  MANY of the custom reports migrated throw the following error:

'This field name is not known'

I have opened the reports, reset the database and still receive the error.  Anyone have any thoughts as to what might cause this behavior?

  • Ibrahim Hajat Profile Picture
    Ibrahim Hajat 15 on at
    Re: Field name is not known in custom reports

    Hi, We have tried that as well but still same error.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Field name is not known in custom reports

    I've found that sometimes you have to do each individual table/view in the report to reset the datasource location.  Use the Verify Database option when done to double check.

  • Ibrahim Hajat Profile Picture
    Ibrahim Hajat 15 on at
    Re: Field name is not known in custom reports

    Hi,

    I have the same issue on an upgrade. All custom reports are giving 'This field name is not known' error.

    I have tried setting the datasource location, removing the existing ODBC connections. But sill not working.

    Any ideas?

  • Re: Field name is not known in custom reports

    Dear Kyle,

    Are the custom reports attached to custom tables or views? Have you reset the datasource location on the custom tables/views?

    1) Start Crystal Reports 10 for Solomon

    2) Click Open, select custom report, and then click Open.

    3) On the Database menu, click Set Datasource Location.

    4) In the top pane click on the database name (icon looks like a yellow cylinder with a plug)

    5) In the bottom pane drop down the Create New Connection folder

    6) Then drop down the ODBC (RDO)

    7) A dialogue box will appear. Choose your application database. Click Next

    8) Log into the database using SA

    9) Click Finish

    10) Still in the bottom pane click the database name (icon looks like a yellow cylinder with a plug)

    11) This will enable the Update button. Click the Update button

    12) You will notice your top pane's database will change to your application database.

    13) If the top pane has any other databases listed highlight the database and click the update button

    14) You should only have one database listed in the top pane.

    Now you have to update the SUBREPORTS as well , use the new connection you made in the steps above. Highlight the database that shows under SUBREPORTS  

    while you have your new database connection selected in the bottom pane and click Update.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans