web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Field name is not know...
Microsoft Dynamics SL (Archived)

Field name is not known in custom reports

(0) ShareShare
ReportReport
Posted on by Community Member

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?

*This post is locked for comments

I have the same question (0)
  • Jana Glaser-MacDonald Profile Picture
    Jana Glaser-MacDonald on at

    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.

  • Ibrahim Hajat Profile Picture
    Ibrahim Hajat 15 on at

    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?

  • Community Member Profile Picture
    Community Member on at

    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

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans