You’re offline. This is a read only version of the page.
Announcements
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
Hi, We have tried that as well but still same error.
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.
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?
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.
#1
André Arnaud de Cal...
293,998
Super User 2025 Season 1
#2
Martin Dráb
232,850
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
